Hi! I am new here and would like to ask for your assistance regarding m
problem.

I would like to capture the range address of whatever it is that th
user selects on the active worksheet into a textbox in a modeles
form. The user just have to set the focus in one of the textboxes the
select a range from the worksheet and the range address should b
captured inside the textbox.

The function is similar to that of getting the List Range or Criteri
Range address in the Advanced Filter window of Excel.

Hope you could help me out with this.

Thanks,
Pinin

--
pinin
-----------------------------------------------------------------------
pining's Profile: http://www.excelforum.com/member.php...fo&userid=1634
View this thread: http://www.excelforum.com/showthread.php?threadid=27729