View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
davegb davegb is offline
external usenet poster
 
Posts: 573
Default 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.