Run Marco on 5 out 10 sheets

  • Thread starter Thread starter sleemo
  • Start date Start date
S

sleemo

i am new to all of this some help would be great.

i want to run macro 2 on sheets 3,4,5,6 after entering a number on sheet 1
can this be done?

thanks
in advance
 
try one of these methods

for shtcount = 3 to 6
with sheets("Sheet" & shtcount)

end with

next shtcount



or

shtnames = array("Sheet3","Sheet4","Sheet5","Sheet6")
for each sht in shtnames
with sheets(sht)

end with
next shtnames
 
Back
Top