VBA cleanup

[paul_j_]

Hi
I had a query in the Excel General area and have come up with an solution that works reasonably well with some basic VBA coding.
Is this coding OKAY or can it be tidied up a bit ?

I would like to think I was on the right path in coding this.

Here is the original posting....



http://www.excelforum.com/excel-gene...match-vba.html

[SamT]

Let us assume for the sake of argument that you are referring to the code i post #8. Then no I can't clear it up because it is not the entire procedure.

Post the whole thing here, from Sub to End sub, inclusive.

[romperstomper]

First, you don't need a colon at the end of every line!

Second, avoid selecting things - it's unnecessary 99.86% of the time.

Third, always specify the property you want - even .Value

Untested:

Please Login or Register  to view this content.

I am not suggesting this is the most efficient way of achieving your ends, just amending the existing code.

[SamT]

A picture may be worth a thousand words but a workbook is worth a thousand pictures!

Can I steal that? I'll credit you.

[romperstomper]

Feel free.

[TMS]

Maybe this:

Please Login or Register  to view this content.

Regards, TMS