shorter version of this line of code

Hi All,

Need your help again, need to shorten this code.

Please Login or Register  to view this content.

Thanks.

Might quick take on it (untested), but there is probably a better solution using an array

Please Login or Register  to view this content.

Or...

Please Login or Register  to view this content.

Depends on the actual data. If there's more text in the cell other than 'PersonX' then something like

Please Login or Register  to view this content.

might work. Either which way you need to experiment with your actual data.

cytop that's a beauty! I use like in SQL but not often in VBA. Well until now

hmm I assume that those codes will only work if the value is between Person A to E?

Person A to E represents real name though, did place Person A to E for placeholder only.

this should be editable

Please Login or Register  to view this content.

Maybe not condense enough for you though