Copy a value to the next empty cell in a column
try this code
range("M13").Copy destination:=range("N19").End(xlDown).Offset(1,0)
=================
Pete Csiszar wrote in message
news:PXijd.118849$9b.67912@edtnps84...
Hi All,
I'm in search of little help.
My spreadsheet calculates a value which is located in M13. I would like to
implement a sub that will copy the value in that cell to the next empty
cell
in the next column beginning at N19. My plan is to associate the sub with
a
button click.
So basically every time I click the button it will copy the current M13
value to the next available cell in the N column beginning a row 19.
Any help would be much appreciated.
Best regards,
Pete
|