please simplify the code

**kprabhupaul** · 07-13-2016, 11:41 PM

Can anyone help me in simplifying the below code ..?

Please Login or Register  to view this content.

thanks & regards

**:) Sixthsense :)** · 07-14-2016, 12:00 AM

Slightly simplified

Please Login or Register  to view this content.

**kprabhupaul** · 07-14-2016, 12:53 AM

it's good
thanks brother..

**Jacc** · 07-14-2016, 01:34 AM

Is the copy/paste really necessary? It takes a long time to perform.

Please Login or Register  to view this content.

If you only want the values then this is much faster.

Please Login or Register  to view this content.

**kprabhupaul** · 07-14-2016, 01:38 AM

thank you jacc

**Jacc** · 07-14-2016, 02:16 AM

You are welcome

This one also of course:

Please Login or Register  to view this content.

I believe these can be modified in the similar way. Once you get rid of all the cut/copy/paste it will run more smoothly.

Please Login or Register  to view this content.

Right below Dim you can put these two lines:

Please Login or Register  to view this content.

and then right above the End Sub you can put these:

Please Login or Register  to view this content.

Edit: spelling

Re: please simplify the code