Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FOR EACH
hello
i would like to loop some code for sheets 3 to 17 of a workbook, but I'm not really sure of the syntax? Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FOR EACH
Greg,
Try something like Dim Ndx As Long Dim WS As Worksheet For Ndx = 3 To 17 Set WS = Worksheets(Ndx) ' do something with WS Next Ndx -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "GREGORY" wrote in message ... hello i would like to loop some code for sheets 3 to 17 of a workbook, but I'm not really sure of the syntax? Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|