View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JoeP JoeP is offline
external usenet poster
 
Posts: 24
Default Macro to select and print sheets

I would like to know the code for use in a macro that will
1. look at cell G1 in a sheet and if there is a number in that cell print
the sheet
2. move to the next sheet and look at cell G1 and if there is a number in
that cell print the sheet
3. continue to move to each sheet in the file test cell G1 to see if there
is a number and print the sheet if there is.

Thanks for any help.