Storing Array to Find Replace Value via 2 Dimensional Array

Hi All,

Hopefully you can help.

I have an Array

Array1 = Array(a,b,c,d)
Array2 = Array(1,2,3,4)

the position between the two arrays relate ie a = 1, b = 2 and so on.

For several Macros i need to find all the values in column A which contain Array1 and replace them to the equivalent within array2. As this action is used within multiple Macors and the Large Array occasional updates i would like to store the Array itself as a Public Function to call upon ie.

Formula:

Please Login or Register  to view this content.

This would call within the Macro as follows

Formula:

Please Login or Register  to view this content.

Any help which can be provided would be great!

Cheers

Thanks, the above works however only when all within one Macro.

Ideally i require the below as a public function to call upon

Formula:

Please Login or Register  to view this content.

Therefore the below would be within each of my individual Macros

Formula:

Please Login or Register  to view this content.

Is this achievable at all?

Cheers

Works Perfect! Thank you very much