Guess you need to read everybody's response.

--
Regards,
Tom Ogilvy


"davegb" wrote in message
ups.com...
I did some more testing. When I run the macro on other sheets in the
workbook (the ones the macro can't find when run from the first sheet),
I get "Range method of object failed" on

WkSht.Range(Columns(lColTop), Columns("AC")).Hidden =
True

I watched the values for both lColTop and the found cell and both are
correct. Any ideas?
Thanks for the help.