View Single Post
  #4 (permalink)  
Old December 19th, 2005, 01:27 AM
ix_ly ix_ly is offline
Registered User
 
Join Date: Oct 2005
Location: :), :), Malaysia.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to ix_ly Send a message via MSN to ix_ly
Default

One way of speeding up the process of macro is process the data without select it.

Example:
'------ this way is quite time & resource consuming
Range("A1").Select
activecell.Value = "test"

'------ this way is quite faster
cells(1,1).value = "test"

ix
Reply With Quote