Hi there
I have 15 A4 sized pages within the spreadsheet and in the top corner of each page I have the following formula to "create" a page number if data is present on the sheet:
This code creates the number 1 (for Page 1):
This code creates the number 2 (for Page 2):
etc, etc for each page up to 15
Is there any way that I can have some way whereby my print macro button which is already set up can detect which pages have a page number (and don't equate to IS BLANK) and the print out those specific page numbers?
I know I can use Activesheet.Printout 1, 5 for the first page being 1 and the last page being 5, but this is useless in this particular example because pages 1 and 5 might have data on them but pages 2-4 will be empty.
I hope this explains my problem,
Liam
I have 15 A4 sized pages within the spreadsheet and in the top corner of each page I have the following formula to "create" a page number if data is present on the sheet:
This code creates the number 1 (for Page 1):
Code:
=IF(AND((COUNTA(A3:A39)=0),SUM(Q3:Q41)=0),"IS BLANK",1)This code creates the number 2 (for Page 2):
Code:
=IF(AND((COUNTA(A44:A80)=0),SUM(Q44:Q82)=0),"IS BLANK",2)etc, etc for each page up to 15
Is there any way that I can have some way whereby my print macro button which is already set up can detect which pages have a page number (and don't equate to IS BLANK) and the print out those specific page numbers?
I know I can use Activesheet.Printout 1, 5 for the first page being 1 and the last page being 5, but this is useless in this particular example because pages 1 and 5 might have data on them but pages 2-4 will be empty.
I hope this explains my problem,
Liam
Last edited:
