VBA loop to set variable based on table with matching name

Hello,

I am probably doing this a very confusing and over complicated way for how it needs to be. But basically I am trying to reference a variable name in my code rather than the value of the variable.

Basically a file that is loaded into this file can change, whether is columns added or removed, or simply just renamed. I have made a mapping table to some of the columns and if they were to be outputted or not along with the shortened column name (which name will not change). The idea is that if the column names were to change the rest of the code doesn't have to be amended as the shortened version will rename the same, i just need to update the long version on the mapping table.

The code i am trying to do is:
- To declare the shared variable
- Then a routine is to be run which will then loop through the variables which i have listed in an array
- If in a specific column contains that variable name, then the code will set the variable value as another column in that same row.

I have attached an example of the code I am having issues with.

Please Login or Register  to view this content.