2022-06-21

Loop error while converting Text to Number across all sheets with VBA

I'd like your help to repeat the below code to all file sheets to convert "Column B" from text to number. I have tried next for function but it gives me error every time I run it.

Screen shot from the file sample


    Sub convert ()
    
    [B:B].Select
        With Selection
            .NumberFormat = "General"
            .Value = .Value
        End With
    End Sub

Screenshot:

enter image description here



No comments:

Post a Comment