Posted to microsoft.public.excel.programming

ianripping[_59_] ianripping[_59_] is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Check if Duplicate with Exceptions	mjones	Excel Worksheet Functions	6	January 18th 10 12:37 PM
Duplicate check	Robzz	Excel Worksheet Functions	4	May 5th 09 02:41 PM
check for duplicate numbers	Ash	Excel Worksheet Functions	13	October 31st 06 10:15 AM
duplicate check	rufusf	Excel Worksheet Functions	2	August 29th 06 04:30 PM
How can I check for duplicate $'s?	MDG	Excel Worksheet Functions	0	January 25th 06 10:01 PM

All times are GMT +1. The time now is 08:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us