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!
Fred Smith - 18 Mar 2008 00:19 GMT
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.
> Hi
>
[quoted text clipped - 6 lines]
>
> Any help would be much apreciated!