Use OR Within IF Statement Condition in VBA

[lleifsen]

Hello,

I am trying to figure out the Syntax for an If Statement.

Code:
"If LastCell = "$T$10" Or "$T$11" Then
ActiveWindow.SelectedSheets.Delete
End If"

It works when I have this:
If LastCell = "$T$10" Then
ActiveWindow.SelectedSheets.Delete
End If"

But, when I add the "Or $T$11" I get a Type Mismatch Error.


If anyone can help it would be greatly appreciated.


Lee

 

[kpark91]

When you are using Or, And operators, you must state the condition everytime which is a pain compared to other languages such as C (I believe)

So,

If A = 1 Or A = 2 Then.

 

[jeffreybrown]

Without knowing more about the code...I would say...

If LastCell = "$T$10" Or LastCell  = "$T$11" Then

 

[lleifsen]

I figured it out!
I added another LastCell

If LastCell = "$T$10" Or LastCell = "$T$11" Then
ActiveWindow.SelectedSheets.Delete
End If

Thanks everyone