I don't know what this is called in order to search for...

[InptTrdr]

Hi,

I want to use something similar to vlookup, but instead of having the data in the spreadsheet I would like to have it within the code itself. Still fairly new to the game.

In my situation, I paste data in to a spreadsheet and essentially run a macro to clean it up, to then in turn, copy and paste it somewhere else. Some of the data has a code that I would like to replace with a name. I feel like vlookup is not the best. I am also open to other ideas, then what I am ask for on the above.

Thanks in advance.

 

[TwistShout]

i'm not terribly familiar with them myself, but try looking into "arrays"

(by that i mean googling)