I'm trying to find a (hopefully simple, because I am a noob to VBA) code to replicate the auto-copy function that occurs when you double click the box in the bottom right corner of a cell.

Here is the long version: I am trying to select the first empty cell in column N - I have successfully done that with VBA. I am then trying to enter a time/date stamp into that cell - and I have successfully done that. Now I am trying to fill/copy that timestamp down to the end of the current data set. However, I need the range to be undefined as it will change often. So I cannot say For N1:N40 timestamp - because while it is 40 this time, next time it may be 85, or 130 after than.

I tried a Do While Loop, but I couldn't get that to work. Here is the code that I am currently using - should you modify it, would you mind explaining how/why as I am still trying to learn this?

Sheets("WOBrowse").Select
    For Each cell In ws.Columns(14).Cells
        If IsEmpty(cell) = True Then cell.Select: Exit For
    Next cell
ActiveCell.Value = Format(Now, "mm/dd/yyyy HH:mm:ss")
So I am finding the empty cell in column N - adding a timestamp to that cell; so how do I copy that timestamp down to the end of an undefined data set? (It could copy in column N until column A is blank - but I'm not sure how to write that)

Thanks in advance!