dynamic printing and totals

[- Dan -]

I have a simple spreadsheet like this

title1 title2 title3 title4
abc 10 5 50
def 11 4 44
..
..
..



total 22 9 94


I never know if I will be entering 1, 2, or 1000 rows. I also have darkened
borders around each cell. But when I click print, I only want to see in the
printout the number of rows with data so if I filled in 10 rows my print
would have 12 rows (title, 10 rows, total). If I enter 500 rows, I want
the printout to be 502.

This is for an executive so I want to make it as easy as possible for him.

 

[Frank Kabel]

Hi
have a look at
http://www.rondebruin.nl/print.htm#Hide

 

[- Dan -]

So if I'm reading this right, what needs to be done is the blank, i.e., not
filled in, cells have to be hidden first, then the worksheet is printed,
then the cells are unhidden. Is that right? It looks like the VBA code
knows the rows 10 to 15 (in the example code) are to be hidden. How do I
get it to dynamically determine this? That is, if I arbitrairly put a total
(SUM()) row at row 1000, how do I determine that row X:999, where X is
always unknown, needs to be deleted?

thanks

 

[- Dan -]

It was easy to figure out. I incorporated the COUNTBLANK() function

thanks