Any Suggestions on Optimizing My First VBA Code?

[floppygoat]

Hi,

Below is the first VBA code I have created individually, but it seems "slow."

Any suggestions oh how to revise for optimization?

Please Login or Register  to view this content.

If any additional information is needed, please let me know.

Thanks,

TW

[stnkynts]

Hello and welcome to the forum. One of the things you can do to optimize your code would be to remove all the .Select and Selection.

Please Login or Register  to view this content.

Another item is that the .Range("A1") is an oddity. It doesn't do anything. You code is simply using the range reference from the active cell.
Another item is the use of active cell. It is not usually the most desired situation. Instead you would be better served to identify the actual range.
There are other things but without more information it would be hard to explain.

Why don't you submit a detailed description of what you are actually trying to accomplish and then you can see some alternative code to accomplish it. I have a feeling it could be condensed to a simple line or two.

[InvisibleMan]

A couple of examples ... should give you some clues

Please Login or Register  to view this content.