$$Excel-Macros$$ Help with sending file as an email with vba

[gargee singh]

Dear Experts , 

 

I need help with the below code.

 

This code emails the current active file as an attachment while also
copying a specific range of cells from the sheet. It works fine except that it
removes the user signature. 
I want to pick the user signature. 

 

Sub sumit()

Dim outapp As Object

Dim outmail As Object

Set outapp = CreateObject("outlook.application")

Set outmail = outapp.CreateItem(0)

On Error Resume Next

With outmail

Set doc =
outmail.getinspector.WordEditor

Body = ActiveSheet.Range("f10:n31").Value

.To =
"t...@outlook.com"

 .CC = " "

.Subject = ActiveWorkbook.Name

   
ActiveSheet.Range("f10:n31").Copy

Set WrdRng = doc.Range

.display

WrdRng.Paste

.display 'or use.send

End With

On Error GoTo 0

Set outmail = Nothing

Set outapp = Nothing

MsgBox ("you Mail has been sent to " & SendID)

End Sub





Thanks and Regards,
Gargee Singh
 
  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: EXCEL FILE WITH MACRO TO GENERATE SUMMARY REPORT

[Nasir Saikh]

Dear Siraj,

Can you please share a sample which type summary you required.



On Thursday, September 10, 2015 at 9:33:09 AM UTC+5:30, Siraj Momin (BHOG) 
wrote:
>
> Deal all
>
>  
>
> Do any body have sample excel file with macro to generate summary report. 
> Which calculates the data
>
>  
>
>  
>
> Regards,
>
> Siraj
>
>  
>
>  
>
>  
>
>  
> --
> *This email and any attachments to it may be confidential and are intended 
> solely for the use of the recipient(s). If you are not the intended 
> recipient of this email, you must neither take any action based upon its 
> content, nor copy or show it to anyone. Please contact the sender if you 
> believe you have received this email in error. Statements and opinions 
> expressed in this e-mail are those of the sender, and do not necessarily 
> reflect those of CCC unless explicitly so mentioned. FYI, CCC regularly 
> deploys anti-virus and malicious software protection, we however cannot 
> accept any liability for damage caused by any virus / error transmitted by 
> this email. * 
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ EXCEL FILE WITH MACRO TO GENERATE SUMMARY REPORT

[Siraj Momin (BHOG)]

Deal all

Do any body have sample excel file with macro to generate summary report. Which 
calculates the data


Regards,
Siraj





This email and any attachments to it may be confidential and are intended 
solely for the use of the recipient(s). If you are not the intended recipient 
of this email, you must neither take any action based upon its content, nor 
copy or show it to anyone. Please contact the sender if you believe you have 
received this email in error. Statements and opinions expressed in this e-mail 
are those of the sender, and do not necessarily reflect those of CCC unless 
explicitly so mentioned. FYI, CCC regularly deploys anti-virus and malicious 
software protection, we however cannot accept any liability for damage caused 
by any virus / error transmitted by this email.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ terms

[GENIUS]

I appreciate the time you gave me for my problem and giving me the support.

