Hi,
I have a worksheet that has 12 coulmns for numbers to be entered into to ...
the last column has a formula in it that totals the numbers in the rows.
I've copied the formula down to row 500 as that's the most it could ever go
to.

The formula =IF(SUM(C9:N9)=0,"",(SUM(C9:N9)))
If there is nothing entered in a row then the cell remian empty.

The problem I'm having is when users use this worksheet and only enter
numbers up to row 300..for example... and we print it... the rest of the
pages from rows 301 to 500 still print....but they are blank..
I am assuming this is happening becasue of the formula that is in the last
column (shown above).
Is there a way to make those pages not print even though they have a formula
in the cells.

Not sure if vba can do it or not....or some other trick..
Any help would be greatly appreicated!!
Thanks,
Kimberly

Hi
you could set your print area (File - Print Area) accordingly

--
Regards
Frank Kabel
Frankfurt, Germany
"KimberlyC" schrieb im Newsbeitrag
...
Hi,
I have a worksheet that has 12 coulmns for numbers to be entered into to
...
the last column has a formula in it that totals the numbers in the rows.
I've copied the formula down to row 500 as that's the most it could ever
go
to.

The formula =IF(SUM(C9:N9)=0,"",(SUM(C9:N9)))
If there is nothing entered in a row then the cell remian empty.

The problem I'm having is when users use this worksheet and only enter
numbers up to row 300..for example... and we print it... the rest of the
pages from rows 301 to 500 still print....but they are blank..
I am assuming this is happening becasue of the formula that is in the last
column (shown above).
Is there a way to make those pages not print even though they have a
formula
in the cells.

Not sure if vba can do it or not....or some other trick..
Any help would be greatly appreicated!!
Thanks,
Kimberly