$$Excel-Macros$$ Re: Logo at opening

2009-06-17 Thread Ahmet Yalcin
Problem solved, thank you very much for your kind follow up. Sent via BlackBerry Wireless -Original Message- From: Mahesh R r.r.mahesh1...@gmail.com Date: Wed, 17 Jun 2009 10:20:44 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Logo at opening Hey Ahmet, Is it

$$Excel-Macros$$ Excel cell validation bug

2009-06-17 Thread mac160
I have altered a cell validation expression to include more criteria. The resulting expression is: =AND(OR(ISBLANK(inpNodeFlow_u1),ISBLANK(inpPtOverride_u1)),ptrPt_u10) When the expression evaluates to FALSE the cell still accepts an entry. Part of the expression:

$$Excel-Macros$$ Re: Vlookup

2009-06-17 Thread Dilip Pandey
Hi Ruchi, This query is related to the linking of the files onto a excel spreadsheet. For example, you have some week - wise spreadsheets in your c drive (e.g. C:\Ruchi\work). The files may have the names like (week4.xls, week5.xls, week6.xls) and so on. Now what you want to do, is to link up

$$Excel-Macros$$ Re: How can I open that workbook to a specific workSheet from a shortcut or batch file outside of Excel?

2009-06-17 Thread Paul Schreiner
It doesn't look like that there are command-line switches that select the sheet. The only way I KNOW of is to put it in a Workbook_Open event or Auto_Open macro. If you don't own the file, you could create one of your own that, when opened, opens the second file and selects the sheet. paul

$$Excel-Macros$$ Re: UserForm

2009-06-17 Thread Jack
Great Just what i need many thanks for your help Jack On Jun 16, 9:35 pm, Phillip Swanepoel pswa...@gmail.com wrote: Hey... Sorry for late reply. Firstly i gota declare that i am still learning my self and there is probably cleaner and beter solution. This is what i came up with so

$$Excel-Macros$$ Hyperlinks

2009-06-17 Thread Jack
Hey anyone know how to make all of my hyperlinks open in read only ??? Cheers --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and

$$Excel-Macros$$ code to run batch file through excel

2009-06-17 Thread bharghav r
Hi all, Need code to run batch file through Excel Thanks and Regards Bharghav R --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video

$$Excel-Macros$$ How?

2009-06-17 Thread sathyan narayanan
I am slowly learning Excel Please let me know how I can post my questions regarding Excel Macros to you. -- Sathyan From MADURAI Other ID: kainoorsath...@hotmail.com --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Best Excel Tip Award of Week # 24 goes to HARMEET SINGH

2009-06-17 Thread Nishant Jain
Excellent tip Harmeet... really enjoyed this... On Jun 17, 7:48 pm, Ayush jainayus...@gmail.com wrote: Hello Everyone, I am happy to inform you that the award of best excel Tip of Week # 24 goes to Harmeet Singh. The tip submitted by Harmeet is as follows : Subject : Hidden text in Formula

$$Excel-Macros$$ Re: Excel cell validation bug

2009-06-17 Thread Nishant Jain
The only reason would be that prtPt_u10 is evaluated to true. check this On Jun 17, 1:50 pm, mac160 rpe...@firecon.co.nz wrote: I have altered a cell validation expression to include more criteria. The resulting expression is:

$$Excel-Macros$$ Re: is multiple vlookup possible.

2009-06-17 Thread Nishant Jain
Your example doesn't make sense... can you put a sample excel sheet of what the data looks like in table and how you want it On Jun 17, 5:00 pm, satish satishpag...@gmail.com wrote: Dear Group members I feel the following query is challenging. Is it possible to find a solution without macro

$$Excel-Macros$$ Re: Best Excel Tip Award of Week # 24 goes to HARMEET SINGH

2009-06-17 Thread Harmeet Singh
Hi Ayush, Thanks a lot This is the charm of Excel Group that is attracting good talent. Hope to help you all in future too with my knowledge. Watch out for more [?] Regards, Harmeet On Wed, Jun 17, 2009 at 8:18 PM, Ayush jainayus...@gmail.com wrote: Hello Everyone, I

$$Excel-Macros$$ Re: Best Excel Tip Award of Week # 24 goes to HARMEET SINGH

2009-06-17 Thread Dave Bonallack
Good choice Ayush. I also thought it was very good. It's the Worksheet-Function equivalent of putting comments after an apostrophe in VBA. Regards - Dave. Date: Wed, 17 Jun 2009 07:48:06 -0700 Subject: $$Excel-Macros$$ Best Excel Tip Award of Week # 24 goes to HARMEET SINGH From:

$$Excel-Macros$$ Re: Best Excel Tip Award of Week # 24 goes to HARMEET SINGH

2009-06-17 Thread Harmeet Singh
Hey Dave, You know wat. u made my day with ur comments Thnx!!! On Thu, Jun 18, 2009 at 4:21 AM, Dave Bonallack davebonall...@hotmail.comwrote: Good choice Ayush. I also thought it was very good. It's the Worksheet-Function equivalent of putting comments after an apostrophe in VBA.

$$Excel-Macros$$ Re: Vlookup

2009-06-17 Thread god is gr8 i love u
Hi oh this is gr8 thank u regards ruchi On Wed, Jun 17, 2009 at 5:17 PM, Dilip Pandeydilipan...@gmail.com wrote: Hi Ruchi, This query is related to the linking of the files onto a excel spreadsheet. For example, you have some week - wise spreadsheets in your c drive (e.g. C:\Ruchi\work). 

$$Excel-Macros$$ Re: How?

2009-06-17 Thread Ashish Pradhan
Hello Sathyan Please post your queries to the same email id. Anyone of the receipients who can provide the solution will gladly do so. Happy excelling Ashish On 6/17/09, sathyan narayanan kainoorsath...@gmail.com wrote: I am slowly learning Excel Please let me know how I can post my

$$Excel-Macros$$ Re: Vlookup

2009-06-17 Thread god is gr8 i love u
Hi actually i send 1 query in the group but i hvnt get ne reply yet plz help me otherwise i will b in trouble my probs is i hv file in which i hv mention th eintervals acc. to that i want to get the frequency and avg and also i hv to make chart which showz the counts frquency as well as avg but

$$Excel-Macros$$ Re: Best Excel Tip Award of Week # 24 goes to HARMEET SINGH

2009-06-17 Thread hari kumar
Hi I would undoubtedly say East or West-- Harmeet Singh is one of the kings of this group. regards Hari kumar On Wed, Jun 17, 2009 at 1:10 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: Hi Ayush, Thanks a lot This is the charm of Excel Group that is attracting good talent. Hope to

$$Excel-Macros$$ Re: BEST EXCEL TIP WEEK # 24 Submit TIP and Win PRIZE

2009-06-17 Thread Mahesh
Hi Harmeet, Can provide some samples, it will be a gr8 help for us? Rgds, Mahender Bisht On Tue, Jun 9, 2009 at 12:29 AM, Harmeet Singh harmeet.hew...@gmail.comwrote: HI All, Name : Harmeet Subject : Hidden text in Formula Tip : *=2018+1056-4*120+N(My Salary + Bonus - 4 weekly loan

$$Excel-Macros$$ Re: Vlookup

2009-06-17 Thread Dave Bonallack
Hi Ruchi, Not sure I understand all your needs. Take a look at the attached and tell me if I'm on the right track Regards - Dave. Date: Wed, 17 Jun 2009 22:38:51 +0530 Subject: $$Excel-Macros$$ Re: Vlookup From: ruchigab...@gmail.com To: excel-macros@googlegroups.com Hi actually i