VBA Find Replace

[jo15765]

I am scanning roughly 6K rows on an Excel worksheet to do a find/replace. This syntax works, but is VERY slow. Is there a faster way to accomplish this same result?

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[jo15765]

Much quicker, thank you!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.