Thread: How not number ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
DM Unseen DM Unseen is offline
external usenet poster
  
Posts: 233
Default How not number ?
Dim x As variant

x = Range("G10")

If Isnumeric(x) then msgbox "we have a number!" else msgbox "we cannot
compare this to a number!"

DM Unseen

Reply With QuoteReply With Quote