Re: $$Excel-Macros$$ Why is usedrange here returning the entire spreadsheet?

This works. Is there a reason why it is not better? I did your array replacement but I changed this Set InputRange = Application.Intersect(Sheets(ContangoSource).UsedRange, Sheets(ContangoSource).Columns(ConDate)) with this Set InputRange = Sheets(ContangoSource).UsedRange.Columns(ConDate)

Re: $$Excel-Macros$$ Order by Rank

Hi Try =RANK(A2,$A$2:$A$20)+COUNTIF($A$2:A2,A2)-1 adjust the range. Kris -- FORUM RULES (986+ members already BANNED for violation) 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

RE: $$Excel-Macros$$ Access..

Try this : http://www.w3schools.com/ Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Apr/Sun/2012 06:23 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Access.. Hi All, Can you provide me MS ACCESS.

Re: $$Excel-Macros$$ Access..

Hi . Raj I am not able to find ACCESS in that link.Thanks On Sun, Apr 8, 2012 at 6:25 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Try this : ** ** http://www.w3schools.com/ ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto:

RE: $$Excel-Macros$$ Order by Rank

Hi krish, Please explain the result in attached sheet.. I think its not giving correct result.. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kris Sent: Apr/Sun/2012 03:52 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

RE: $$Excel-Macros$$ Access..

You can find sql queries on that link , please check this link http://www.functionx.com/vbaccess/ Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Apr/Sun/2012 06:30 To: excel-macros@googlegroups.com Subject: Re:

RE: $$Excel-Macros$$ Order by Rank

Please ignore previous attachment.. Rajan. From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: Apr/Sun/2012 06:31 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Order by Rank Hi krish, Please explain the result in attached sheet.. I think its not giving

Re: $$Excel-Macros$$ Order by Rank

The formula should be =RANK(A2,$A$2:$A$9)+COUNTIF($A$2:A2,A2)-1 Kris -- FORUM RULES (986+ members already BANNED for violation) 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

Re: $$Excel-Macros$$ Access..

Hi, Check below links Very Useful... MVP'S Web Links Al Campagna http://home.comcast.net/~cccsolutions/index.html Alex Dybenko http://Alex.Dybenko.com http://alex.dybenko.com/ Allen Browne http://allenbrowne.com Andrew Couch http://www.upsizing.co.uk Andy Baron http://www.mcwtech.com/

Re: $$Excel-Macros$$ Editing text in an unlocked cell of a protected sheet

*Can you share your file...* On Sun, Apr 8, 2012 at 4:18 AM, David davidjad...@gmail.com wrote: I'm looking for assistance in fixing a problem a user found. I have a form created in Excel 2010. All cells on the form were locked - then specific cells were unlocked. This allowed the users to

$$Excel-Macros$$ Please help on basic Excel

Hi Attached is a file in which in the loss column ( M Column ) the amount appears with the - ( Minus ) in the beginning. Kindly advise what can be done by which the minus will not appear. Thanks and Regards Aruna -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,

RE: $$Excel-Macros$$ Please help on basic Excel

See the attached file Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aruna jayaram Sent: Apr/Sun/2012 11:09 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please help on basic Excel Hi Attached is a file in which in the loss

Re: $$Excel-Macros$$ Please help on basic Excel

Hi Rajan, In the M column it should appear as 1600 and not -1600. Thanks Aruna On Sun, Apr 8, 2012 at 11:12 PM, Rajan_Verma rajanverma1...@gmail.comwrote: See the attached file ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com]

RE: $$Excel-Macros$$ Please help on basic Excel

See the attached sheet Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aruna jayaram Sent: Apr/Sun/2012 11:21 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please help on basic Excel Hi Rajan, In the M column it should

Re: $$Excel-Macros$$ Please help on basic Excel

Thanks a lot Rajan for such quick solution On Sun, Apr 8, 2012 at 11:23 PM, Rajan_Verma rajanverma1...@gmail.comwrote: See the attached sheet ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Aruna jayaram *Sent:*

$$Excel-Macros$$ Macro to Print the sheet in PDF and save in a folder.

Dear All, please find the below mentioned Macro which I recorded to print a sheet in PDF, Sub test() Application.ActivePrinter = PDFCreator on Ne01: ExecuteExcel4Macro _ PRINT(2,3,3,12,PDFCreator on Ne01:,,TRUE,,FALSE) End Sub Can somebody please modify the macro which

$$Excel-Macros$$ Could this loop be replaced by some range method?

I am trying to get more used to using ranges instead of addressing individual cells by indexes. The loop below is rounding off the entries in all the columns where BarOpen for example is just the column index in the sheet. Is there a way to do this more efficiently by using the used range

$$Excel-Macros$$ If you put a userform on a sheet is that part of the usedrange?

I would like to have a userform on a data sheet for setting parameters and controls. But if that useform is considered part of the range by the usedrange function then I will have to put it on a separate sheet which would be something of a pain. -- FORUM RULES (986+ members already BANNED for

$$Excel-Macros$$ Re: pls help with sum if formula

Hello Lee, One way: =SUM(SUMIF(G3:G409,{350,449},$D$3:$D$409)*{1,-1}) Will sum 351-449. if you want to include 450, change 449 to 450 ___ HTH, Haseeb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

$$Excel-Macros$$ one to many FILES , depeding upon filter condition

Dear Sir, MY request is to get the data into MULTIFLE FILES depending upon FILTER Selected. The file names should be say ahm-item-1, ahm-item-2 etc.. [ these will be unique combination] in a subdirectory named say XXYY, which will cotain ALL colms for the selected filters on col. A B so a

Re: $$Excel-Macros$$ Order by Rank

Thanks everyone. Sent on my BlackBerry® from Vodafone -Original Message- From: Kris krishnak...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 8 Apr 2012 06:34:59 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Order by

Re: $$Excel-Macros$$ pls help with sum if formula

also you can use the below formula if you are using ms office 2007 or later versions =sumifs(d3:d409,g3:g409,350, g3:g409,450) On Mon, Apr 9, 2012 at 10:11 AM, Maries talk2mar...@gmail.com wrote: Hi, Try Below Formulas, =SUMPRODUCT(--((G3:G409350)*(G3:G409450))*D3:D409)

Re: $$Excel-Macros$$ If you put a userform on a sheet is that part of the usedrange?

Never mind, answered my own question. On Sun, Apr 8, 2012 at 3:48 PM, tangledweb domainqu...@gmail.com wrote: I would like to have a userform on a data sheet for setting parameters and controls. But if that useform is considered part of the range by the usedrange function then I will have to