On Wednesday, 9 September 2015 20:19:38 UTC+5, Paul Schreiner wrote:
>
> Again, not a problem.
> The biggest issue you run into when asking for help is that 
> YOU know what it is you're looking for, but when you ask a question, you 
> must communicate everything that you already know.
>
> That is: you wish to do something with some data.
> What does the data look like?
> where did it come from?
> what is the format?
> What is the sheet name?
> what do you want it to end up looking like?
>
> the big question is: how much of what you already know from looking at 
> your data will someone who has never SEEN the data need to know?
>
> If they cannot determine needed information from your question or example, 
> they must make assumptions that they, in turn, must communicate back to YOU.
>
> sometimes, the VBA help shows alternatives, or gives you hints to other 
> areas that you can look at that answers questions you haven't yet asked!
>
> Just let us know how we can help!
> (just be ready to get as many clarification questions BACK as answers)
>  
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John Wesley*
> -
>
> --
> *From:* GENIUS >
> *To:* MS EXCEL AND VBA MACROS > 
> *Cc:* schrein...@att.net  
> *Sent:* Wednesday, September 9, 2015 4:30 AM
> *Subject:* Re: $$Excel-Macros$$ terms
>
>
>
> On Tuesday, 8 September 2015 16:47:00 UTC+5, Paul Schreiner wrote:
>
> First of all, learning by yourself is admirable!
> There are lots tools that help.
>
> The one I use the absolute MOST is the HELP within the VBA editor.
>
> In the upper right of the editor window, you'll see a box that says "Type 
> a question for help".
>
> In that box, type: 
> Option Explicit
>
> You'll get a list of search results.
>
> Click the first one: 
> Option Explicit Statement
>
> It explains that:
> *When Option Explicit appears in a module, you must explicitly declare all 
> variables using the Dim, Private, Public, ReDim, or Static statements. If 
> you attempt to use an undeclared variable name, an error occurs at compile 
> time.*
>
>
> So, basically, Option Explicit makes it so that all variables must be 
> declared FOR THAT MODULE.
> Normally, you'd have to manually put "Option Explicit" at the beginning of 
> each module.
> Clicking "Require Variable Declaration" makes VBA put it there 
> automatically.
>
> *2) What is procedure and sub procedure with example please.*
>
> A "procedure" is a general term for what is commonly called VBA "macros".
> They can be Subs (subroutines), Functions and Property types (which is 
> MUCH less common).
>
> As for creating a "sub procedure", 
>
> your confusion is probably with the definition of "sub".
>
> It is NOT "subordinate"
> as if it were:
> 1) Procedure
>  a) Sub-Procedure
>
> It refers to a SUBROUTINE:
>
> As in:
>
> Sub Test
>MsgBox "Hello"
> End Sub
>
> If you need help with the VBA debugger or specific help with a project, 
> let us know.
>
>  
> *Paul*
> -- ---
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John 
> Wesley*-- 
> ---
>
> --
> *From:* Izhar 
> *To:* excel-...@googlegroups.com 
> *Sent:* Tuesday, September 8, 2015 12:09 AM
> *Subject:* $$Excel-Macros$$ terms
>
> HI
> now a days i'm trying to learn vba by myself during learning I come across 
> with these words can anyone explain in details what those words are.
>
>
> 1) why we enable REQUIRE VARIABLE DECLARATION, when we enable it, that 
> shows a code i.e OPTION EXPLICIT, what is it why we check the button of 
> REQUIRE VARIABLE DECLARATION.
> 2) what is procedure and sub procedure with example please.
>
>
>
>
>
> -- 
> *Izhar Ul Haq*
>
>
>
> Cell# 009203069072597
> -- 
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/ 
> discussexcel 
>  
> FORUM RULES
>  
> 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 quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> 

Re: $$Excel-Macros$$ Creating Macro

[Paul Schreiner]

Actually Vinay's answer is complete.It's your question that is incomplete.
You asked:Is it possible?
Vinay is correct.  Yes, it is.
Your "statement of intent" is unclear.
You said "I want to create a Macro"  That's pretty clear. Go right ahead, let 
us know how that works out.
then: " cells that beginning with *, that he automatically deleting all that 
cells"
Now THAT's a bit confusing.you want to delete ALL CELLS if one of them begins 
with a "*"??
Technically, we don't "delete" cells.If you tell Excel to delete a cell, it 
really just removes the contents and shift the rest of the cells (either moves 
them up, or to the left).
So, if I were forced to guess, you really just want to check a range of cells 
and delete the contents of any cell that begins with "*".
THAT's fairly easy.simply evaluate the contents of each cell in a range of 
cellsand check the left-most character.
One way would be:
Sub Delete_CellValues()
    Dim Target As Range
    For Each Target In Range("E1:F100")
    If (Left(Target.Value, 1) = "*") Then Target.ClearContents
    Next Target
End Sub
If you actually meant to delete the contents and shift the cells,or even to 
delete an entire row, then you'll need to modify the macro.

Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
 
  From: Mesut Yilmaz 
 To: MS EXCEL AND VBA MACROS  
 Sent: Wednesday, September 9, 2015 10:23 AM
 Subject: Re: $$Excel-Macros$$ Creating Macro
   
Can you explain?

Op woensdag 9 september 2015 10:01:58 UTC+2 schreef Vinay Saraf:
yes
On Wed, Sep 9, 2015 at 1:00 PM, Mesut Yilmaz  wrote:

Hello All,
I want to create a Macro that, cells that beginning with *, that he 
automatically deleting all that cells.. Is that posible? -- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/ discussexcel
 
FORUM RULES
 
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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros...@ googlegroups.com.
To post to this group, send email to excel-...@googlegroups.com.


Visit this group at http://groups.google.com/ group/excel-macros.
For more options, visit https://groups.google.com/d/ optout.




-- 
Thanks & Regards
CA Vinay Saraf
9873697167
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


   

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measur

Re: $$Excel-Macros$$ terms

[Paul Schreiner]

