VBA: Question

[SteveOranjin]

Hello There,

I'm learning a lot about VBA but I have a quick question.

If a macro can be performed more than once on a given cell, will it be performed as many times as the rules which govern it allow? Or will it only make that initial run through and then have to be run again to get the rest.

An example: If I have fifty spaces in a cell, and I set up a macro to turn all Double Spaces (that is "_""_" lines added for clarity) into single spaces - will the macro run and reduce the spaces in the cell from 50 to 25, and then proceed to the next cell and perform the function there, or if it reduces the number of spaces to 25, and detects that there are more spaces, it will continue to delete them until there are none left.

Steve

 

[Eric W]

The short answer to your question is that a VBA code will only be performed one time. If you want it performed more, then you need to code a loop. Some of the other responses were trying to either come up with an efficient loop, or sometimes specific situations can avoid a loop.

 

[Joe4]

Shouldn't that be Rory & Eric

Yes, typo on my part!

 

[SteveOranjin]

The short answer to your question is that a VBA code will only be performed one time. If you want it performed more, then you need to code a loop. Some of the other responses were trying to either come up with an efficient loop, or sometimes specific situations can avoid a loop.

I see.

Thank you