VBA to Split Workbook: No Longer Converting Formula Results to Values

Hi Ali,

Long time no chat.

Has the relevant worksheet changed position in the workbook? The code to convert Rows 2 to 4 was written to work with the first tab (i.e. furthest left) of the current workbook so if that's changed it will cause issues.

That said, to convert your desired range to values you can use this:

Option Explicit
Sub Macro1()

    With ActiveWorkbook.Sheets(1) '1 represents the first (i.e. furthest left) tab of this workbook
        .Range("A1,B2:U4,E94:U104").Value = .Range("A1,B2:U4,E94:U104").Value
    End With
    
End Sub

Hope that helps,

Robert