Hello,
Hope someone can help me.
I have a large sheet with formulas in every cell from cell A1 to AZ2002. The only difference being column AY which either has a number in or nothing at all (no formula).
The data is conditionally formatted so that if there is no data in column AY, then the cells in that row are in white text (blanked out)
The whole range A1 to AZ2002 is sorted by column AY.
Therefore, the sheet is 2002 rows deep but most is blanked out but still has a formula in it. The rows still showing are all sorted to the top of the sheet.
How do I create a macro to print only the rows that are showing? This maybe 1 row or 858 rows. It needs to set the print area from cell A1 to the first blank cell in column AY.
thanks in advance.
Hooperman.
Hope someone can help me.
I have a large sheet with formulas in every cell from cell A1 to AZ2002. The only difference being column AY which either has a number in or nothing at all (no formula).
The data is conditionally formatted so that if there is no data in column AY, then the cells in that row are in white text (blanked out)
The whole range A1 to AZ2002 is sorted by column AY.
Therefore, the sheet is 2002 rows deep but most is blanked out but still has a formula in it. The rows still showing are all sorted to the top of the sheet.
How do I create a macro to print only the rows that are showing? This maybe 1 row or 858 rows. It needs to set the print area from cell A1 to the first blank cell in column AY.
thanks in advance.
Hooperman.