Today, you could insert some code like:
rng = InputBox("Enter destination range")

But you can automate the calculation of destination range:

Dim rngDest as Range
With Worksheets("Archive")
set rngDest = Cells(Rows.count,"A").End(xlUp)
end With


HTH
--
AP

"Bigpond News" a écrit dans le message de news:
...
I need help
I have a multiple sheeet financial program, but I want to be able to
export the totals row of variables to an archieve that will save it as
values, no problem there, however I need to be able to save it to the
archieve sheet and I want the macro to direct it to the next empty row.

eg when I tranfer the values , say from row A65 on the Monthly statement
Worksheetto A1 on the Archieve sheet, no problem, but how do I make the
macro put the next row of values (at the end of next month)
to a2 and so on. In the oldern days we could insert a pause in the macro,
which would allow you to direct the curcor to the new required row.

Thanks for any help

Peter