Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Marco on 5 out 10 sheets
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Marco on 5 out 10 sheets
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this marco | Excel Programming | |||
Can someone help me with this marco | Excel Programming | |||
Help with marco | Excel Programming | |||
Marco | New Users to Excel | |||
marco | Excel Programming |