Sorry, Dave,
My question was not answered by you.
I didn't ask how to get to the last full cell in the column.
I asked why from that point the: Application.SendKeys ("{DOWN}") does not move the cursor.
I didn't ask for a "workaround" as Elm1 does all I need in the simplest way.
**********************************************************************************
EDITED !!!
Thank you, leith, for being patient.
The following code works fine - tested a few sequential times BUT has one "minor" problem.
At the first run - assume range A1:A10 has values - it overwrites Cell A10.
From the second run and on, it PASTES the copied value into the next empty cell.
If there is a logical explanation - I'll be glad to learn.
Thanks again, Elm
Bookmarks