Re: $$Excel-Macros$$ Update of button colors on form

Hi This will help in case you have multiple Objects.. Sub CB_COLOR_CHANGE() Dim cbutton As MSForms.CommandButton Dim oleObj As OLEObject For Each oleObj In ActiveSheet.OLEObjects If TypeOf oleObj.Object Is MSForms.CommandButton Then Set cbutton = oleObj.Object With cbutton

$$Excel-Macros$$ How to Drag get C,D,E,F post A,B...

Dear Friends, Please help me with very basic query. When we have 1 in Cell A1 2 in Cell A2, when we drag the data further down selecting both cells, we get 3,4,5,6,7 etc However when we do this for cells with A in Cell A1, B in A2, we do not get C,D,E,F...Any logical Reason? Is there any

Re: $$Excel-Macros$$ How to Drag get C,D,E,F post A,B...

After A, B, C.Y, Z and then AA, AB and so on - if you are looking for this, you can use below after putting A in A1 - =LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)26)+1) Regards, Abhishek On Fri, May 9, 2014 at 12:21 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear Friends,

$$Excel-Macros$$ Re: How to Drag get C,D,E,F post A,B...

Hi Amit, this is because there is not custome list exist in your excel application, if it is not their you can add same in you excel by just clicking on sort button in in order list box select custom list option and then add the list. Regards Prince On Friday, 9 May 2014 12:21:31 UTC+5:30,

$$Excel-Macros$$ regarding vlookup and wildcard function

Dear Sir / Madam, Please see the attachment and help me to solve the problem Thank you in advance Regards Sanjib -- - -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

RE: $$Excel-Macros$$ How to Drag get C,D,E,F post A,B...

Dear Abhishek, This worked perfectly fine. Thanks a lot. I just check how Left Address formula works! Could you please explain me how does the formula works? Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Abhishek Jain Sent:

$$Excel-Macros$$ Re: [XL-VBA Clinic] regarding vlookup and wildcard function

Dear Sir / Madam, Thank you for your quick reply. Regds, Sanjib On Fri, May 9, 2014 at 1:30 PM, Rajeev Kumar rajeev.ku...@peoplestrong.comwrote: Dear Sanjib, Please use below formula =VLOOKUP(*LEFT(E1,4)*,LIST,2,0) Thanks Regards Rajeev Kumar *Gurgaon* A 10

Re: $$Excel-Macros$$ copying data from Excel into a multiple .xml files

Vaibhav Joshi, Thankyou for your reply :) Attach is an example of the excel file as requested. (I've only left 4 lines of data to keep the file size small). Thanks On 8 May 2014 16:48, Vaibhav Joshi v...@vabs.in wrote: Hi MJ, Can you send a sample excel file with raw data for creating

$$Excel-Macros$$ example.xlsx

Sorry ignore the earlier example file use this one Sent from my iPhone example.xlsx Description: MS-Excel 2007 spreadsheet -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

$$Excel-Macros$$ if error function

Dear experts, I want to add another function if the result of first function is error, so please know me the function. for example =if function=error, ifanother fuction=error, another function,Value Iferror function cannot use because its contain only 1 argument. Thanks regards. Ashish

Re: $$Excel-Macros$$ if error function

Hi You need to use =if ( ISERROR(fn)=True, if ( iserror(fn)=True, value if true, value If false)) HTH//Cheers On Fri, May 9, 2014 at 5:49 PM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear experts, I want to add another function if the result of first function is error, so please

Re: $$Excel-Macros$$ if error function

Thanks, thats exactly what i found :) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, May 9, 2014 at 6:49 PM, Vaibhav Joshi v...@vabs.in wrote: Hi You need to use =if ( ISERROR(fn)=True, if

Re: $$Excel-Macros$$ Graph Query

wht do u wanna do .. its x y scatter chart On Thu, May 8, 2014 at 4:59 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear All I received one excel file in whih there is a graph. When I try to edit series it shows X and Y series in same legend (screen shot attached) Please let me know

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

Is there any opening in MIS executive profile?. Actually i also looking the job in same field. Regards, Kapil Gupta On Tuesday, August 2, 2011 7:13:55 AM UTC+5:30, krishna mummina wrote: Sam Are you asking me or to whom you are referring to call you? Here is my number : 09866902757 On

$$Excel-Macros$$ Autofill Macro

I have spent the better part of 40 minutes searching the web for what I believe is a simple solution. I have found many answers. I have tried them all - None are working to what I am looking for. Simply put. - Assume source Data is always is column A. It could be 50 rows in length or 84,679