Copy active cell to end of range

[[email protected]]

Good day, Gurus.

This should be easy, but I'm getting hung up on the syntax, (I think).

Trying to copy the formula in the active cell to the bottom of the used range. In the script below the line Range(ActiveCell & ":U" & Cells(Rows.Count, "A").End(xlUp).Row).Select throws the error "Method 'Range' of object '_Global' failed"

Please Login or Register  to view this content.

How do I correct the italicized line above to copy from the active cell to the end of the range in column U?

Thanks in advance.

[millz]

But it seems you are already at the last row in Column U?

Please Login or Register  to view this content.

this line should have brought you there, and then you entered =TODAY() in there, copies it, and where do you want to paste it?

[[email protected]]

Got it, peoples.

The correct syntax is:

Range(ActiveCell, "U" & Cells(Rows.Count, "A").End(xlUp).Row).Select

This thread is solved.

Thanks.

[[email protected]]

Sorry I wasn't clear. I add copy new data from another workbook into this one daily, but my data only goes as far as column T. I then wanted to add today's date in column U, and copy it to the bottom of the used range.

The line above fixed me up.

Thanks.