I have an excel worksheet with column headings in Row-3 and then column
borders (lines) that go till row 500.
From VBA, I insert data into the each row starting Row-4 and continue till
Row-N where N is a variable number of rows.

Because of the column borders, when I simply print the page it prints all
rows till Row 500. But, I only want it to print until Row-N where the data
ends. Any ideas? I know I could probably set and reset print area - but are
there any better ideas or is there s simple setting (print option) in excel?

Thanks.

My favorite way is to apply Data|Filter|autofilter. Then pick out a nice column
that's always filled in if the row is used.

Filter for non-blanks, then print, then Data|Filter|showall.



Mickee wrote:

I have an excel worksheet with column headings in Row-3 and then column
borders (lines) that go till row 500.
From VBA, I insert data into the each row starting Row-4 and continue till
Row-N where N is a variable number of rows.

Because of the column borders, when I simply print the page it prints all
rows till Row 500. But, I only want it to print until Row-N where the data
ends. Any ideas? I know I could probably set and reset print area - but are
there any better ideas or is there s simple setting (print option) in excel?

Thanks.

--

Dave Peterson