Runtime Error 13 Type Mismatch

http://www.ozgrid.com/forum/showthread.php?t=163511, Cross Posted Here:

Hi

It is because a multicell range returns an array when you access its Value property and you therefore get the type mismatch when your If tries to compare this array to a single string value (such as "PLX").

Would you mind explaining in words what you want your code to do? Something along the lines of "If a V col value is changed then if the V cell = 'PLX' then modify some other cell by..."

[QUOTE=Firefly2012;2737151]Hi

It is because a multicell range returns an array when you access its Value property and you therefore get the type mismatch when your If tries to compare this array to a single string value (such as "PLX").

Would you mind explaining in words what you want your code to do? Something along the lines of "If a V col value is changed then if the V cell = 'PLX' then modify some other cell by..."[/QUOTE

To explain my situation a little better. I have three dependent data validation lists set up in columns Q, R, and S. What I want the code to do is take the choices made in the three data validation lists and compare them to an exact criteria and return a value based on a match to specific criteria. For example if the user chooses "PLX" in column Q and "Imaging_TopCall" in column R and finally "Missing From File" in column S then column U auto populates with "Level 1". A record will be evaluated on every row of the spreadsheet, thus the necessity to have my code run over the entire range of all four columns involved with my code. Is there a way to rewrite my code so that it functions correctly? Any example you can give would be a great help. Thanks so much man>

Bump: No Response