View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Ken is offline
external usenet poster
 
Posts: 590
Default I want to create a macro that opens the Find Box on the sheet

I want to create a macro that opens the find box in excel and then I can type
in anything I want to find. I don't want to use the edit find to open this
box in excel. I have tried recording a macro to do this but when I rerun the
macro it doesn't open the find box or if it does it doesn't stay open for me
to type in the number I want to find. The number I want to find will always
be different so I can't write that number into the macro, can anyone ghelp me
with this please