Re: $$Excel-Macros$$

Hi Thanks for providing the formula and i'll try and come back to u again for future help Regards > thanks for providing the formula > but i am unable to work in 2003 excel which is showing NAME ERROR > > i am using the formula as provided and its working in 2007 excel but in my > office has 2

Re: $$Excel-Macros$$ Re: Download MS Office 2013 (Trial version)

Full Setup For Microsoft Office 2013 Professional Plus 32Bit It's working fine. Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com

Re: $$Excel-Macros$$ Re: Download MS Office 2013 (Trial version)

Hi Noorain, Please help me understand, I may be wrong. I do not see Office 2013 on Microsoft website. Is this Open Document? Thanks, Joseph On Tue, Jul 31, 2012 at 9:20 AM, NOORAIN ANSARI wrote: > Dear Pascal, > > Yes Brother, below link is safe, I have download 2013 from here and it is > wor

$$Excel-Macros$$ Please tell me more about Areas Function with example.

Hi Experts, Please tell me more about Areas Function with example. and how to use in excel workbook. Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.*

Re: $$Excel-Macros$$ Workdays formula help required

Dear Vikram, Please visit here. hope it will help to you. http://www.excelfunctions.net/Excel-Workday-Function.html On Sun, Jul 29, 2012 at 1:33 PM, venus wrote: > H, > > Please help regarding how to implement workdays formula. > > > -- > Regards, > > Vikram Ahuja > > -- > FORUM RULES (986+ mem

Re: $$Excel-Macros$$

Hi For 2003 go to tools tab and there is Add-In option there then check all the check box and after that u will b able to use the network days formula in 2003 as well.. On Mon, Jul 30, 2012 at 9:46 AM, Cute Awesome wrote: > > > > hi > thanks for providing the formula > but i am

Re: $$Excel-Macros$$

Dear Cute, you can use blow function in 2003 for count Networking days *=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&today())),2)<6))* see attached example On Mon, Jul 30, 2012 at 10:16 PM, Cute Awesome wrote: > > > > hi > thanks for providing the formula > but i am unable to w

Re: $$Excel-Macros$$ Re: Download MS Office 2013 (Trial version)

Dear Pascal, Yes Brother, below link is safe, I have download 2013 from here and it is working fine. http://www.hacktrix.com/download-microsoft-office-2013-now On Mon, Jul 30, 2012 at 10:37 PM, bpascal123 wrote: > Noorain, are these links safe? Microsoft usually releases trial versions > throu

Re: $$Excel-Macros$$ Need Help !!!!

Dear Mangesh, You can also use... =INDEX($C$2:$E$10,MATCH(1,(($A$2:$A$10=$G$13)*($B$2:$B$10=$G14)),0),MATCH(H$13,$C$1:$E$1,0)) with CSE See attached sheet. -- With Regards, Noorain Ansari http:// noorainansari.com http://

Re: $$Excel-Macros$$ Excel 2007...Experiment more than 1,048,576 values in a 1 dimension array

Oops I sent the code from the wrong module. I coded this just to fill one column accross two worksheets within the same workbook. Actually, the following line fill in column B. 'Set ra = wsa.Range(wsa.Cells(1, 2), wsa.Cells(Rows.Count, 2)) Set rb = wsb.Range(wsb.Cells(1, 2), wsb.Cells(1000, 2))

Re: $$Excel-Macros$$ Need Help !!!!

I also second both gentlemen's points. For the solution, use =SUMPRODUCT(($A$2:$A$10=$G$13)*($B$2:$B$10=$G14)*(C$2:C$10)) dragged down and across Regards, Sam Mathai Chacko On Tue, Jul 31, 2012 at 12:10 AM, dguillett1 wrote: > I did not look at your file because you subject line did not hav

Re: $$Excel-Macros$$ Excel 2007...Experiment more than 1,048,576 values in a 1 dimension array

I would use: Sub Macro1()     Dim Dict_aaa, R     Dim tStart, tStop, Elapsed, tMin, tSec, msg         tStart = Timer     Set Dict_aaa = CreateObject("Scripting.Dictionary")     For R = 1 To ActiveSheet.UsedRange.Rows.Count     If (ActiveSheet.Cells(R, "A").Value & "X" <> "X") Then     If (

Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format

Dear Ashish, How will I mark leave, I have Sick Leave, Un Planned Leave , Planned Leave , Vacation? On Mon, Jul 30, 2012 at 11:26 PM, kumar.ashish861 wrote: > Dear Hemanath.D > > Pls find the attached Excel Sheet. > > > Thanks > Ashish kumar > > > > On Monday, July 30, 2012 10:24:15 AM UTC-7, h

Re: $$Excel-Macros$$ Need Help !!!!

I did not look at your file because you subject line did not have a meaningful question and you did not ask your question in the body of the email. It is good that you did provide a file. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mangesh Vimay Sent: M

Re: $$Excel-Macros$$ How to calculate Days and Time.

Either way, you need to consider the time difference between both the countries. Only then will you actually be able to calculate the overall time consumed for the dispatch to be delivered. Sam Mathai Chacko On Mon, Jul 30, 2012 at 11:25 PM, Paul Schreiner wrote: > What kind of solution are you l

Re: $$Excel-Macros$$ Re: Multiple Versions of Excel

You certainly can install many versions on one machine. I have xl97,xl2003,xl2007 and xl2010 on mine. Best to install oldest first. You can only have ONE outlook. Install in SEPARATE folders. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: kumar.ashish861 Se

Re: $$Excel-Macros$$ Re: Pls tell me more about Areas Property of the Range

Not necessarily a Union function. Even if you select two ranges of cells using the CTRL key, and then say Selection.Areas.Count, it will give the number of selections made as different groups of cells. Regards, Sam On Mon, Jul 30, 2012 at 9:25 PM, Prince Dubey wrote: > Hi Sam, > > > Thanks for y

Re: $$Excel-Macros$$ How to calculate Days and Time.

What kind of solution are you looking for? A formula or VBA?   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - Jo

Re: $$Excel-Macros$$ Need Help !!!!

see Forum Rule #1:   1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered.   Paul - “Do all the good you can, By

$$Excel-Macros$$ Need Help !!!!

Hi Friends, Please help me on the sheet provided as an attachment. Waiting for your reply !!! Thanks ! -- With regards, MaNgEsH -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, For

$$Excel-Macros$$ How to calculate Days and Time.

Hi Champs, Please help regarding how to implement Time Consumed formula. Thanks in Advance. Courier Dispatch from Delhi Courier Received in USA Time Consumed Time / Date Time /Date

$$Excel-Macros$$ Excel 2007...Experiment more than 1,048,576 values in a 1 dimension array

Hi, Following a query, I'm trying the code below and I find out that the "aaa" array is dimensionned with 1,049,574 as worksheet wsb column 1 hold 1,000 values, but it doesn't hold values from wsb worksheet. Is there any other way to get all the 2 columns from 2 different worksheet into a script

$$Excel-Macros$$ Excel 2007... experiment more than 1,048,576 value in a vector/array

Hi, Following a query, I'm trying the code below and I find out that the "aaa" array is dimensionned with 1,049,574 as worksheet wsb column 1 hold 1,000 values, but it doesn't hold values from wsb worksheet. Is there any other way to get all the 2 columns from 2 different worksheet into a script

$$Excel-Macros$$ Employee Attendance Tracker with Utilization - Format

Friends, Can any one help me in providing Employee Attendance tracker format with Employee utilization in Excel? -- Thanks Hemanath.D -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Fo

Re: $$Excel-Macros$$ Re: Multiple Versions of Excel

Hello Ashish Kumar Thanks for your suggestion. I did face minor issues like the latest (licensed) version of 2010 opening up even when I needed the earlier version to open. Thanks Ashish Pradhan On 30-07-2012 22:38, kumar.ashish861 wrote: Dear Ashish Pradhan, Don't use two versions of

$$Excel-Macros$$ Re: Multiple Versions of Excel

Dear Ashish Pradhan, Don't use two versions of Excel in one Machine. If you, install two versions of excel in your machine, your PC is not working properly. 2010 version is better option & it is easy to use & If you want to replace your excel version, there is no "Version Clash issues" and you

$$Excel-Macros$$ Re: Download MS Office 2013 (Trial version)

Noorain, are these links safe? Microsoft usually releases trial versions through a dedicated web portail. plz advise -Pascal On Monday, July 30, 2012 7:17:38 AM UTC+1, NOORAIN ANSARI wrote: > > Dear Group, > > Use the following links to download, MS Office 2013 64 Bit & 32 Bit - 60 > days trial

Re: $$Excel-Macros$$

> hi >>> thanks for providing the formula but i am unable to work in 2003 excel which is showing NAME ERROR i am using the formula as provided and its working in 2007 excel but in my office has 2003 excel =networkdays(a4,today()) thanks awaiting positive response regards

$$Excel-Macros$$ Re: Pls tell me more about Areas Property of the Range

Hi Sam, Thanks for your help .As i saw the result i guess that Areas property return cluster of range when there is a range created by using union function. regards prince On Sunday, 29 July 2012 00:28:46 UTC+5:30, Prince Dubey wrote: > > Hi All, > > > I want to know more about Areas proper

Re: $$Excel-Macros$$ Running/Moving Statement

hi Experts, Please advice how to get the scrolling text using marquee code in power point without clicking any button. Any possibility to place marquee text on heading of power point slides which should scroll continuously. i use the ms office 2007. Thanks On Tue, Jan 17, 2012 at 6:57 PM, Ra

Re: $$Excel-Macros$$ Multiple Versions of Excel

Hi Anoop, Both the version of Excel are working just fine. Not quite sure though where the idea of "theft" came in from though. Thanks Ashish Pradhan On 30-07-2012 10:12, Anoop K Sharma wrote: Hi Ashish, You won't face any version clash issue after installing Office 2010. Installing proce

Re: $$Excel-Macros$$ Shortcut key to Align Left, Right & Center in Excel

Hi Anjali, Shortcut Key: 1. For Align Text Left : Alt+H+AL 2. For Center: Alt+H+AC 3.For Align Text Right: Alf+H+AR Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you re

Re: $$Excel-Macros$$ Shortcut key to Align Left, Right & Center in Excel

Hi Anjali, Press Ctrl+L, Ctrl+H, Ctrl+R, or Ctrl+J to *left*-*align*, *center*, *right* -*align* On Mon, Jul 30, 2012 at 11:47 AM, Shreedar wrote: > Hi, Please find the shortcuts you are looking for...Alt+H+AL for Left > Alignments, Alt+H+AC for Center Alignments, & Alt+H+AR for Right Alignmen