macro for multiple worksheets
Number of worksheets selected (only one can be active at a time):
Dim nSelectedWS As Long
nSelectedWS = ActiveWindow.SelectedSheets.Count
for multiple worksheets:
Dim ws As Worksheet
For Each ws In Worksheets(Array("wks1", "wks3", "wks5"))
'do something with each ws
Next ws
In article ,
Brian wrote:
Is there a way to have a macro span multiple worksheets but not the whole
workbook (i.e wks1,wks3,wks5 only)?
Also, is there a way to determine whether multiple worksheets have been
selected and activated?
|