Dear Pete,
You can use following if you don't want to refer sheets:-
Sub ABC
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Sheets
' enter your code here
Next
End Sub
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yaho
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()
'
' Keyboard Shortcut: Ctrl+i
'
1.Worksheets("Sheet1").Activate
Ac
