I do a string check in order to locate a specific column heading. Let's say, for example, that the range address is $AB$1.
This is saved to a range variable.
So let's say
range X is $AB$1
Now I want to get the range of the entire column, so I want
range Y to be $AB:$AB
How do I get from X to Y?
Thanks much!
Bookmarks