Again, not a problem.The biggest issue you run into when asking for help is 
that YOU know what it is you're looking for, but when you ask a question, you 
must communicate everything that you already know.
That is: you wish to do something with some data.What does the data look 
like?where did it come from?what is the format?What is the sheet name?what do 
you want it to end up looking like?
the big question is: how much of what you already know from looking at your 
data will someone who has never SEEN the data need to know?
If they cannot determine needed information from your question or example, they 
must make assumptions that they, in turn, must communicate back to YOU.
sometimes, the VBA help shows alternatives, or gives you hints to other areas 
that you can look at that answers questions you haven't yet asked!
Just let us know how we can help!(just be ready to get as many clarification 
questions BACK as answers) Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
 
  From: GENIUS 
 To: MS EXCEL AND VBA MACROS  
Cc: schreiner_p...@att.net 
 Sent: Wednesday, September 9, 2015 4:30 AM
 Subject: Re: $$Excel-Macros$$ terms
   


On Tuesday, 8 September 2015 16:47:00 UTC+5, Paul Schreiner wrote:
First of all, learning by yourself is admirable!There are lots tools that help.
The one I use the absolute MOST is the HELP within the VBA editor.
In the upper right of the editor window, you'll see a box that says "Type a 
question for help".
In that box, type: Option Explicit
You'll get a list of search results.
Click the first one: Option Explicit Statement
It explains that:When Option Explicit appears in a module, you must explicitly 
declare all variables using the Dim, Private, Public, ReDim, or Static 
statements. If you attempt to use an undeclared variable name, an error occurs 
at compile time.

So, basically, Option Explicit makes it so that all variables must be declared 
FOR THAT MODULE.Normally, you'd have to manually put "Option Explicit" at the 
beginning of each module.Clicking "Require Variable Declaration" makes VBA put 
it there automatically.
2) What is procedure and sub procedure with example please.
A "procedure" is a general term for what is commonly called VBA "macros".They 
can be Subs (subroutines), Functions and Property types (which is MUCH less 
common).
As for creating a "sub procedure", 
your confusion is probably with the definition of "sub".
It is NOT "subordinate"as if it were:1) Procedure a) Sub-Procedure
It refers to a SUBROUTINE:
As in:
Sub Test   MsgBox "Hello"End Sub
If you need help with the VBA debugger or specific help with a project, let us 
know.
 Paul-- ---
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-- ---
 
  From: Izhar 
 To: excel-...@googlegroups.com 
 Sent: Tuesday, September 8, 2015 12:09 AM
 Subject: $$Excel-Macros$$ terms
   
HI
now a days i'm trying to learn vba by myself during learning I come across with 
these words can anyone explain in details what those words are.


1) why we enable REQUIRE VARIABLE DECLARATION, when we enable it, that shows a 
code i.e OPTION EXPLICIT, what is it why we check the button of REQUIRE 
VARIABLE DECLARATION.
2) what is procedure and sub procedure with example please.





-- 
Izhar Ul Haq



Cell# 009203069072597
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/ discussexcel
 
FORUM RULES
 
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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros...@ googlegroups.com.
To post to this group, send email to excel-...@googlegroups.com.
Visit this group at http://groups.google.com/ group/excel-macros.
For more options, visit https://groups.google.com/d/ optout.





Thank you very much for explaining the r

Re: $$Excel-Macros$$ Creating Macro

[Mesut Yilmaz]

Can you explain?

Op woensdag 9 september 2015 10:01:58 UTC+2 schreef Vinay Saraf:
>
> yes
>
> On Wed, Sep 9, 2015 at 1:00 PM, Mesut Yilmaz  > wrote:
>
>> Hello All,
>>
>> I want to create a Macro that, cells that beginning with *, that he 
>> automatically deleting all that cells.. Is that posible? 
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 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 quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com 
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> -- 
> Thanks & Regards
> CA Vinay Saraf
> 9873697167
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Help Required

[Abhishek Jain]

Noticed that the time mentioned for "seconds" part is differentiated by a
decimal while it should be a colon (like it is done for the hours-minutes
part) so as to enable excel to read it as "time". Once you correct that,
you can simply deduct the down time from up time to get the difference and
set the format of result value as "[hh]:mm:ss" - without quotes.

Please see attached.

HTH

Abhishek

On Wed, Sep 9, 2015 at 3:56 PM, Neeraj Chauhan 
wrote:

> Dear Experts,
>
>
>
> I want total duration time
>
>
>
> *DATETIME_UP*
>
> *DATETIME_DOWN*
>
> *Total Duration Required*
>
> 9/1/2015 04:06.5
>
> 9/1/2015  05:04.1
>
> HRS:MIN:SS
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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 quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


diff time.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ help required to assign number value

[Abhishek Jain]

Assuming that your values are stored in column A from cell 1 to 50, you
could use this formula in cell B1 and drag it down -

