Would you please show mw a macro that would do as requested and show that
line
Thanks

"Don Guillett" wrote in message
...
One way to get the next available row to use in your macro:

nar=cells(rows.count,"a").end(xldown).row+1

Guillett
alesAid Software

"Don Guillett" wrote in message
...
You should always copy/paste your code to here so we will know you are
making an effort. Please do NOT attach a workbook.

--
Don Guillett
SalesAid Software

"PCOR" wrote in message
ers.com...

I would like a macro to copy data from sheet 1 to a new book
the macro would copy col A to I inclusive and down to include the last
row-
The last row varies all the time...and that is where I am having
trouble.
Will someone please help
Thanks

--
Norton Professional 2004 says this email is clean...believe it