How to select a celrange?

R

René

I have programmed in VBA (with vlookup): find a certain date ( in the left
row) and give me the content of the cel in row 4.
That is working good. But how can I get the celrange of that cel? For
example: (D25).
 
F

Frank Kabel

Hi
use MATCH in VBA to return the row number ans use something like

row_no=application.match(...)
msgbox range("D" & row_no).address
 
Top