How to check the value of a Column
If all the values in a column are text or all the values in a column are
number, then pick a cell and test it:
Sub WellWhatIsIt()
n = Cells(Rows.Count, "Z").End(xlUp).Row
v = Range("Z" & n)
If Application.WorksheetFunction.IsNumber(v) Then
MsgBox ("numbers")
Else
MsgBox ("text")
End If
End Sub
For column Z
--
Gary''s Student - gsnu2007L
"tlee" wrote:
Hi all,
How can I check the value of a Column whether string or integer?
Thanks
TLee
|