Copying formula on a colum and paste as value

Dear all

I have a sheet that Column B contains variable data which are formula based, I am trying to copy the values from Column B and paste it to Column C. My Sheet has header on row1 so header will be static.

Tried various ways but I cant get what I like. I don't want to use record macro option as the data length keep changing.

Your views will be appreciated.

Kind regards

Re: Copying formula on a colum and paste as value

Quote from JohnCleary;729883

Maybe...

Code

Sub x()


   Dim LastRow As Long
   
   LastRow = Range("B1").End(xlDown).Row
   
   If LastRow <> 2 Then


      Range("B2:B" & LastRow).Copy
      Range("C2").PasteSpecial Paste:=xlValues
   Else
      ' There's nothng to copy
   End If
   
End Sub

Display More

thank you very much , perfect