Help with code to copy result of formula in a cell

**Climber-Jutt** · 03-15-2021, 05:55 PM

Hi all,

Fairly new to the coding side of things and learning on the go by creating small helpful things to get the feel for it.

I have a basic code that copies a cell to the next available cell on another sheet. The cell contains a formula.

Hoping someone can help with what to add so that the result of the formula is copied and not the formula itself.

Private Sub CommandButton1_Click()

Worksheets("Sheet 1").Range("B3").Copy _
        Destination:=Worksheets("Sheet 2").Cells(Worksheets("Sheet 2").Rows.Count, "C").End(xlUp).Offset(1, 0)
        
    

End Sub

Thanks in advance Excel Wizards *bow*

**maniacb** · 03-15-2021, 06:13 PM

You should be using code tags so your code looks like the solution below. see rule 2 of the forum.

Private Sub CommandButton1_Click()

Worksheets("Sheet 1").Range("B3").Copy
Worksheets("Sheet 2").Cells(Worksheets("Sheet 2").Rows.Count, "C").End(xlUp).Offset(1, 0).pastespecial xlpastevalues

End Sub

**Climber-Jutt** · 03-15-2021, 06:17 PM

Apologies,

Will do from now on.

Thanks.

**jolivanes** · 03-15-2021, 06:52 PM

Or

Worksheets("Sheet2").Cells(Rows.Count, 3).End(xlUp).Offset(1).Value = Worksheets("Sheet1").Cells(3, 2).Value

It's all a personal preference

Help with code to copy result of formula in a cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Help with code to copy result of formula in a cell

Re: Help with code to copy result of formula in a cell

Re: Help with code to copy result of formula in a cell

Re: Help with code to copy result of formula in a cell

Thread Information

Users Browsing this Thread

Similar Threads

Copy result from cell with formula to empty cell

cell not display result even formula result indicate result is correct

[SOLVED] Code result wrong but formula correct result

[SOLVED] Copy result of working code to next free row

[SOLVED] trying to write a vba that will copy a formula result and place it in another cell as text

[SOLVED] Code to delete cell contents IF the result of a formula in the cell = 0

how do i copy a formula's result to another cell, without copying.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions