$$Excel-Macros$$ Conditional Formating

2010-09-05 Thread Pankaj Kumar
Hi all, i am new in msexcel wanted to learned use of conditional formating, cananyone helped me to learned conditional formatting ,,,for a brief example -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* * rajputpankaj1...@r

RE: $$Excel-Macros$$ sumif kinda formula needed

2010-09-05 Thread shrinivas shevde
Dear Siti Thanks for Help. shrinivas Date: Sat, 4 Sep 2010 14:59:51 +0700 Subject: Re: $$Excel-Macros$$ sumif kinda formula needed From: villager.g...@gmail.com To: excel-macros@googlegroups.com customized function ? in Excel we can create a function using VBA programming (1) open VBE /

Re: $$Excel-Macros$$ Track changes inside text box in Excel

2010-09-05 Thread P.VIJAYKUMAR
HELLO, Your sheet may be protected or reject any changes in your sheet may be enabled. to make any changes remove the protection or accept the changes you make by using the accept or reject changes in the review menu. On Sat, Sep 4, 2010 at 7:50 PM, Chandru wrote: > Hello > > I am enabling th

Re: $$Excel-Macros$$ Top Poster of the month :- Dave Bonallack

2010-09-05 Thread C.G.Kumar
Congrats Dave. I wish you will continue to do this in coming months too and enrich our group forum. Regards, C.G.Kumar On Fri, Sep 3, 2010 at 10:31 AM, Ayush wrote: > Hi Group, > > I am glad to announce that Dave Bonallack has topped in posting for > the month of Aug'10 with 67 Posts (9% of g

Re: $$Excel-Macros$$ Learning VBA

2010-09-05 Thread Dilip Pandey
Hi Santanu, I would suggest you to go ahead and record macro and then watch and relate these codes by your steps, which you had taken and start understanding VBA. You can also refer to the Group's learning material - see footnote of this email. Thanks, DILIPandey On 9/4/10, santanu_ca wrote:

RE: $$Excel-Macros$$ Re: Ned Maxif

2010-09-05 Thread Dave Bonallack
Hi, Please see the attached for a possible solution. Regards - Dave. Date: Sat, 4 Sep 2010 08:40:35 -0700 From: n8dine4ma...@yahoo.com Subject: Re: $$Excel-Macros$$ Re: Ned Maxif To: excel-macros@googlegroups.com Thank you for the response. Unfortunately, the data can't be sorted.

Re: $$Excel-Macros$$ What is UBOUND and L Bound In VBA (Excel Macros)

2010-09-05 Thread Aindril De
HI, The largest available subscript for the indicated dimension of an array can be obtained by using theUbound function. In our one-dimensional array example, Ubound(arr) is 5. In our two-dimensional array example above, there are two upper bound figures - both are 2. UBound returns the followin

$$Excel-Macros$$ What is UBOUND and L Bound In VBA (Excel Macros)

2010-09-05 Thread bhavya khanna
Hi Everyone. Can Someone explain About Ubound and Lbound in Excel VBA with Example. Or sending some attached sheet. Thanks and Regards -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tr

Re: $$Excel-Macros$$ Track changes inside text box in Excel

2010-09-05 Thread samad khan
hi actually i did the same procedure as you mentioned but i didnt face this kind of problem i dont know why it happens to you   Regards Samad --- On Sat, 9/4/10, Chandru wrote: From: Chandru Subject: $$Excel-Macros$$ Track changes inside text box in Excel To: excel-macros@googlegroups.com Da

Re: $$Excel-Macros$$ Ned Maxif

2010-09-05 Thread Bruno Bruno
Try the following array formula: =MAX((A1=Sheet2!A1:A5)*(B1=Sheet2!B1:B5)*Sheet2!C1:C5) Adjusting the ranges "A1:A5", "B1:B5" and "C1:C5" to the respective ranges on sheet2. Just to remember, to use an array formula you should paste the code and then press CTRL+SHIFT+ENTER (if you just press ente

$$Excel-Macros$$ Learning VBA

2010-09-05 Thread santanu_ca
Sir How cani I leran to write the macro code. Is it very hard. Please advice me how can I learn. Santanu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitte