View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
R.VENKATARAMAN R.VENKATARAMAN is offline
external usenet poster
 
Posts: 74
Default 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