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
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
Thanks for your reply.
The problem is resolved.
Regards
Hemant
On Nov 21, 6:18 pm, Manish Pandey maverickpan...@gmail.com wrote:
Hi Hemant,
Go to FileExcel OptionsProofingAuto Correct Options, there uncheck
'internet and network path with hyperlink'. This will resolve creating
hyperlink
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 formula and do the
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
use this
=LEFT(A1,2):RIGHT(A1,2)
Mothilal.J
On Tue, Nov 22, 2011 at 2:57 PM, hemant hemantda...@yahoo.com 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
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
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
Right click sheet tabview codeinsert thischange 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
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 gjmothi...@gmail.com wrote:
use this
=LEFT(A1,2):RIGHT(A1,2)
Mothilal.J
On Tue, Nov
Thank you very much Sam. it works.
From: Sam Mathai Chacko samde...@gmail.com
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
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 Problem,
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
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,
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
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
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 jedi.spen...@gmail.comwrote:
Hello- I am trying to write a formula that would return the COUNT and
SUM, with 3 criteria elements.
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 RULES (934+ members already
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://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On
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))
I think
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!
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
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
No
On Mon, Nov 21, 2011 at 2:09 AM, dguillett1 dguille...@gmail.com wrote:
Did you eever get an answer to this.
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Manhar Kisan manhar.kisangr...@gmail.com
*Sent:* Thursday, November 17, 2011 3:10 AM
*To:*
plz tell me about 9E300.
On Wed, Nov 23, 2011 at 8:06 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Great Solution Haseeb..Excellent..
On Wed, Nov 23, 2011 at 12:59 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hello Santosh,
Another one.
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 a...@lovetour.info 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
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
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?
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,
29 matches
Mail list logo