Can you help me to shorten this code? Thanks a lot

**saftawy1** · 04-19-2022, 05:11 PM

Please Login or Register  to view this content.

**WideBoyDixon** · 04-19-2022, 06:35 PM

Something like this although I can't test it without having a copy of your userform:

Please Login or Register  to view this content.

WBD

**saftawy1** · 04-20-2022, 09:14 AM

thank you for your interesting
i tried it but some of this code not appear any thing

Please Login or Register  to view this content.

**WideBoyDixon** · 04-20-2022, 09:27 AM

I can't help any further without an attachment to work with - it's impossible to guess what your data looks like.

WBD

**saftawy1** · 04-20-2022, 10:57 AM

Thank you , i will try to solve it

**saftawy1** · 04-21-2022, 07:35 AM

Thank you, WBD, for this code. As for the part that does not work, when you change the name of the variable in it from O to Y, it works perfectly

Please Login or Register  to view this content.

Thank you very much

Re: Can you help me to shorten this code? Thanks a lot