Can i find a particular formula and paste its values

[Mohandas]

I Have a format which gets data by vlookup formula after getting the formula i need to get data copied and pasted with values in the same place, But that format also contains other formula which has to be as formulas. As solution for this

Regards


Mohandas

 

[PCosta87]

Hi,

If you have a formula in "A1" and want to "convert" it to a value, you can simply copy and paste as values in the same place.

With code it could be something like:

Range("A1").Value=Range("A1").Value

I would suggest you upload a sample excel file if you need further assistance.

I hope this helps.

 

[Mohandas]

I Have a format which gets data by vlookup formula after getting the formula i need to get data copied and pasted with values in the same place, But that format also contains other formula which has to be as formulas. As solution for this

Regards


Mohandas

Hi,

If you have a formula in "A1" and want to "convert" it to a value, you can simply copy and paste as values in the same place.

With code it could be something like:

Range("A1").Value=Range("A1").Value

I would suggest you upload a sample excel file if you need further assistance.

I hope this helps.

All INV columns containss formula it needs to be pasted as value

 

[PCosta87]

Hi,

Try the following making sure "CASES" sheet is active before running the code:

Sub PasteasValues()

    Dim c As Integer
   
    For c = 7 To 77 Step 4
        Range(Cells(11, c), Cells(1161, c)).Value = Range(Cells(11, c), Cells(1161, c)).Value
    Next c

End Sub

I hope this is what you were looking for.