Finding the last row

Hello
Good morning!
I was trying to keep a history (in Col. D) of my data entered in a cell (A1)
It is working ok, but started recording from 2nd Row (D2) but I need to start it from the 1st row (D1).
Please help me to correct it. What i need is to keep the track from D1.
Thanks
Toms

Please Login or Register  to view this content.

try this way

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Regards

Hi
@TM Shucks
It is working now. Thank you very much. But I couldn't figure it out what is wrong with my coding (considering the cancelled lines in my code). anyhow.. Thank you verymuch...
@Tom1977
Your code is same like mine in effect. It start recording from the 2nd Row. I wanted it to be from 1st row. TMShucks code is working perfect.

Thanks everyone..

If you leave in the commented code, it will always log to cell D1, as the End(xlUp).Row will equal 1 whether the cell is empty or not. If you comment the code out, it goes up to the last row and then adds 1. So, first time through it records in cell D2.

I've just checked to see if the column is empty and, if it is, set the next row to 1.

Note that, as you are making more changes to the sheet, you need to disable and re-enable events.

If this has answered your question, please mark your thread as solved.

Regards

Thank u TM for the explanation!
Great!

You're welcome. Thanks for the rep.