End of line

[Ampleford]

I want a macro which will paste information to the next free row in a column, creating a database...

I can get it to go to the last row by using the command -

Selection.End(xlDown).Select

but I can't get it to go one more row below.

Can anyone help ?

 

[technix]

On 2002-09-28 04:43, Ampleford wrote:
I want a macro which will paste information to the next free row in a column, creating a database...

I can get it to go to the last row by using the command -

Selection.End(xlDown).Select

but I can't get it to go one more row below.

Can anyone help ?

Using your selection.end(xldown) to get your last cell then use the activecell.offset(1,0) to go to the next line down

HTH

Derrick

 

[dk]

Hello,

You can use Offset.

Selection.End(xlDown).Offset(1, 0).Select

Where 1 is the number of rows to offset from the original cell, 0 is the number of columns.

 

[Ampleford]

Thanks all.....