| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FASTER USE OF THE REPLACE() FUNCTION !!!!!
Hi -
I am using the Replace() function for a very large range. It works okay but wait time is quite long. Is there a more elegant approach to the below? For Each rng In Range("B3:B65500") If rng.Value < "" Then rng.Value = Replace(rng.Value, "-", ",") End If Next rng Any help would be appreciated! Thanks Jay *** Sent via Developersdex http://www.developersdex.com *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you have a value created by a function replace the function? | Excel Worksheet Functions | |||
| Replace Function | Excel Discussion (Misc queries) | |||
| Function that makes excel work faster | Excel Programming | |||
| Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) | |||
| What's faster -- array formula or UD function? | Excel Programming | |||
Threaded Mode
