If else if else statement error

**MaartenRo** · 03-20-2021, 03:15 AM

Hi,

I have created a macro that shoudl change the value in column L if column K has "B001" in it. Somehow i get an error message: types do not match (from dutch)
How can this problem be solved?

Any input is much appreciated!

Please Login or Register  to view this content.

**Sintek** · 03-20-2021, 03:28 AM

Your sample file does not have data corresponding to your code...

Also this...Is incorrect...Column I comes before K?

Please Login or Register  to view this content.

should it not be

Please Login or Register  to view this content.

**MaartenRo** · 03-20-2021, 03:36 AM

Sorry i have here the file with the reference sheet and the Vlookup functions.

**MaartenRo** · 03-20-2021, 03:37 AM

You're rigth that was the problem. Thanks!

If else if else statement error

LinkBack

Thread Tools

Rate This Thread

Display

If else if else statement error

Re: If else if else statement error

Re: If else if else statement error

Re: If else if else statement error

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] SUMIF statement for using two possible totals plus display ERROR if user error

compile error expected line number statement end statement

VBA Compile Error : line number or label or statement or end of statement

VBA- Compile Error, Expected: line number or label or statement or end of statement

Runtime Error - Subscript out of range despite On Error statement

Path/File access error (Error 75) using Name Statement

Path/File access error (Error 75) after using Name Statement

Bookmarks

Bookmarks

Posting Permissions