shorten code vba

**wildonln** · 05-07-2016, 03:48 PM

i've found that you could shorten your code.

example:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

Could someone give me a brief on this subject?
why/where to use and why/where not to use this

Please Login or Register  to view this content.

**shg** · 05-07-2016, 03:50 PM

The colon is just VBA's statement separator. It generally serves to make your code more difficult to read.

Re: shorten code vba