Hello,
I building a data mapping/translation function and need help on how to easily to this. I tried searching prior posts but can't seem to find the correct search criteria.
In a Excel worksheet I have 500 or more cells with info on how to transform the data.
For example:
cell A1 contains: "Hello " & a
in VBA "a" is a variable that can contain "World", for example. So I expect the result to be "Hello world"
cell A2 contains: "My height is " & a/b & " feet."
in VBA a = 72 and b = 12 so result will be "My height is 6 feet."
I've tried Evaluate but doesn't like variables. Is there a easier way to find and substitute variables? I don't mind changing the mapping syntax in the cells to make this easier.
Thanks for helping.
Bookmarks