View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Macro won't work today?!?

Always nice to post your code.

"Ed" wrote in message
...
I have a macro in my Personal.xls that pops up an input box to get a text
string, then searches every cell of each row of the active worksheet for
that text. If the text is not found anywhere in that row, the row is

hidden
and the code searches the next row.

Only today it won't work?!? The input box comes up, but the search hides
*EVERY* row - even when I can see the word I'm searching for right on the
screen!! The only thing I've done is copy this code as a whole block into
the worksheet module of another workbook. I haven't fiddled with the
original code.

So why isn't it working? Any ideas?

Ed