Macro to Find and Replace - Speed

shades

Well-known Member
Joined
Mar 20, 2002
Messages
1,550
My latest update:

I used FastExcel to time the latest work with this Dictionary Object Model replacement.

Rows: 29,793
Replacements Items: 154
Time: 3.14 seconds
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

jvamar

New Member
Joined
Apr 2, 2009
Messages
13
i also have similar problem can anyone suggest me pls....

Hi All,

I have one requirement for find and replace.
There are 1000's of XML tag with values..
i want a macro which should replace all the tags(the value which is in between angel brackets<> should only be removed and angel bracekst also should be removed) with or without space and tag value should remain unchanged.
Can anyone help me on this...
 

Watch MrExcel Video

Forum statistics

Threads
1,095,827
Messages
5,446,728
Members
405,414
Latest member
wayne_p

This Week's Hot Topics

Top