Try this:
Public StartTIme
Public EndTime
Public ResTime As String
Sub StartTimer()
MsgBox "Time Start Now"
StartTIme = Time
End Sub
Sub EndTimer()
EndTime = Time
ResTime = Format(StartTIme - EndTime, "hh:mm:ss")
MsgBox "Total " &
Range("rngFilled").SpecialCells(xlCellT
Dear Sir,
Thanks for your support it working fine.
Once again thank you.
Thanks & Regards,
Prajakt Pande
+971551388482
**
On Wed, May 9, 2012 at 10:33 PM, dguillett1 wrote:
>
> This does each number in col R only ONCE.
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille..
Dear Aamir
You can use this also..
Sub Sheet1Multiplecopy()
Dim noOfSheet As Long
Dim strTEmp As String
Dim lngLoop As Long
On Error Resume Next
strTEmp = InputBox("Enter no of Sheets:-", "Sheet Number")
On Error GoTo 0:
Dear Mansoor,
Please use it
=COUNTIF(A1:A2,"* a*")
On Sat, May 12, 2012 at 6:35 PM, danial mansoor wrote:
>
> Dear experts!
>
> the are two names i used and apply this formula using a wild card
> =COUNTIF(C20:C21,"*a*") its gives me answer 2 instead of 5 because in the
> given data there are 5
Sub Sheet1Multiplecopy()
Dim i As Long
For i = 1 To InputBox("howmany")
Sheets("Sheet1").Copy After:=Sheets(i)
ActiveSheet.Name = i
Next i
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, May 12, 2012 2:40 PM
To: excel-macros@goo
For i = 1 To inputbox(“how many”)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, May 12, 2012 1:51 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ amend in macro
Dear Group,
Following macro provided by anyone in th
OOps, typos --
Sub Sheet1Multiplecopy()
Dim s1 as worksheet, n as long
set s1=worksheets(1)
For n = msgbox("How many sheets do you want to add?") to 1 step -1
s1.Copy After:=s1
ActiveSheet.Name = n
Next
s1.select
End Sub
From: Asa Rossoff [mailto:a...
Sub Sheet1Multiplecopy()
Dim s1 as worksheet, n as long, c as long
c = worksheets.count
set s1=worksheets(1)
For n = msgbox("How many sheets do you want to add?) to 1 step -1
s1.Copy After:=s1
ActiveSheet.Name = n
Next
s1.select
End Sub
From: exce
Thank you "Don & Asa".
On Sat, May 12, 2012 at 11:46 PM, Asa Rossoff wrote:
> Hi Aamir,
>
> You can use
>
>
> =SUMPRODUCT(SUBTOTAL(9,OFFSET($I$10,ROW($I$11:$I$100)-ROW($I$10),)),--($A2=$H$11:$H$100))
>
>
> in C2 and copy down.
>
> ** **
>
> It will work for a filtered list like
Hi Aamir,
You can use
=SUMPRODUCT(SUBTOTAL(9,OFFSET($I$10,ROW($I$11:$I$100)-ROW($I$10),)),--($A2=$
H$11:$H$100))
in C2 and copy down.
It will work for a filtered list like SUMIF. change the SUBTOTAL type from
9 to 109 to have it ignore rows that are manually hidden as well. Best not
to use
=SUMPRODUCT(SUBTOTAL(3,OFFSET($H$11:$H$100,ROW($H$11:$H$100)-MIN(ROW($H$11:$H$100)),,1)),--($H$11:$H$100=A2),--($I$11:$I$100))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, May 12, 2012 12:31 PM
To: excel-macros@googlegroups
Example file is attached.
On Sat, May 12, 2012 at 9:04 PM, dguillett1 wrote:
> Your desire is not clear. Provide a file with a complete explanation
> and examples.
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Aamir Shahzad
> *Sent:* Saturday,
Your desire is not clear. Provide a file with a complete explanation and
examples.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, May 12, 2012 10:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query
pick the v
Hi Yogananda
I test this file so many times but didn't get this kind of situation,
so please whenever you get this situation then send me the file with
the explanation.
Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation
On Fri, May 11, 2012 at 11:06 PM, yogananda muthaiah
wr
pick the values by vlookup or sumif only on visible cells.
On Sat, May 12, 2012 at 8:19 PM, Rajan_Verma wrote:
> CLTL+G
> ALT+S
> K
>
> Enter
>
>
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googleg
Hi Lalit,
Thanks a lot for sending the resolved query. Now i am able to edit the
other cells when text is running mode.
Thank you very much. Have a great future ahead.
Regards
Lokesh.M
On Sat, May 12, 2012 at 8:45 PM, ╰» ℓαℓιт мσαнη wrote:
> Hi
>
> PFA
>
> Regards,
> Lalit Mohan
> https://www.
CLTL+G
ALT+S
K
Enter
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: 12 May 2012 8:40
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ query
Dear Group,
How to
Hi Aamir,
You can use SUBTOTAL formula accordingly.
for ex.:
Sum of visible cells :- =SUBTOTAL("A1:A100",109)
Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation
On Sat, May 12, 2012 at 8:39 PM, Aamir Shahzad wrote:
> Dear Group,
>
>
>
> How to pick the values by formula
Hi
PFA
Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation
On Sat, May 12, 2012 at 6:57 PM, Lokesh Loki wrote:
> Hi Experts.
>
> I am waiting for your reply.
>
> Regards
> Lokesh
>
>
> On Fri, May 11, 2012 at 9:28 PM, Lokesh Loki
> wrote:
>>
>> Hi Rajan,
>>
>> Yes you have se
Hi Experts.
I am waiting for your reply.
Regards
Lokesh
On Fri, May 11, 2012 at 9:28 PM, Lokesh Loki wrote:
> Hi Rajan,
>
> Yes you have sent, but it's not working.If you dont mind can u please send
> me with the solution excel file.
>
> So that i would help me a lot.
>
> Regards
> Lokesh.M
>
>
Dear,
Enter the following as an Array Formula (you need to press
Ctrl+Shift+Enter, when you enter the formula)
{=SUM(LEN(A1:A2)-LEN(SUBSTITUTE(A1:A2,"a","")))/LEN("a")}
Use the formula evaluation tool to check how it works. Otherwise everyone
is here to help you :)
On Sat, May 12, 2012 at 6:35
Formula to count how many times a particular character appear in a cell
is =LEN(A1)-LEN(SUBSTITUTE(A1,"a",""))
I am trying to find how to find such count for a range.
On Sat, May 12, 2012 at 6:35 PM, danial mansoor wrote:
>
> Dear experts!
>
> the are two names i used and apply this formula using
This is very possible with an indirect formula or defined names or with a
macro. Provide a file and your desires.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Shekhar Sharma
Sent: Friday, May 11, 2012 4:59 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-
Dear,
Countif checks only the first instance of the value to be found.
On Sat, May 12, 2012 at 6:35 PM, danial mansoor wrote:
>
> Dear experts!
>
> the are two names i used and apply this formula using a wild card
> =COUNTIF(C20:C21,"*a*") its gives me answer 2 instead of 5 because in the
> give
Dear experts!
the are two names i used and apply this formula using a wild card
=COUNTIF(C20:C21,"*a*") its gives me answer 2 instead of 5 because in
the given data there are 5 "a" instead of 2.
ali a
daniyal a
so any one could explain me why it is given 2 instead
Homework?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Saturday, May 12, 2012 12:05 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Name Manager
Hi,
I want to know about Name Manager.. .. what is the use of Name manager.
Hi,
By using names, you can make your formulas much easier to understand
and maintain. You can define a name for a cell range, function,
constant, or table. Once you adopt the practice of using names in your
workbook, you can easily update, audit, and manage these names.
Regards,
Lalit Mohan
ht
Name manager is used to Assign a Name to a Range on worksheets
After define a name you can refer that range by that Name you assigned
1) Press Ctrl+F3
2) Alt+N (New)
3) Fill the Name
4) Select the Scope
5) Select the Range
If Your Define a name rngMyRange fo
28 matches
Mail list logo