Re: $$Excel-Macros$$ VBA Code for Hide specific column as per criteria

2014-01-02 Thread amar takale
Dear Experts team Any help on this issue? Regards Amar On Thu, Jan 2, 2014 at 12:38 PM, amar takale wrote: > Dear Experts > > Pls help me on this topic.All detailed give in excel attached. > > Regards > Amar T > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ help!!! creation code from data in cells

2014-01-02 Thread abhinav bansal
hi all i want to creat formula as defined below- - formula needed for creating Student ID Student ID looks like- CC1/ACTI/12/13/01 defination- *Code *legend (Example of data in Cell)Range of data --

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

2014-01-02 Thread Paul Schreiner
I'm not sure what the purpose of your macro is.   It LOOKS like ComboBox1 has: "CAP, CREAM, DROP". You're trying to select from one of these values in the combobox and load another list (pre_Med_Name_1)   But there's a couple of things wrong with this approach. First, the Range() object only has a

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