Create OR statement in macro code

**miles44** · 06-04-2023, 08:22 AM

Please Login or Register  to view this content.

columns 47 and 48 hold two different team names

I keep getting a TYPE MISMATCH error.

cells(36, 37) holds the team name

**6StringJazzer** · 06-04-2023, 08:35 AM

Each condition in an OR operation has to stand on its own as a logical expression. You are assuming that VBA will know to compare team to either cell, but it doesn't.

Do this instead. Also you don't the need the Else because there is no code after it. Also indent your code.

Please Login or Register  to view this content.

**mjr veverka** · 06-04-2023, 04:15 PM

?

Please Login or Register  to view this content.

Create OR statement in macro code

LinkBack

Thread Tools

Rate This Thread

Display

Create OR statement in macro code

Re: Create OR statement in macro code

Re: Create OR statement in macro code

Thread Information

Users Browsing this Thread

Similar Threads

Code/Macro return the value from a statement to a table cell?

Create vba macro to extract balances from statement

[SOLVED] Code to create Macro Button and Assigning Macro code

Macro to create statement of sales Ledger

create a macro if else statement

Insert macro name in code on call statement.

[SOLVED] how to create automatic macro with if statement or similar

Bookmarks

Bookmarks

Posting Permissions