Replace Cells With "/" of large Range Faster

[JODomingos]

Hi Friends.

I have a large amount of cells that i need to replace the "/ " for empty. But when i try to perform this task by finding and replacing It takes too long (Hours).
Is there a way to speed up that? by doing in a VBA code for instance?

Thank you!

 

[VBE313]

Do you have any worksheet events? Remove the worksheet events before doing find and replace.

 

[Joe4]

Do you have any worksheet events? Remove the worksheet events before doing find and replace.

This may not be necessary. There may be a reason that the code needs to be left left in there.
However, if Find/Replace is run via VBA code, events can be temporarily disabled, so that event procedure code will not kick off.

The structure of that would look something like this:

Sub MyReplaceMacro()

'   Temporarily turn off event procedures
    Application.EnableEvents = False

'   Find/Replace code here

'   Turn events back on
    Application.EnableEvents = True

End Sub

The VBA code needed for the Find/Replace can be gotten by turning on the Macro Recorder, and performing those steps manually.
That will provide code needed for that part.
(It can be perfomed on a small range when recording, and we can expand it when editing that code to put it in our other procedure).

 

[alansidman]

If you are willing to use Power Query which is called Get and Transform in your version.
1. Highlight your range of data and bring into the PQ Editor
2. On the Transform Tab, select Replace
3. Fill in the text boxes
4. On the Home Tab, select Close and Load.

It is extremely fast.