Copy a value to the next empty cell in a column
 

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

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