Macro to use find command
 

I would like to create a macro that uses the find command and searches
the entire spreadsheet to the end. The end of the spreadsheet will be
different each month. Thank you for any assistance you may have.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Macro to use find command
 

a simple one
x=cells.find("Joe").address

"Clys" wrote in message
...
I would like to create a macro that uses the find command and searches
the entire spreadsheet to the end. The end of the spreadsheet will be
different each month. Thank you for any assistance you may have.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/