Copy value in formula

  • Thread starter Thread starter Jonny
  • Start date Start date
J

Jonny

How would i copy a the value of a formula to the last
empty cell in a row in vba?
 
I assume you mean the first empty cell to the right of the data.

You didn't specify what cell contains the formula or which row, so I am
assuming the active cell and the value is placed in that row to the first
empty cell after the data.

set rng = cells(activeCell.row,256).end(xlToLeft)(1,2)
rng.value = activecell.Value
 
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

Variable Range Copy... 13
Excel VBA 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
Copy value from changing cells without VBA 1
simple code but it doesn't look like usual vba code 2
Copying a formula to a range 2
A data validation question 1
Excel Help to copy information from one row at a time to another sheet 1

Back
Top