And you don't want to print the rows after the last entry in column b that is
not "".

If yes, then you can try this technique:
(saved from a previous post, you'll have to change the ranges)

If those formulas appear at the end of the data and you don't want to use
autofilter...

If I can pick out a column indicates if that row is used or not, then I like
this technique:

(I used column A in my sample, but you can use any column you want.)

Insert|Name|Define
Names in workbook: Sheet1!LastRow
Use this formula
Refers to: =LOOKUP(2,1/(Sheet1!$A$1:$A$1000<""),ROW(Sheet1!$A$1:$A$1000) )

(Make that 1000 big enough to extend past the last possible row.)

Then once mo
Insert|Name|Define
Names in workbook: Sheet1!Print_Area
Use this formula
Refers to: =OFFSET(Sheet1!$A$1,0,0,lastRow,3)

That last 3 represents the last column to print (A:C in my example).

And change the worksheet (sheet1) if necessary (in all the places).

Ps. If you go into file|page setup, you may find that the print range is
changed to a specific range. And you'll have to reapply the Print_Area name.

Naeem wrote:

Hi

I have a sheet ("Printing) which is populated from another sheet
("Data") which is updated by the users.

Not all the rows in the "Printing" sheet will be populated hence I
would like to print only the rows with date in it. All my rows (from
b6 to b3000) are filled with formula in it.

Could anyone please help me how to run print command so it only pick
up rows with data in it ?

Thanks,
Naeem

--

Dave Peterson