View Single Post
 
Old 01-30-2015, 12:17 AM
Guessed's Avatar
Guessed Guessed is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,646
Guessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to beholdGuessed is a splendid one to behold
Default

Yes, it is quite simple to set a range and then do the find on the range rather than the selection. All your code could be a lot cleaner if we didn't need to rely on the selection changing to do the work. This is why ranges preferred to selections in most vba code.

Can we see what you are doing in the Caption and Table1 macros so those can be converted to use ranges?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote