Excel VBA - Find row & column address in worksheet based on 2 match scenerios.
Posted on 2013-01-30
I have a worksheet where I need to derive the cell.address off 2 variables.
r = "C1" match to Range ("A1:A60") - this will be my row number of that found cell in range
c = "C2" match to Range ("D1:X1) - this will be my column number of the found cell in range
Then my cell address would be .Cells(r, c) so I can finish my code.
I am not remembering my stuff here; how to just get the row number or column number.