Is there a way to invoke a lookup function in VBA.
For example:
For each cell in my selection, I want to look at column A on Sheet2, find the value (it will appear more than once) and if all values in column D of the same row (use of offset) have then same value (not as column A but as eachother), then I want the offset to my selection to be equal to a given value like "test"
I can try to work through the code myself if someone can help me with how to invoke the lookup or find function I need.
Any help is much appreciated. ThanksAdrae
Take a look at my response to your other question.
You can also invoke the lookup functions in VBA by using application.worksheetfunction.lookup
Like this thread? Share it with others