$$Excel-Macros$$ Excel2000 - Using color in Activex Scroll Bar added to sheet

Hi Is there any add-in for a different scroll bar to add within a sheet? I would like to be able to change colors in 3 places. The 2 arrows, the thumb, and the background. And also even use graphics jpg as background. Excel2000 seems a bit limited to blacks and greys. Thanks Charles Har

Re: $$Excel-Macros$$ Networkdays

Appreciate your acknowledgement.. Cheers!! On 1/31/15, Sunil Kumar Yadav wrote: > thank u so much...u r really very nice person sir! > > On Fri, Jan 30, 2015 at 7:38 PM, Vaibhav Joshi wrote: > >> hi >> >> there is conditional formatting in cell A2, chk below screenshot.. >> >> [image: Inline im

$$Excel-Macros$$ Urgent Requirement Java BE Developer| Bothell, WA | Contract Position

*Hi**,* *Hope you are doing great!!* * Please find the requirement below **,* *If you find yourself comfortable with the requirement please reply back with your updated resume with details to this email id s.dak...@esskay-inc.com and I will get back as soon as possible.* *Position: **Java B

$$Excel-Macros$$ Urgent Requirement Senior Java Developer | Quincy, Massachusetts | Contract Position

*Hi**,* *Hope you are doing great!!* * Please find the requirement below **,* *If you find yourself comfortable with the requirement please reply back with your updated resume with details to this email id s.dak...@esskay-inc.com and I will get back as soon as possible.* *Position: **Senior

$$Excel-Macros$$ Very urgent need of iOS Developer ==== Charlotte, NC.

Hello Associate, I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of our client for *iOS Developer**. Charlotte, NC *. Please find below the job description for the same and revert back to me with your consultant updated profile and contact details at the earliest.

RE: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA

Vaibhav, its giving me subscript out of range error. I am thinking if we have to put Sheet name before range (like Sheet1!Range1, Sheet1!Range2). I have chart and data in the same sheet and tried to include sheet name also, but of no use (getting type mismatch error). Regards. Yours Sincerely,Nit

Re: $$Excel-Macros$$ Networkdays

Hi Ashish, i have downloaded this file from chandoo site and have understood everything how to created chart, table etc. but very little query i m not able to understand, when i click on box then color auto changed but where is write formula for this? Please tell me! On Fri, Jan 30, 2015 at 12:

Re: $$Excel-Macros$$ Colour the Group Rows

Hi Check this...I have created to Macros, one for clearing format, press erase me button & sleect range from which you want to delete formatting/colr.. And to apply color formatting, press color me & slect top most cell e.g.A2 in your case & press enter..Macro will color cell as per ur requiremen

Re: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA

try Charts("Chart1").SetSourceData Source:=application.union(Range1,Range2) Cheers!! ᐧ On Fri, Jan 30, 2015 at 5:59 PM, Nitin Balodi wrote: > Hi Vaibhav, > > and that worked. :) :) :) many thanks. I was trying to set date > serial using left function. > > Many thanks once again. > > Can y

RE: $$Excel-Macros$$ Date Filters in Pivot Table Report Filter in VBA

