View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joseph Atie Joseph Atie is offline
external usenet poster
 
Posts: 19
Default 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