J
jonny
I have a workbook where i need to scroll through 160
sheets using a macro which checks the value of C1, and if
the value = "printable", the sheet is printed.
I need some way of remembering which of the 160 sheets
need to be printed. I have tried
using 'activesheet.select replace:=false
but it still only remembers the last sheet, ie sheet 8,
not sheets 1, 5, 7 and 8.
If anyone can suggest anything it would be fantastic
thanks
jonny
sheets using a macro which checks the value of C1, and if
the value = "printable", the sheet is printed.
I need some way of remembering which of the 160 sheets
need to be printed. I have tried
using 'activesheet.select replace:=false
but it still only remembers the last sheet, ie sheet 8,
not sheets 1, 5, 7 and 8.
If anyone can suggest anything it would be fantastic
thanks
jonny