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

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

'------ this way is quite time & resource consuming
activecell.Value = "test"

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

Reply With Quote