vba to check cell contents
if application.isnumber(mycell.value)) then
it's a number the way excel sees it!
if isnumeric(mycell.value) then
is far less stringent than the =isnumber() excel function.
If it looks like it could be a number, it's numeric.
Steve wrote:
In my vba routine I want to check the cell contents to see if it's NOT a
numerical value. And I'm considering a blank cell to be non-numeric.
Thanks.
--
Dave Peterson
|