| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
odd issue with a loop
For counter = 1 To scount
sstring = Cells(counter + 82, 2).Value Sheets(sstring).Select ActiveSheet.PageSetup.Zoom = 75 ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Next counter the above section of code works for the first iteration of the loop on the second iteration it fails to give sstring a value. is there something wrong with the code? p.s the aim of the code is to print off a number of sheets |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| For next do loop issue | Excel Discussion (Misc queries) | |||
| Naming Worksheets - Loop within a loop issue | Excel Programming | |||
| Naming Worksheets - Loop within a loop issue | Excel Programming | |||
| do ... until loop issue | Excel Programming | |||
| Issue with Do Loop | Excel Programming | |||
Linear Mode
