newknew
asked on
Select Range and Convert Text to Numbers in Excel VBA
1) I need to select cells from H3 to Mxxx where total rows are variable and unknown
2) I need to convert those values from Text to Number
I found this much code and it works for any selection that I manually highlight. But I'm having trouble with number #1.
' Check to see if selection is formatted as Text -
' If so, then reformat selection as General
'************************* ********** ********** ********** ***
If Selection.NumberFormat = "@" Then _
Selection.NumberFormat = "General"
' Replace formulas and numeric strings with real numbers
'************************* ********** ********** ********** ***
Selection.Value = Selection.Value
2) I need to convert those values from Text to Number
I found this much code and it works for any selection that I manually highlight. But I'm having trouble with number #1.
' Check to see if selection is formatted as Text -
' If so, then reformat selection as General
'*************************
If Selection.NumberFormat = "@" Then _
Selection.NumberFormat = "General"
' Replace formulas and numeric strings with real numbers
'*************************
Selection.Value = Selection.Value
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER