If..then statement

[Guest]

Hi,

I have the following If statement;

If query ID = "SAPBEXq0002" Then
I want to add another query ID to this statement. I have tried separating
them by a comma and got an error. e.g. If query ID = "SAPBEXq0002",
"SAPBEXq006" Then.

What is the best way to write this so that either query can be used.

Thanks

 

[Chip Pearson]

Sheila,

Use code similar to the following:

If queryID = "SAPBEXq0002" Or queryID = "SAPBEXq006" Then


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




in message
news:[email protected]...

 

[Guest]

Thanks for your help Chip!