If you're not looking at the sheet "Master" when you run the macro, then you
will need to change that line to something like:
Set objWS = Activeworkbook.Worksheets("Master")
(That would work even if you WERE looking at "Master" as well.)
--
Hmm...they have the Internet on COMPUTERS now!
"Darin Kramer" wrote:
Thanks - it may work :) - Im playing now... but if I want it to run on
the sheet called master, do i need to change this line:
Set objWS = ActiveWorkbook.ActiveSheet
What would the syntax be...?
Thanks, appreciate your assistance.
Kind Regards
D
*** Sent via Developersdex http://www.developersdex.com ***