Posted to microsoft.public.excel.programming

external usenet poster

Posts: 69

vba using the OR operator

Here is my code that does not work:

If Rows(iRow, 1) = ("11/13/2005" Or "11/23/2005") Then
blah blah

I can get the code to work on a single date but not with multiple dates
using "or". I have about 20 dates that I want to check and I could get by
with just repeating the code 20 times but I wanted to do it using a single
statement.

Thank you!!

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
Operator for Contains	Leanne M (Aussie)	Excel Worksheet Functions	2	October 21st 08 11:01 AM
XOR Operator - How?	Randy Brown	Excel Discussion (Misc queries)	3	April 8th 06 09:47 PM
Mod operator	R Avery	Excel Programming	7	September 2nd 04 03:03 AM
Like Operator	Donald[_3_]	Excel Programming	8	June 29th 04 03:22 AM
Can the AND operator be of use here?	Milind	Excel Programming	3	July 27th 03 11:17 PM

All times are GMT +1. The time now is 10:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us