How to select a celrange?
Hi
use MATCH in VBA to return the row number ans use something like
row_no=application.match(...)
msgbox range("D" & row_no).address
--
Regards
Frank Kabel
Frankfurt, Germany
René wrote:
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).
|