YOUR CURRENT LINE 1 IS Worksheets("Sheet1").Activate
NOTE: "Sheet1" is the actual name of you work sheet
so if your other sheet's name is 'goodbye' then change the
code to
Worksheets("goodbye").Activate
you can also have the code loop through all (OR some of your
worksheets), by Loop
problem solved thanks
On Nov 30, 9:34 pm, pete wrote:
> Hi Gurus
>
> I've set up the following sub which I want to use on other sheets (set
> up the same) in the same workbook. It's in a module (I tried putting
> it in the sheets & this workbook) - still learning/trying.
>
> Sub Interest()
> '
>
