Remove extra space within text

R

Ron Rosenfeld

If I read your results correctly, it would seem for a macro executing wholly
within the VBA world, using the regular expression scripting engine is
slower than using native, built-in VBA functions; however, once your macro
interacts with the spreadsheet world, any coding time differences get buried
by the time required for VBA to communicate with the spreadsheet.

Rick

That would be my conclusion, also.

It does give rise to some coding considerations (i.e. keep as much of the
scripting engine outside of the read/write loops as possible), but that just
makes common sense, anyway.
--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top