View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ianripping[_59_] ianripping[_59_] is offline
external usenet poster
 
Posts: 1
Default Check to see if variable is duplicate.

I am grabbing var1 from an inputbox.

I want to say if var1 = any of the values entered in cells b4:b32 the
goto Double

I tired

if var1 = range("b4:b32").value then goto double

but didnt work, any suggestions

--
Message posted from http://www.ExcelForum.com