Thread: Macro to tell if Cell is Text or Number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
HiArt[_2_] HiArt[_2_] is offline
external usenet poster
  
Posts: 1
Default Macro to tell if Cell is Text or Number

try

If not Isnumeric(Range("A1").value) Then... 'not a number

or


If Isnumeric(Range("A1").value) Then... 'a number

Ar

--
HiAr
-----------------------------------------------------------------------
HiArt's Profile: http://www.excelforum.com/member.php...fo&userid=1995
View this thread: http://www.excelforum.com/showthread.php?threadid=37702

Reply With QuoteReply With Quote