Difficulty with macro in excel 2007.
wild guess here.
worksheets(1).select if it's always the first worksheet.
--
Gary
"helphelp" wrote in message
...
I have a website from which I download data and run macros for sorting data.
When I recors a macro in excel 2007, the macro looks for a specific file name
instead of using the active worksheet. For eg:
Sheets("userexport-23").Select. Everytime I download the -23 changes, Please
tell me how I can change the code to make the macro run in any worksheet.
Thanks
Prashanth
|