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

"sleemo" wrote:

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