Printing Problem in Excel

[gartheb]

I'd like to be able to count a specific number of populated fields in a table in excel and, if the information ends at row 25 for example, set the print area to print the table up to where the populated fields end.

Thanks

 

[Dreamboat]

Do you have information below those rows? If so, you probably ought to move it to another sheet anyway. If not, why do you need to make the print selection? Is it printing blank pages? There are other ways to resolve problems like this. Are you looking for a code solution? Generally, you should be able to hit:

Ctrl-home
Shift-Ctrl-End
Hit Print, choose "selection" and print.

Can I help you more?

http://www.PiersonTech.com

techsupportgirl@home.com
Brainbench MVP for Microsoft Word

 

[gartheb]

There isn't any information below the rows and it does print out blank pages. I use a template which needs to cater for different quantities of information so I've made it err on the side of caution for size and as other users print this report (and others) I'd like to use a macro which prints the reports and reduces the paper used.

Any help would be appreciated.

Thankyou.

 

[Dreamboat]

Better that you use a macro that does the following on all the rows below and columns beyond the populated ones.

Edit-Clear-All-Save

Else your spreadsheet becomes bloated and at some point unusable because there will be no "truly" blank rows.

http://www.PiersonTech.com

techsupportgirl@home.com
Brainbench MVP for Microsoft Word