Re: $$Excel-Macros$$ Run time error '1004' Method "Range " of oblect '_Globle fails

2014-01-02 Thread Paul Schreiner
l the times you can, To all the people you can, As long as ever you can.” - John Wesley - > > From: Rupesh Patil >To: excel-macros@googlegroups.com >Sent: Thursday, January 2, 2014 3:07 AM >Subject: $$Excel-Mac

Re: $$Excel-Macros$$ Run time error '1004' Method "Range " of oblect '_Globle fails

2014-01-02 Thread Anil Gawli
Dear Rupesh, Kindly share the workbook with us. Warm Regards, Gawli Anil On Thu, Jan 2, 2014 at 1:37 PM, Rupesh Patil wrote: > Hi expert > > Please look below code and tell me why I am getting this error(Mentions in > subject line) > Private Sub ComboBox1_Click() > Select Case ComboBox1

$$Excel-Macros$$ Run time error '1004' Method "Range " of oblect '_Globle fails

2014-01-02 Thread Rupesh Patil
Hi expert Please look below code and tell me why I am getting this error(Mentions in subject line) Private Sub ComboBox1_Click() Select Case ComboBox1 Case "CAP" pre_Med_Name_1.List = Range("CAP").Value Case "CREAM" pre_Med_Name_1.List = Range("CREAM").Value Case