Hi Everyone, I have this selection code that works perfectly. It ensures all data in a column is selected (including blanks):



Range([A2], [A:A].Find("*", [A1], , , xlByRows, xlPrevious)).Select
My problem comes when I want to have the Column select vary by using a string. I'm not sure how to incorporate it? I've tried with and without quotation marks with no luck. Anyone know how to do this?


Range([r & 2], [r & : & r].Find("*", [r & 1], , , xlByRows, xlPrevious)).Select