Hi Vaibhav, and that worked. :) :) :) many thanks. I was trying to set date serial using left function. Many thanks once again. Can you help on one more thing, and that will complete my current task :), I am trying to set Chart range. My range is in columns A, B and D. Set Range1 = Range("A

Re: $$Excel-Macros$$ Colour the Group Rows

Hello yes after every group there is one space On Fri, Jan 30, 2015 at 5:28 PM, Vaibhav Joshi wrote: > Hi > > For macro need some input, is there gonna be space between two groups? > ᐧ > > On Fri, Jan 30, 2015 at 5:19 PM, Ganesh Acharya < > acharyaganesh...@gmail.com> wrote: > >> Thanks a lot f

Re: $$Excel-Macros$$ Colour the Group Rows

Hi For macro need some input, is there gonna be space between two groups? ᐧ On Fri, Jan 30, 2015 at 5:19 PM, Ganesh Acharya wrote: > Thanks a lot for your help team > > Really you are amazing, > > I tried this before, but I want to highlight all the group at one go, > > Because file is huge, I

Re: $$Excel-Macros$$ Colour the Group Rows

Thanks a lot for your help team Really you are amazing, I tried this before, but I want to highlight all the group at one go, Because file is huge, I have to create many formula, One which I provided that is just an example If something sort of Macro would be really good Again Thanks a lot for

Re: $$Excel-Macros$$ Colour the Group Rows

Dear Ganesh, Go in Conditional Format tab and click on Manage Rules option and try to understand how the formula works. I think, you no need a macro for it. Regards Ashish -- 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 Faceboo

Re: $$Excel-Macros$$ Colour the Group Rows

There is conditional formatting in cell... ᐧ On Fri, Jan 30, 2015 at 5:03 PM, Ganesh Acharya wrote: > Hello, > > Attachment doesn't have any formula > > Is there any way to make a Macro for that > > Thanks > > Ganesh Acharya > > > > -- Forwarded message -- > From: Vaibhav Joshi

Fwd: $$Excel-Macros$$ Colour the Group Rows

Hello, Attachment doesn't have any formula Is there any way to make a Macro for that Thanks Ganesh Acharya -- Forwarded message -- From: Vaibhav Joshi Date: Fri, Jan 30, 2015 at 2:29 PM Subject: Re: $$Excel-Macros$$ Colour the Group Rows To: "excel-macros@googlegroups.com"

Re: $$Excel-Macros$$ Wrong entry of a number

Hi Bhalara, Select the cell Go to in Format Cell Click on Text Enter Now, type your No. Regards Ashish -- 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 @ https://www.facebook.com/discussexcel FORUM

Re: $$Excel-Macros$$ Re: Search Box - Event Macro ??

Solution is provided by Vaibhav Joshi. @ Vaibhav Joshi - Excellent Solution Vaibhav Bhai. Regards Ashish -- 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 @ https://www.facebook.com/discussexcel FORUM

Re: $$Excel-Macros$$ Colour the Group Rows

Vaibhav Bhai, Nice Solution. Regards Ashish -- 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 @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread ti

Re: $$Excel-Macros$$ Wrong entry of a number

There's an addin called Xnumbers which "performs multi-precision floating point arithmetic from 1 up to 250 significant digits. You can download it from here: http://www.thetropicalevents.com/Xnumbers60.htm Cheers!! ᐧ On Fri, Jan 30, 2015 at 4:00 PM, Ashish Bhalara wrote: > Yes, I doing same

Re: $$Excel-Macros$$ Wrong entry of a number

Yes, I doing same, but is there any solution to type in number format more than 15 digit? Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, Jan 30, 2015 at 3:50 PM, Vaibhav Joshi wrote: > Hi > >

Re: $$Excel-Macros$$ Wrong entry of a number

Hi Excel allows entry upto 15 digits & there should not be any problem with entering 296100210001856 You mat add ' before number if you want to store digits more than 15. Cheers!! ᐧ On Fri, Jan 30, 2015 at 3:48 PM, Ashish Bhalara wrote: > I checked it in version of 2007 & 2003. > And also che

Re: $$Excel-Macros$$ Wrong entry of a number

I checked it in version of 2007 & 2003. And also checked same sheet by opening in another PCs and also by creating new sheet. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, Jan 30, 2015 at 3:36 P

Re: $$Excel-Macros$$ Wrong entry of a number

what is your MS office version? ᐧ On Fri, Jan 30, 2015 at 3:24 PM, Ashish Bhalara wrote: > I did it same also but though problem remaining same. > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is absolutely necessary. > Spread environmental üawareness.♣♣♣*

Re: $$Excel-Macros$$ Wrong entry of a number

I did it same also but though problem remaining same. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, Jan 30, 2015 at 2:46 PM, Vaibhav Joshi wrote: > Change cell format to number with zero decim

Re: $$Excel-Macros$$ Wrong entry of a number

Change cell format to number with zero decimal places.. ᐧ On Fri, Jan 30, 2015 at 2:43 PM, Ashish Bhalara wrote: > Dear experts, > > I enter number 296100210001856 in cell of excel in number format but after > given enter the number change to 296100210001850. > I checked all the way but not foun

$$Excel-Macros$$ Wrong entry of a number

Dear experts, I enter number 296100210001856 in cell of excel in number format but after given enter the number change to 296100210001850. I checked all the way but not found any solution, pls check n reply for solution. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless i

Re: $$Excel-Macros$$ Colour the Group Rows

Hi You can do with countifs & count formula..for each group you need to have diff. conditional formatting.. Check this attachment.. ᐧ On Fri, Jan 30, 2015 at 1:50 PM, Ganesh Acharya wrote: > Hello Expert > > > I am having some issue in highlighting the rows with there in goup > > > Please fi

$$Excel-Macros$$ Colour the Group Rows

Hello Expert I am having some issue in highlighting the rows with there in goup Please find the attachment >From the Data, would like to highlight those row which has same* Product Number and same Item side Name*. but it should be in the *same group* In the* group if it has* Same product n