Macro to empty row
 

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

Macro to empty row
 

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