vba to check cell contents

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top