How to get multiple names columns using below code

[rajeshn_in]

Hi Friends,

Using below code, Columns visible individual range of "SHIPPING", "PERMIT", "INSPECTION", etc.

How can I get multiple name ranges. like 1 case, other wise 2 or 3 case using ","

Example: If I want 3 cases I can put like
SHIPPING, PERMIT, INSPECTION,

Than above 3 case columns will visible.

Please Login or Register  to view this content.

[nilem]

maybe something like this

Please Login or Register  to view this content.

[rajeshn_in]

Hi nilem,

yes, but I can't fix criteria like this. That's way I want to see two or more names data using ',' between names.

[nilem]

maybe so

Please Login or Register  to view this content.

[rajeshn_in]

Hi nilem,

This code not working in PROTECTED SHEET.

Please update the code

[nilem]

Did your original (post #1) code work?

[rajeshn_in]

No, Not worked.

[nilem]

Remove the protection from your sheet (suppose it is called "Sheet1"). Write this code in the ThisWorkbook module:

Please Login or Register  to view this content.

Close the book with preservation. Open it again.
Try making changes on the "Sheet1"

[rajeshn_in]

Thank you nilem.