| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changin a Macro so it automatically updates the active worksheet.
Hi
I have just recorded a macro which takes info from imported text and does some caculations and rearranges the info onto a new worksheet. My problem is that I need it to do the same thing over several worksheets. I have associated the macro with a button - but need it to update that active worksheet and not the original worksheet that I used to record the macro. Any help would be much apreciated! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changin a Macro so it automatically updates the active worksheet.
Without seeing the actual code, we can't say definitively, but you probably
want to change Sheets("Name") to ActiveSheet. Also check for hard coded workbook names. Regards, Fred. "Confused Laura" <Confused wrote in message ... Hi I have just recorded a macro which takes info from imported text and does some caculations and rearranges the info onto a new worksheet. My problem is that I need it to do the same thing over several worksheets. I have associated the macro with a button - but need it to update that active worksheet and not the original worksheet that I used to record the macro. Any help would be much apreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to identify active worksheet in macro | Excel Worksheet Functions | |||
| Macro for changin row height | Excel Discussion (Misc queries) | |||
| macro- move down to empty cell & active worksheet | Excel Worksheet Functions | |||
| A Chart that Updates Automatically as Data Size Changes? | Charts and Charting in Excel | |||
| Is there a way to automatically add columns as the data updates? | Excel Worksheet Functions | |||
Hybrid Mode
