1. Instead of using an offset number, is it possable to use the column name? Ex. Offset(0, Dates)
Yes, I tryes and it does not work like that but maybe you know another way.
You couldn't use it in the way you tried, no. But you could set the variable found equal to the Row number like I did above, and then use it in a cell reference, e.g.
If variable "found" is 8, and Range("Dates").Column is 7 (column G), then it will return the value from cell G8.
2. How do I construct the code to return more than 1 cell per row?
You would need to loop through your data to find/return multiple instances.
Bookmarks