p5x
If you're adding information to a given column, say Column A, then the code below would find the next blank cell in column A, and, in this case, paste the contents of range C8 there.
Sub pleasepaste()
[C8].Copy
[A65536].End(xlUp).Offset(1, 0).PasteSpecial
End Sub
Tom
Like this thread? Share it with others