=RANK(A1,$A$1:$A$50)

HTH

Abhishek

On Wed, Sep 9, 2015 at 2:22 PM, Nasir Saikh  wrote:

> Hi Experts,
>
> I need a formula to assign number value example is given below where i
> need is if the value is max then assign 4, below that 3, below that 2,
> below that 1
>
>
>  Value   1000 1 100 10
>  required  43   1  2
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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 quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Help Required

[Neeraj Chauhan]

Dear Experts,

 

I want total duration time 

 


DATETIME_UP

DATETIME_DOWN

Total Duration Required


9/1/2015 04:06.5

9/1/2015  05:04.1

HRS:MIN:SS

 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ help required to assign number value

[Nasir Saikh]

Hi Experts,

I need a formula to assign number value example is given below where i need 
is if the value is max then assign 4, below that 3, below that 2, below 
that 1


 Value   1000 1 100 10 
 required  43   1  2 



-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ terms

[GENIUS]

On Tuesday, 8 September 2015 16:47:00 UTC+5, Paul Schreiner wrote:
>
> First of all, learning by yourself is admirable!
> There are lots tools that help.
>
> The one I use the absolute MOST is the HELP within the VBA editor.
>
> In the upper right of the editor window, you'll see a box that says "Type 
> a question for help".
>
> In that box, type: 
> Option Explicit
>
> You'll get a list of search results.
>
> Click the first one: 
> Option Explicit Statement
>
> It explains that:
> *When Option Explicit appears in a module, you must explicitly declare all 
> variables using the Dim, Private, Public, ReDim, or Static statements. If 
> you attempt to use an undeclared variable name, an error occurs at compile 
> time.*
>
>
> So, basically, Option Explicit makes it so that all variables must be 
> declared FOR THAT MODULE.
> Normally, you'd have to manually put "Option Explicit" at the beginning of 
> each module.
> Clicking "Require Variable Declaration" makes VBA put it there 
> automatically.
>
> *2) What is procedure and sub procedure with example please.*
>
> A "procedure" is a general term for what is commonly called VBA "macros".
> They can be Subs (subroutines), Functions and Property types (which is 
> MUCH less common).
>
> As for creating a "sub procedure", 
>
> your confusion is probably with the definition of "sub".
>
> It is NOT "subordinate"
> as if it were:
> 1) Procedure
>  a) Sub-Procedure
>
> It refers to a SUBROUTINE:
>
> As in:
>
> Sub Test
>MsgBox "Hello"
> End Sub
>
> If you need help with the VBA debugger or specific help with a project, 
> let us know.
>
>  
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you 
> can,In all the places you can,At all the times you can,To all the people 
> you can,As long as ever you can.” - John Wesley*
> -
>
> --
> *From:* Izhar >
> *To:* excel-...@googlegroups.com  
> *Sent:* Tuesday, September 8, 2015 12:09 AM
> *Subject:* $$Excel-Macros$$ terms
>
> HI
> now a days i'm trying to learn vba by myself during learning I come across 
> with these words can anyone explain in details what those words are.
>
>
> 1) why we enable REQUIRE VARIABLE DECLARATION, when we enable it, that 
> shows a code i.e OPTION EXPLICIT, what is it why we check the button of 
> REQUIRE VARIABLE DECLARATION.
> 2) what is procedure and sub procedure with example please.
>
>
>
>
>
> -- 
> *Izhar Ul Haq*
>
>
>
> Cell# 009203069072597
> -- 
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 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 quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> --- 
> You received this message because you are subscribed to the Google Groups 
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros...@googlegroups.com .
> To post to this group, send email to excel-...@googlegroups.com 
> .
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>

*Thank you very much for explaining the required, yes you are right there 
are lot of ways of learnng vba for excel but to ask a question from a 
person who already know the term or question may explain more elobrately 
then the searching for the same, because I'm new in this field and when 
I'll read something from any source then it is not like that as someone 
telling me the same.  So once again thank you very much for your help and 
let me further study and if I find something ambiguous then let me ask the 
same with your help.* 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting

Re: $$Excel-Macros$$ Creating Macro

[Vinay Saraf]

yes

On Wed, Sep 9, 2015 at 1:00 PM, Mesut Yilmaz 
wrote:

> Hello All,
>
> I want to create a Macro that, cells that beginning with *, that he
> automatically deleting all that cells.. Is that posible?
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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 quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Thanks & Regards
CA Vinay Saraf
9873697167

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Creating Macro

[Mesut Yilmaz]

Hello All,

I want to create a Macro that, cells that beginning with *, that he 
automatically deleting all that cells.. Is that posible? 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.