Macro Is Not Fast Enough ... How Edit Code For Speed ?

[Logit]

.

The macro is applied to a filtered sheet. The user first selects the column letter, then clicks the command button, enters the term located in the selected column then enters how many blankd rows
are to be inserted.

With the attached example it takes several seconds to complete. If the worksheet will have tens of thousands of filtered rows it could take hours.

How to edit to make it lightning fast ?

Thank you.

Please Login or Register  to view this content.

[TMS]

You select an entire column, $T:$T. That means this:

Please Login or Register  to view this content.

is over a million rows. You need to determine the actual last row and work within that boundary.

[TMS]

Replace this:

Please Login or Register  to view this content.

with this:

Please Login or Register  to view this content.

[Logit]

.
Thank you. Got it !

Cheers.

[TMS]

You're welcome. Thanks for the rep.