print every 44 lines (including blank lines) per page

[marreco]

Hi.

I'm trying to print every 44 lines (including blank lines) per page.

Please Login or Register  to view this content.

Thank you!!!

[xladept]

Maybe:

Please Login or Register  to view this content.

[marreco]

Thanks to respond.

i have bad english, but i try explain.

look my newfile, inside file has 45 row (colorful background), i need skip 1 blank row (sum total 45 per page).

in file has 20.000 rows, i need print , 5 gruop date each 8 row (1 group + blanck cell, 2 group + blanck cell, 3 group + blanck cell, 4 group + blanck cell, 5 group + blanck cell) = 45 rows

colors will try to clarify my explanation.

Thank you!

[xladept]

Hi Marreco (Old Friend),

This looks good:

Please Login or Register  to view this content.

[marreco]

Hi Great Friend.

before running this macro on my computer (because there are many impressions), I want to print preview.

I fear that I must preview before printing.

how to change your code so that I can print preview?

Thank you!

[xladept]

Hi Marreco,

The way I ran it for Print Preview was to just comment out the Printout Line. But the data was uneven so I added the SpacingData procedure - be sure to have a backup before you run it!

Please Login or Register  to view this content.

After you get the print preview, you should just be able to hit the print button in your toolbar.

Let me know of issues And, thanks for the rep!

[marreco]

Hi, great xladept, the code was wonderful!

Your skills are amazing!

thank you very much!

[xladept]

You're welcome old friend! And, thanks for the compliment