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 |
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 |
All times are GMT +1. The time now is 08:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com