Refedit to fetch range from Other excel sheets

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.

Anyhelp plz ?

anyone plz

It seems you can't navigate to another worksheet or workbook via RefEdit control. I use InputBox(...,Type:=8) instead to work around, though it's not that pretty by looks.

Tell me if you find another way to do it.

I just checked.. same problem here as it only selects range from the excel it's running

I want to select range from other opened excel sheets.. Anyway to do it ?

Originally Posted by shg

Jon Peltier has a very nice alternative to a RefEdit control at http://peltiertech.com/WordPress/ref...l-alternative/

I tried this as well, but still i couldn't select any range from other excel sheets. Any help would be greately appreciated. TIA