RE: $$Excel-Macros$$ Incrementing Row by 1 in a Variable

Hi Jim, I'm glad my code worked out! By "selecting cells" I'm actually referring to the use of the .Select method that you use. Referring to cells using A1-type notation is fine, especially if you have a specific cell or range to refer to. There are several ways of referring to cells in VBA,

Re: $$Excel-Macros$$ Incrementing Row by 1 in a Variable

Asa, first off, thank you for your fast response. I think I understand your logic and it seems so simple :-) In you reference to my rookie mistake and selecting cells, are you suggesting that I do not need to call out the absolute cell reference (i.e., A1) but can use Cells(x.x).Select command?

$$Excel-Macros$$ Save a File From a Macro as a TXT file without an File Extension

Hi, all. I'm trying to save a file that I modified in a macro as a text file without an extension (.txt). Is that possible? I'm able to save the file as a text file, but it appends the file extension (.txt). Thanks, Tom -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ Incrementing Row by 1 in a Variable

Asa, just tried the code you provided. It works great! You ROCK! Thanks again, Tom On Tue, Nov 22, 2011 at 8:01 PM, Asa Rossoff wrote: > Hi TomR, > > ** ** > > You can use the same technique you use to increment the row selected at > the end of the loop to reference cells in the selected

Re: $$Excel-Macros$$ need correction in the formula

