How to find all values ​​in an Excel table using VBA script and execute RegEx on them?

Question

Visual Basic

Greetings.
There is a table with data. There is a working RegEx pattern. We need a script (macro) that
will execute the given pattern over each cell with data.
For example, it will remove characters from a string using RegEx.
Can eat some example on refactoring. I will be grateful.

Answer 1

How to Find All Values ​​in an Excel Table

to find? or take a range?
Take range is an object Rangein VBA.
after receiving the data, we perform operations on them.

Создание объекта RegExp используя позднее связывание:
Dim myRegExp As Object
Set myRegExp = CreateObject("VBScript.RegExp")