Dear all

I have an userfrom with refedit control in it. I can easily select any range on the excel where the form resides, however now i would like to use this excel as templete with an ability to fetch ranges from other excel sheet..

Kindly let me know how to acheive this..

ex.. i have opened the excel with refedit control in it. Along with it i have opened 2 more excel sheets. Now i would require the refedit control to select any range among these 3 excel sheets.

Thanks in advance.