Copy a value to the next empty cell in a column

  • Thread starter Thread starter Pete Csiszar
  • Start date Start date
P

Pete Csiszar

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
 
try this code

range("M13").Copy destination:=range("N19").End(xlDown).Offset(1,0)
=================
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Formula function for ignoring cells/results equal to 0 (zero) ? 1
Search for empty cells and move cells next to 10
Macro to "find" the next empty cell in a range 2
Entering Values in a Single Cell to Update Next Empty Cell in a Ra 3
copy all but formula to next empty column 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Concat a three column range into one cell Then Next... 2

Back
Top