Macro to Print Selection

HI all,

I seem to be getting myself into a complete muddle as was wondering if someone to help me with a Printing problem.

On the attached sample, i'm trying to write a macro to print the selection but only print where the status is "Active" to the ned of the selection. However, the spreadsheet is changing on a daily basis i.e. new lines being added and lines being taken off.

So, to take potential of user error out i wanted a macro to print the "active" selection.

Can anyone please help me get started !

They should be all active, as non active will be cut & pasted to another sheet.

So, in other words everything on sheet1 needs printing down to the last active cell.
Sorry, i forgot to mention there will be If(ISblank() formulaes in some columns, so then not to include these in the selection.

Sorry, for not making myself clear. I hope the following helps;

ok, so the spreadsheet is for example 500 rows long and from Col a to o.

there are formulaes (starting IF(ISBLANK) in C, K,L,N & O. Therefore, a user goes to the bottom of the sheet and enters into the rest of the cells starting at col A and putting the status to "Active".

They will also match off any rows where credit amount = debit amount and put the status to "closed", these (via a macro) will be cut & pasted to
'Sheet2' and the rows deleted.

So, the print range is continually changing.

I was then thinking whether a macro could be written to select this ever changing range and Printing it.

Is it possible ?

The code didn't do anything!

But, i was thinking would a dynamic range work?

So the dynamic range is continually picking up the range when it changes but then how would i incorporat into a macro ?

Or am i talking gibberish?

Sorry Andy it does work,

I've done a few tests, i.e. adding rows and deleting rows and the macro picks up the last cell which is populated and is not picking up any cells that are Blank or with ISblank formula in.

So, now how do i link all this in to a macro that prints this selection over 1, 2, 3 etc.. pages ?

as i'm not sure how to write the macro