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 ***