hide columns from find
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.
|