Changin a Macro so it automatically updates the active worksheet.

  • Thread starter Thread starter Confused Laura
  • Start date Start date
C

Confused Laura

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!
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Macro for individuals worksheets 2
Unhide macro worksheet 2
How to apply macro across multiple worksheets within a workbook 4
Automatically update excel worksheet formula 7
'Cannot insert object' message when I try to put a button on a worksheet 7
Multiple worksheet Copy Paste Macro 2
Macro to create a list 5

Back
Top