Re: $$Excel-Macros$$ Fw: Maximum Date

Hi, To copy array formula down, you can choose any of the option below:- 1) Move just below the formula cell and press Ctrl + D 2) Use fill down option (Drag the formula down) 3) After entering the formula - by copy paste. press Ctrl + Shift + Enter. Let me know in case you still have challenges.

Re: $$Excel-Macros$$ Ebook on Excel 2003 VBA

link is not working On Sat, May 8, 2010 at 4:21 PM, João Matoso wrote: > http://www.tudosobrexcel.com/ o link correto > > > 2010/5/8 Harpreet Singh Gujral > > Jaao Matoso, >> >> The link doesnt work >> >> Harry >> >> On May 7, 2:35 am, João Matoso wrote: >> > www.tudosobrexcell.com >> > >>

Re: $$Excel-Macros$$ TOUGH QUESTION

Hi aindril The pictures are stored on my local hard disk. AZHAR RAI Cell: 0333-552-7731 Skype: azhar.rai On 7 May 2010 18:33, Aindril De wrote: > Hi azhar, > > Are these images stored somewhere in your local disk or online? > > Regards, > aindril > > On Fri, May 7, 2010 at 10:46 AM, Azhar Rai

Re: $$Excel-Macros$$ Ebook on Excel 2003 VBA

Dear attaching the links http://www.exceltip.com/ http://www.mrexcel.com/articles.shtml http://www.jaxworks.com/ http://exceluser.com/explore/index.htm On Thu, May 6, 2010 at 7:20 PM, nagendra baral wr

Re: $$Excel-Macros$$ Maximum Date

Thanks to Dilip, I have one more query & attachment is find herewith. Regards -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Joi

$$Excel-Macros$$ One query regarding Vlookup

I have saved some imgaes,Photos in excel sheet. Can i fetch that by using VLookup formula. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldaily

Re: $$Excel-Macros$$ Maximum Date

Hi Dheeraj, Check the attached file, I think it will satisfy you. Both are array formula, so you have to press CTRL+SHIFT+ENTER. Thanks & Regards Sandeep On Mon, May 10, 2010 at 3:32 PM, Dheeraj Bankoti wrote: > > Thanks to Dilip, > I have one more query & attachment is find herewith. > > > >

Re: $$Excel-Macros$$ Maximum Date

Thanks Sandy, @ Dheeraj, I think you have got the answer for your query. Get back, in case of any other queries. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Mon, May 10, 2010 at 3:

Re: $$Excel-Macros$$ vlookup with 2 criteria

Hi nino, check my reply in the $$Excel-Macros$$ Maximum Date problem. Thanks & Regards Sandeep On Sun, May 9, 2010 at 1:12 PM, Ravi Megharaj wrote: > > You can concatenate Column A and Column B to get the unique value. Then do a > vlookup to get the exact value. Once performing this operation,

Re: $$Excel-Macros$$ Maximum Date

@Dilip Ji You are always Welcome sir. Thanks Sandeep On Mon, May 10, 2010 at 7:54 PM, Dilip Pandey wrote: > Thanks Sandy, > > @ Dheeraj, I think you have got the answer for your query. > > Get back, in case of any other queries. > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY >  MBA-HR,B.Com(

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

Hi Anand, You are right, that Asish solution is perfect, but if you don't want to use VBA you can use this one. =RIGHT(A1,LEN(A1)-FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1," ","") Don't see its size, because it is smallest possible using formula. And I assume that your text d

$$Excel-Macros$$ Translate through Macro & Google Translate tool

Dear Excel Guru's, I want to create an macro, by that in a single click, my excel sheet will get translated in whatever language i will select. Is it possible through macro. give me some hint so i will develop some code and will take further help from your side. Regds, Manish -- ---

Re: $$Excel-Macros$$ One query regarding Vlookup

I don't that image can be fetch by vlookup.. vlook can be used only by strings or numbers (date currency, etc). On Mon, May 10, 2010 at 3:09 AM, vidyut more wrote: > I have saved some imgaes,Photos in excel sheet. Can i fetch that by > using VLookup formula. > > -- > > --

Re: $$Excel-Macros$$ One query regarding Vlookup

Hi Harmeet, This workbook doesn't work in Office 2010.. Thanks On Mon, May 10, 2010 at 5:06 AM, Harmeet Singh wrote: > May be attach file will help you > > > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > > > > On Mon, May 10, 2010 at 3:39 PM, vidyut more wrote: > >> I

$$Excel-Macros$$ Fwd: Brackets Before & after Words

> Hellow Friends. > > Can it is possible to do the following > > [ =C1 ] > > I am taking the name from the C1 & I want Bracket [ ] before & after word > > so that i can change & adjust the cell size. > > Ex. --[Mr. Guru Datt ] the word Guru Datt had taken from C1 cell > > Thanks > Have a nic

Re: $$Excel-Macros$$ Worksheets password break

Please tell Me how to use this Code step by step On Sun, Apr 4, 2010 at 2:51 AM, Vishal Parihar wrote: > Hi Friends > > Today i am going to show you how to crack excel sheets password. > > Vba code to break password. > > Sub PasswordBreaker() > Dim i As Integer, j As Integer, k As Integer > Dim

$$Excel-Macros$$ VBA Macro that send emails with 5 attached files from one directory

Hello there I already have prepared the macro that gets the mail Addresses and names and prepares the email to me, however I don´t know how to attach all files from a certain directory. The method would be “With myItem .attachement.add “file to be attached” End wi

Re: $$Excel-Macros$$ Fwd: Brackets Before & after Words

use: = "[" & C1 &  "]" Paul From: big smile To: EXCEL MACRO GROUP Sent: Mon, May 10, 2010 9:20:05 AM Subject: $$Excel-Macros$$ Fwd: Brackets Before & after Words Hellow Friends. > >Can it is possible to do the following > >[ =C1  ] > >I am taking the na

$$Excel-Macros$$ Macros in 2010

The following code fails in excel 2010 and it worked fine in 2007 Sheets("Report").Select [Meeting_Date].Select I get the error messages "Compile Error can't find project or library" In the names manager: Meeting_Date refers to:=Report!$N$8 with the scope workbook. the file is an

Re: $$Excel-Macros$$ Fwd: Brackets Before & after Words

Or you can use the Concatenate formula to work on the same. Regards Rahul Gandhi. On May 10, 6:20 pm, big smile wrote: > > Hellow Friends. > > > Can it is possible to do the following > > > [ =C1  ] > > > I am taking the name from the C1 & I want Bracket [  ] before & after word > > > so that i

$$Excel-Macros$$ Conver numeric value in words.

Hello all. I want to convert numeric values in words. isthere any shortcut in that. -- Nikhil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/excel

$$Excel-Macros$$ How to use creat & macros.

Hello all. Can any body help in making and using macros. -- Nikhil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedI

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

Dear Sandeep, Thanks for your solution. It is a great help you have done to me. Thanks and Regards, Anand S On Mon, May 10, 2010 at 8:42 PM, Sandeep Kumar Maurya wrote: > Hi Anand, > > You are right, that Asish solution is perfect, > but if you don't want to use VBA you can use this one. > >