How to select a celrange?

  • Thread starter Thread starter René
  • Start date Start date
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).
 
Hi
use MATCH in VBA to return the row number ans use something like

row_no=application.match(...)
msgbox range("D" & row_no).address
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i want a cel is to follow another cel's content but it shows a zero(0) if the first cel is empty!? 3
list box remove item by combobox 4
exclude a column 3
Autofill variable range 2
Date in formula 4
Multiple row selection 1
using a vlookup to enter text into rows beneath the vlookup cell 1
Relative links to worksheets 1

Back
Top