View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dolphinv4 Dolphinv4 is offline
external usenet poster
 
Posts: 27
Default Printing Selected worksheets but exclude the sheet "Sheets"

Hi,

i have a macro below on the sheet "Sheet" to print the selected worksheets
but i don't want it to print the sheet "Sheets". How do I go about it? Thanks.

Dim i As Integer
isheet2 = Worksheets("Final Pivot").Index - 1

For i = Sheets("MLog_Int_SG").Index To (Sheets.Count - 14)


Sheets(i).Select False
Next i
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=False