Thanks Spiky, but sorry it didnt help.
my page would have a very long table that imports numbers from other page
(sheet), I only want to print till the numbers appears on the table, and dont
want to print the empty cells (blank portion) of the table at the bottom of
the page.
If excell auto selects, then it prints the whole table.


HERE IS HOW MY PAGE LOOKS

i have 2 sheets, on the first sheet i do the calculations.

second sheet is the one i need to print, which gets the results of my
calculation from the first sheet. Results shows up in a very long table (500
rows), but only fills up till my data goes, (may be 50, sometimes 200, it
varies).
I want to print only till my data (cells with values) skipping the empty
portion of my table.