Re: $$Excel-Macros$$ query need help

nice, thanks ravinder Thanks Regards, Prabhu R On 18 March 2014 11:16, Ravinder ravindervbacli...@gmail.com wrote: pfa *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Prabhu Pinky *Sent:* Sunday, March 16, 2014 8:02 AM *To:*

$$Excel-Macros$$ how to get conditional formatting code already applied on a cell through vba

Hi Expert, can any one please share code to get applied conditional formatting on a cell or range of excel workbook through vba. Thank Regards, Divaker -- 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

RE: $$Excel-Macros$$ how to get conditional formatting code already applied on a cell through vba

Try this Sub DataBarBook() Dim DB As Databar With Range(A2:A11) Set DB = Range(A2:A11).FormatConditions.AddDatabar() With DB.BarColor .Color = RGB(255, 0, 0) End With End With End Sub Thanks regards,

Re: $$Excel-Macros$$ how to get conditional formatting code already applied on a cell through vba

Thanks for reply. But i need code to retrieve already applied conditional formatting. Regards, Divaker On Tue, Mar 18, 2014 at 2:34 PM, mr.exce...@gmail.com wrote: Try this Sub DataBarBook() Dim DB As Databar With Range(A2:A11) Set DB =

$$Excel-Macros$$ Ledger account

Hello friends. I need your help to sort out excel query.. I have attached excel file for demo.. 1) Row data in second sheet data 2) Required automatic fill up sheet name Ledger via vb code or any formula. please guide me friends.. Thanks in advance.. Regards, Chintan -- Are you

$$Excel-Macros$$ Re: Fomula to find the Missing Numbers in the sequence - Reg

hope this will help you. please find the attachment... On Monday, February 28, 2011 12:58:15 AM UTC-8, Prathap D wrote: Dear All, I have an excel sheet in which i need to find the missing numbers in the sequence. Please help me with the formula to identify missing numbers in a list

$$Excel-Macros$$ Need VBA code for Sumifs function.

Hi experts, Please find the attached file. i almost complete my project. But struck up in sumifs part. i used formula in sheet2. but i need to have it in VBA code. i tried it but the cell reference is not changing. whatever the result i get for AAA, same value i get for other agents. most

Fwd: $$Excel-Macros$$ Need VBA code for Sumifs function.

any experts here..??? Please help with my query. its very urgent. Thanks Regards, Prabhu R -- Forwarded message -- From: Prabhu Pinky prabhupin...@gmail.com Date: 19 March 2014 10:41 Subject: $$Excel-Macros$$ Need VBA code for Sumifs function. To: