Find/Search Excel Macro
Posted by Andy G. on August 13, 2001 8:10 AM
I'm trying to write simple excel macro that will allow a user to type in a 10 digit part number, and that will then search the entire spreadsheet for that number and activate or take the user to that cell.
I was trying to record a macro where it copied the value (10-digit part number) from a certain cell and then pasted that value into the "find" function and excuted this. However, it always uses the original value (part number) that I copied when recording the macro instead of copying the new value I enter.
Can anybody help with this?
Thanks a lot!