How to simplify Macro IF function

**herukuncahyono** · 07-19-2013, 02:16 AM

Hi ,
I have macro but is too long

Please Login or Register  to view this content.

I really appreciate if anyone can help me to simplify the code

**patel45** · 07-19-2013, 02:58 AM

Please Login or Register  to view this content.

**herukuncahyono** · 07-19-2013, 03:36 AM

hi patel45

thanks the code work fine...

**herukuncahyono** · 07-19-2013, 03:37 AM

hi patel45

thanks the code work fine...

**Winon** · 07-19-2013, 03:43 AM

Hello herukuncahyono,

Or you could do it in the Worksheet Change Event:

Please Login or Register  to view this content.

**Winon** · 07-19-2013, 03:58 AM

You could even combine it with the fine Code from patel45.

Please Login or Register  to view this content.

**herukuncahyono** · 07-19-2013, 04:18 AM

Winon
Thanks for the code...perfect

**Winon** · 07-19-2013, 04:31 AM

Hello herukuncahyono,

Thank you for the feedback.

You are welcome.

Thank you also for adding to my Reputation.

Re: How to simplify Macro IF function