Thread: [SOLVED] FOR, IF, NEXT... Error in VBA while attempting a simple code.
View Single Post
  #10  
Old 01-10-2009, 06:45 PM
broro183 broro183 is offline
Forum Guru
  
Join Date: 03 Jan 2006
Location: London :-)
MS Office Version:2003 (work) & 2007 (home)
Posts: 1,825
broro183 is very confident of their ability broro183 is very confident of their ability broro183 is very confident of their ability broro183 is very confident of their ability
Beauty, pleased I could help :-)

btw, you may be able to get your code to run much quicker (w/o having seen it) if you move some or all your conditions out of the code & (depending on actual details) put them into a single boolean helper column &/or then limit your range to be looped through using something like Advanced Filter/AutoFilter/xlspecialcells.
If you want someone to glance over your code for potential optimisation you could post a sample file in a new thread (I reckon this one's done & dusted now + you've marked it as solved).

Rob
__________________
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
Reply With Quote