Hi Team
Below code help me in converting numbers in text to Number format.
I want to pass Column no in this line:=> ws.Range("A:A,C:C,F:F,I:I,L:L")).Areas , what will be code?..
Thanks
mg
Below code help me in converting numbers in text to Number format.
I want to pass Column no in this line:=> ws.Range("A:A,C:C,F:F,I:I,L:L")).Areas , what will be code?..
VBA Code:
Dim rA As Range
Dim ws As Worksheet
Set ws = ThisWorkbook.Worksheets("Sheet1")
For Each rA In Intersect(ws.UsedRange, ws.Range("A:A,C:C,F:F,I:I,L:L")).Areas
With rA
.NumberFormat = "General"
.Value = .Value
Next rA
End With
Thanks
mg
Last edited: