Re: Re: $$Excel-Macros$$ Almost all calculator in one sheet

Thanks a lot Mr.Ankit. Its amazing. Only thing can be added was the new mobile codes starting with 8 and 7. Thanks again. Regards, Sujit Mazumdar Bhubaneshwar Sent on my BlackBerry® from Vodafone -Original Message- From: Ankit Agrawal Sender: excel-macros@googlegroups.com Date: Thu, 1

Re: $$Excel-Macros$$ Almost all calculator in one sheet

Thanks. -Nas On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal wrote: > Hello All, > > In our daily life we calculate so many thing & use different calculator. > Here is one excel file which contain almost all calculator. > > > Calculate & enjoy !!! > > > Regards, > > Ankit > > -- > FORUM RULES (9

Re: $$Excel-Macros$$ Indirect Function

hi chethan can u explain how u use "getphoto" in Indirect example 3. Thanks & regards Dhartikumar Sahu On Thu, Dec 1, 2011 at 3:07 AM, B.N.Chethan Kumar wrote: > Hope these help. > > > On Wed, Nov 30, 2011 at 11:47 PM, Aamir Shahzad > wrote: > >> Dear Group, >> >> Please provide the "Indirect

Re: $$Excel-Macros$$ macro to translate from one languague to another

Hi Sam, As suggested, I searched the net, however didnot find anything or it was that couldnot understand anything. Having a paid option doesnot work for me as I am looking for a macro to automate a time consuming activity. Donot have the scale to justify an expense to achieve it Any help fro

Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles

This is exactly what I needed... Thanks a ton Noorian.. :) Warm regards! Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Thu, 1 Dec 2011 10:59:27 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-M

Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles

Dear Krishnan, Please use below link for excel Puzzle. http://www.skills-assessment.net/test/frmTestQuestions.aspx?q=1&lk=GBOST-GFAIB-GTQWT-KQHMI-AWWLX -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspo

Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles

Dear all, still waiting for an update... Sent on my BlackBerry® from Vodafone -Original Message- From: krishnanm2...@gmail.com Date: Wed, 30 Nov 2011 16:10:13 To: Reply-To: krishnanm2...@gmail.com Subject: Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles Dear experts, any news

Re: $$Excel-Macros$$ Help for If nesting formula

Hi, Try also without any tables, =LOOKUP(A2,DATE(YEAR(TODAY()),-{1342,35,12,9,6,3}+MONTH(TODAY()),0),{"Prospect";"> 12 Month";"9 - 12 Month";"6 - 9 Month";"3 - 6 Month";"0 - 3 month"}) Or, if you activate Analysis ToolPak AddIn (unless if you are using XL2007 or later), you can simplify, =LO

Re: $$Excel-Macros$$ Indirect Function

Dear Aamir, The INDIRECT Function The *INDIRECT* worksheet function is a useful tool for creating cell or range references "on the fly", as a formula is evaluated, rather than "hard coding" them into the formula. Microsoft's on-line Help documentation of this fun

Re: $$Excel-Macros$$ Need Help

Hi, As feared, these was not working...no issue in codes. only issue was...i was not able to select a folder in network...these was helpful for all folder in my local harddisck... I was not able to select any other loction or path. Regards Chethan Kumar BN On Wed, Nov 30, 2011 at 4:49 AM, dgui

$$Excel-Macros$$ Indirect Function

Dear Group, Please provide the "Indirect Function" samples how is it working & when we use? Sample files will appreciate. Regards, Aamir Shahzad -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Ne

Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles

Dear experts, any news on this? Warm regards Sent on my BlackBerry® from Vodafone -Original Message- From: krishnanm2...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 30 Nov 2011 05:51:49 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Link for complex

$$Excel-Macros$$ Re: Almost all calculator in one sheet

Hello, Your file is awesome, but it would be best if you gave us also the password, most sheets in this file are locked and I want to be able to play with the formulas and not just use the file as it is. Thanks! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accur

$$Excel-Macros$$ Re: importing text to excel

How about this Sub T() Dim rng As Range Dim lngRow As Long With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;P:\Macro\SAP Dump.text.txt", Destination:=Range("$A$1")) .Name = "SAP Dump.text_1" .FieldNames = True .RowNumbers = False .FillAdjac