plz tell me about 9E300. On Wed, Nov 23, 2011 at 8:06 AM, NOORAIN ANSARI wrote: > Great Solution Haseeb..Excellent.. > > > On Wed, Nov 23, 2011 at 12:59 AM, Haseeb Avarakkan < > haseeb.avarak...@gmail.com> wrote: > >> Hello Santosh, >> >> Another one. >> >> >> =IFERROR(LOOKUP(9E300,SEARCH

Re: $$Excel-Macros$$ Sales Data entry form

No On Mon, Nov 21, 2011 at 2:09 AM, dguillett1 wrote: > Did you eever get an answer to this. > > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Manhar Kisan > *Sent:* Thursday, November 17, 2011 3:10 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$

Re: $$Excel-Macros$$ Indirect formula

Noorain Sir, I tried to understand it by example also but failed to understand.I know this is my fault but please make me understand in easy word, I can not understand in technical language. I will oblige you. Regards, Ankit On Fri, Nov 18, 2011 at 2:45 PM, NOORAIN ANSARI wrote: > Dear Ankit,

RE: $$Excel-Macros$$ Incrementing Row by 1 in a Variable

Hi TomR, You can use the same technique you use to increment the row selected at the end of the loop to reference cells in the selected row: the Offset property. (The main rookie mistake I will mention is that there is no need to select cells at all in a macro - you can reference them anywa

RE: $$Excel-Macros$$ Need Help with IF(AND formula

P.S. Oh - for taking the sum with sumproduct, just add the sum range as an additional argument to SUMPRODUCT (the order of arguments doesn't matter -- they are all multiplied by each other). If your values to sum are in column X: =SUMPRODUCT(--(data!F:F="A",--(data!B:B="04 - Closed Won"),--(data!

RE: $$Excel-Macros$$ Need Help with IF(AND formula

If you are using Excel 2007+, use COUNTIFS for count and SUMIFS for sum. If using an older Excel, use SUMPRODUCT for either. IF(AND(data!F:F = "A"),and(data!B:B, = "04 - Closed Won"), and(data! D:D, = Oct-11),count, "0") =COUNTIFS(data!F:F,"A",data!B:B,"04 - Closed Won",data!D:D,DATE(2011,10,1))

Re: $$Excel-Macros$$ Need Help with IF(AND formula

You can also try... =SUMPRODUCT((data!F:F = "A")*(data!B:B="04 - Closed Won")*(data!D:D="Oct-11")*(data!K:K=0)) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ need correction in the formula

Great Solution Haseeb..Excellent.. On Wed, Nov 23, 2011 at 12:59 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello Santosh, > > Another one. > > > =IFERROR(LOOKUP(9E300,SEARCH({"Sa","Su","Sha"},B4),{"Hero","Boy","Shaan"}),"") > > __ > HTH > Haseeb > > -- > FORUM RU

Re: $$Excel-Macros$$ Need Help with IF(AND formula

Hi, If you are using Excel 2007 or 2010, then you can use the SUMIFS or COUNTIFS to achieve the same. Cheers Andy On Tue, Nov 22, 2011 at 11:00 PM, Jedi Spencee wrote: > Hello- I am trying to write a formula that would return the COUNT and > SUM, with 3 criteria elements. > > IF(AND(data!F:F =

$$Excel-Macros$$ Need Help with IF(AND formula

Hello- I am trying to write a formula that would return the COUNT and SUM, with 3 criteria elements. IF(AND(data!F:F = "A"),and(data!B:B, = "04 - Closed Won"), and(data! D:D, = Oct-11),count, "0") Can this be done? Thank you. -- FORUM RULES (934+ members already BANNED for violation) 1) Use

$$Excel-Macros$$ Incrementing Row by 1 in a Variable

Hi all, I'm new to the group and pretty new to Excel/VBA programming; learning while drowning. I'm building a macro to convert a text data/configuration file with data from an Excel spreadsheet. I'm using a variable that references a cell where I'm getting the first portion of my data from. I'm us

Re: $$Excel-Macros$$ Look up values

I don't think your sample matches what you said. Array formula that must be entered using ctrl+shift+enter =MAX(IF(($A$2:$A$5000=A10)*($D$2:$D$5000=1),$C$2:$C$5000)) Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: RockyFontane Sent: Tuesday, November 22, 201

$$Excel-Macros$$ Look up values

Excel Experts, I need your help. I have a spreadsheet where I have unique ID, Log Types, and a Key Value. The Key Value represents a Boolean code (1,0) that suggests the Log Type equals the data I want to analyze. I want to take the most recent date for each unique lead ID where the key value =

Re: $$Excel-Macros$$ need correction in the formula

Hello Santosh, Another one. =IFERROR(LOOKUP(9E300,SEARCH({"Sa","Su","Sha"},B4),{"Hero","Boy","Shaan"}),"") __ HTH Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ Paste Special VS Paste Special

Thank you very much Sam. it works. > > From: Sam Mathai Chacko >To: excel-macros@googlegroups.com >Sent: Monday, 21 November 2011 9:59 PM >Subject: Re: $$Excel-Macros$$ Paste Special VS Paste Special > > >To copy paste a format from one workbook to another wor

Re: $$Excel-Macros$$ Cell Formatting

Hi, Just convert it to real time and apply time format as well. =--(LEFT(A1,2)&":"&RIGHT(A1,2)) --- Ms.Exl.Learner --- On Tue, Nov 22, 2011 at 5:30 PM, jmothilal wrote: > use this > > =LEFT(A1,2)&":"&RIGHT(A1,2) > > Mothilal.J > > > > On Tue, Nov 22, 20

Re: $$Excel-Macros$$ Cell Formatting

Right click sheet tab>view code>insert this>change column 3 to suit Now IF the length of the string is 4 and it’s a number, it will be automatic. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Or Target.Column <> 3 Then Exit Sub If IsNumeric(Target) And Len(Application.

Re: $$Excel-Macros$$ Conditional Formatting using named ranges

Post your macro code and/or attach your file. Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: zp18 Sent: Tuesday, November 22, 2011 5:52 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Conditional Formatting using named ranges Excel 2007- I have

$$Excel-Macros$$ Connect Access Database

Dear Team, Can any one please suggest me that how to connect MS - Access database using Visual Basic. I have a database mdb file and I want to connect it from VB front end. Any help or suggestion will be greatly appreciated. Thanks, Sharma -- FORUM RULES (934+ members already BANNED for viola

Re: $$Excel-Macros$$ Cell Formatting

use this =LEFT(A1,2)&":"&RIGHT(A1,2) Mothilal.J On Tue, Nov 22, 2011 at 2:57 PM, hemant wrote: > Hi all > > I am supposed to enter data in say "22:11" format in Excel 2007. > > Is there any method by which i will enter only "2211" and cell shows > it as "22:11". > > Thus it will save my time

$$Excel-Macros$$ Conditional Formatting using named ranges

Excel 2007- I have a large spreadsheet that I add 2 rows to daily. I also have about a dozen conditional formatting formulas that flag certain conditions for quick identification. The worksheet that gets the daily data is named "DataSheet" I've written a quick VBA Macro that sets a named range

Re: $$Excel-Macros$$ need correction in the formula

Dear Santosh, Please try it.. =IF(NOT(ISERROR(SEARCH("sa",B4,1))),"Hero",IF(NOT(ISERROR(SEARCH("Su",B4,1))),"Boy",IF(NOT(ISERROR(SEARCH("Sha",B4,1))),"Shaan",""))) On Tue, Nov 22, 2011 at 1:38 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi All, > > Please look into the formul

Re: $$Excel-Macros$$ need correction in the formula

Hi Santosh, Please find attached sheet with correction in formula. Thanks Mukesh - Original Message - From: santosh subudhi To: excel-macros@googlegroups.com Sent: Tuesday, November 22, 2011 1:38 PM Subject: $$Excel-Macros$$ need correction in the formula Hi All, Plea

$$Excel-Macros$$ Cell Formatting

Hi all I am supposed to enter data in say "22:11" format in Excel 2007. Is there any method by which i will enter only "2211" and cell shows it as "22:11". Thus it will save my time to enter ":" (Semicolon) frquently. I am supposed to enter lot of data in this format and thus has to enter ":" a

Re: $$Excel-Macros$$ "@" character in Excel

Thanks for your reply. The problem is resolved. Regards Hemant On Nov 21, 6:18 pm, Manish Pandey wrote: > Hi Hemant, > > Go to File>Excel Options>Proofing>Auto Correct Options, there uncheck > 'internet and network path with hyperlink'. This will resolve creating > hyperlink automatically. > >

Re: $$Excel-Macros$$ Deleting modules

hi chandra, please find the below code for remove module .. http://www.ozgrid.com/VBA/delete-module.htm Sub DeleteThisModule() Dim vbCom As Object Set vbCom = Application.VBE.ActiveVBProject.VBComponents vbCom.Remove VBComponent:= _ vbCom.Item("Module1") End Sub On Tue, Nov

$$Excel-Macros$$ need correction in the formula

Hi All, Please look into the formula and do the necessary correction. -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,