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 ?

 

[jimbojones]

You're halfway there. Try this:

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

Cheers,

Jim