Re: $$Excel-Macros$$ conditional formatting for real time stock quotes

[ajjw123]

thanks for the reply .The data is linked to a application which
automatically paste data in sheet1 of the workbook.And I have to link
the data from sheet1 to another worksheets or workbook as i cant
change anything in sheet1.


On Nov 3, 8:36 pm, Sam Mathai Chacko  wrote:
> Here's a simulated refresh to give you the idea of how it can be done. Now,
> my trigger is the click of a button. But in your case, it could be the
> query refresh.
>
> Regards
>
> Sam
>
> On Thu, Nov 3, 2011 at 8:23 PM, Sam Mathai Chacko wrote:
>
>
>
>
>
>
>
>
>
> > For that you'll have to first tell how your sheet gets refreshed? Is it
> > linked to a web query? Normally, you'd want to save the existing values in
> > a second sheet, and make the conditional comparison based on the current
> > value.
>
> > Regards,
>
> > Sam
>
> > On Thu, Nov 3, 2011 at 8:20 PM, ajjw123  wrote:
>
> >> i have a excel sheet in which real time stock quotes gets updated
> >> automatically every second.
> >> I would like to highlight the value as red if the new stock quote is
> >> greater than the previous one.
> >> And highlight the quote as blue if the new stock quote is lesser than
> >> the previous one.
> >> thanks.
>
> >> --
> >> FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in
> >> signatures are prohibited.
>
> >> NOTE  : Don't ever post personal or confidential data in a workbook.
> >> Forum owners and members are not responsible for any loss.
>
> >> --
> >> To post to this group, send email to excel-macros@googlegroups.com
>
> > --
> > Sam Mathai Chacko
>
> --
> Sam Mathai Chacko
>
>  Live Change Track.xlsm
> 25KViewDownload

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel-marco- need u r help -- $unil

[sunil bn]

Thnq very much

On Thu, Nov 3, 2011 at 11:23 PM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:

> Hello Sunil;
>
> Also, you can use SUMIF,
>
> =SUMIF(A2:A11,"<="&TODAY(),B2:B11)
>
> _
> HTH
> Haseeb
>
>  --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

*Regards*
**Sunil B.N
***9035858585

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

RE: $$Excel-Macros$$ formula for diff. in string

[Asa Rossoff]

For a text comparison along the lines of a Diff utility, that highlights
cell character differences in color, see the highlightDifferences() UDF by
Mike Rickson at http://www.mrexcel.com/forum/showthread.php?t=390953

 

Read all the comments to see how it works, and use the version from the last
comment for the final version.

There are also similar UDFs posted on several websites for comparing
comma-delimited lists for items in one but not the other list.

 

For checking whether the strings are the same as each other, note that the
difference between Exact() and A1=B1 is that the former is case-sensitive,
while the latter is not.

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of krishnanm2...@gmail.com
Sent: Thursday, November 03, 2011 8:27 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ formula for diff. in string

 

To make it more simple try A1=B1

Sent on my BlackBerryR from Vodafone

  _  

From: NOORAIN ANSARI  

Sender: excel-macros@googlegroups.com 

Date: Thu, 3 Nov 2011 20:50:01 +0530

To: 

ReplyTo: excel-macros@googlegroups.com 

Subject: Re: $$Excel-Macros$$ formula for diff. in string

 

Dear Ankit,

 

For exact match you can use

=EXACT(A1,B1)


-- 

Thanks & regards,

Noorain Ansari

  http://excelmacroworld.blogspot.com/

  http://noorain-ansari.blogspot.com/

On Thu, Nov 3, 2011 at 12:15 PM, Ankit Agrawal 
wrote:

Hi Expert,

Plz give me any formula for diff in string
 
example-

If cell A1 contain Ashish & B1 contain Ashish 

& we want to diff in A1 & B1 then how we can formulate it

Thanks & Regards,
Ankit




-- 
FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com





-- 
FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and m

Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports February

[Haseeb Avarakkan]

Or, another one;

=INT((WEEKDAY(B1-DAY(B1)+1-6)+EOMONTH(B1,0)-(B1-DAY(B1)+1))/7)

Even if B1 is not the first day of the month, it will work. If you are 
using XL2003 or prior versions, EOMONTH function require Analysis ToolPak 
Addins to be installed & activated.

__
HTH
Haseeb

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports February

[Sam Mathai Chacko]

So to ensure only the correct number of days are added, use

=SUMPRODUCT(--(WEEKDAY(DATE(YEAR(B1),MONTH(B1),ROW(INDIRECT("1:"&DAY(DATE(YEAR(B1),MONTH(B1)+1,0))=6))

Regards,

Sam Mathai Chacko

On Fri, Nov 4, 2011 at 12:48 AM, Paul Schreiner wrote:

> He's using the first day of the month to create a valid date.
> The formula then uses the year and month from THIS date, and uses
> the numbers 1-31
> (from Row($A1:$A31) )
> to generate new date values and then determine the day of the week for
> each day.
>
>
> *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:* dguillett1 
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, November 3, 2011 3:10:22 PM
>
> *Subject:* Re: $$Excel-Macros$$ Formula to count Fridays in a month
> mis-reports February
>
> Your original post said that you would use the FIRST DAY of each month.
>
>
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: DaveO
> Sent: Thursday, November 03, 2011 1:53 PM
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ Formula to count Fridays in a month
> mis-reports February
>
> I didn't see your note, Paul, thanks for your response. I thought the
> equivalent of date(2012,2,30) would return an error and not get
> counted in the SUMPRODUCT. Instead, as you say it gets counted as the
> next day and throws the count off.
>
> -- FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
> -- FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
own

Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports February

[Paul Schreiner]

He's using the first day of the month to create a valid date.
The formula then uses the year and month from THIS date, and uses the numbers 
1-31
(from Row($A1:$A31) )
to generate new date values and then determine the day of the week for each day.
 
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: dguillett1 
To: excel-macros@googlegroups.com
Sent: Thu, November 3, 2011 3:10:22 PM
Subject: Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports 
February

Your original post said that you would use the FIRST DAY of each month.



Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- From: DaveO
Sent: Thursday, November 03, 2011 1:53 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports 
February

I didn't see your note, Paul, thanks for your response. I thought the
equivalent of date(2012,2,30) would return an error and not get
counted in the SUMPRODUCT. Instead, as you say it gets counted as the
next day and throws the count off.

-- FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--

To post to this group, send email to excel-macros@googlegroups.com 
-- FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--

To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports February

[Paul Schreiner]

I thought the same thing. If anything, I figured it would pass an #INVALID 
value 
to Sumproduct.
But I tested it..

I suspect what's happening is that it "normally" takes a date and converts it 
to 
an integer.
then does the calculation.

I think what it's actually doing here is converting the month/year figures to # 
of days (since 1/1/1900)
and adding the day #... 
By doing that, it's really bypassing the date-to-integer conversion altogether.

And therefore, there really IS no error (in the calculation)
 
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: DaveO 
To: MS EXCEL AND VBA MACROS 
Sent: Thu, November 3, 2011 2:53:55 PM
Subject: Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports 
February

I didn't see your note, Paul, thanks for your response. I thought the
equivalent of date(2012,2,30) would return an error and not get
counted in the SUMPRODUCT. Instead, as you say it gets counted as the
next day and throws the count off.

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--

To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports February

[dguillett1]

Your original post said that you would use the FIRST DAY of each month.



Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: DaveO

Sent: Thursday, November 03, 2011 1:53 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Formula to count Fridays in a month 
mis-reports February


I didn't see your note, Paul, thanks for your response. I thought the
equivalent of date(2012,2,30) would return an error and not get
counted in the SUMPRODUCT. Instead, as you say it gets counted as the
next day and throws the count off.

--
FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com 


--
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports February

[DaveO]

I didn't see your note, Paul, thanks for your response. I thought the
equivalent of date(2012,2,30) would return an error and not get
counted in the SUMPRODUCT. Instead, as you say it gets counted as the
next day and throws the count off.

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Determine scope of name range

[dguillett1]

Pls give an example of “scope”

Don Guillett
SalesAid Software
dguille...@gmail.com

From: hanumant shinde 
Sent: Thursday, November 03, 2011 12:28 PM
To: Excel Group 
Subject: $$Excel-Macros$$ Determine scope of name range

Hi Friends,

i need to find out scope of the name range i.e. if the defined name is has a 
scope of worksheet or workbook.

below is my code

sub test
dim namerange as name
for each nameange in thisworkbook.names
a = namerange.name

'here i want to find out th scope of the name range.
lets say 
b = namerange.scope
end sub
how can i achieve this?

please let me know as soon as possible. 

thanks
hanumant
 
-- 
FORUM RULES (925+ 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 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports February

[DaveO]

Thanks, Don and Sam- I appreciate your responses and I'll study them
to understand them fully.

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Determine scope of name range

[Sam Mathai Chacko]

Sub NameInMe()

Dim nm As Name

For Each nm In ThisWorkbook.Names
If nm.Parent.Name = ThisWorkbook.Name Then
MsgBox nm.Name & " is workbook level"
Else
MsgBox nm.Name & " is sheet level"
End If
Next

End Sub

Regards,

Sam Mathai Chacko

On Thu, Nov 3, 2011 at 10:58 PM, hanumant shinde wrote:

> Hi Friends,
>
> i need to find out scope of the name range i.e. if the defined name is has
> a scope of worksheet or workbook.
>
> below is my code
>
> sub test
> dim namerange as name
> for each nameange in thisworkbook.names
> a = namerange.name
>
> 'here i want to find out th scope of the name range.
> lets say
> b = namerange.scope
> end sub
> how can i achieve this?
>
> please let me know as soon as possible.
>
> thanks
> hanumant
>
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports February

[Paul Schreiner]

Since 2/30/2012 is not a valid date, 
it evaluates the DATE(2012,2,30)
as 3/1/2012 instead of 2/30/2012


It would have similar issues with each month with 30 days
(April, June, September, November)
if the first day of the following month were to fall on the day being tallied
(For instance, the number of Thursdays in November, 2011)

It may mean that the formula requires some modification.

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: DaveO 
To: MS EXCEL AND VBA MACROS 
Sent: Thu, November 3, 2011 1:58:26 PM
Subject: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports 
February

I've written this formula to count Fridays in a month, where cell b1
contains a date such as 11/1/2011:
=SUMPRODUCT(--(WEEKDAY(DATE(YEAR(B1),MONTH(B1),ROW($A$1:$A$31)))=6))

This formula works for any month except February. Can anyone suggest a
reason why this happens?

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--

To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports February

[Sam Mathai Chacko]

Just a small modification to your original formula


=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(DATE(YEAR(A1),MONTH(A1),1)&":"&DATE(YEAR(A1),MONTH(A1)+1,0=6))

Regards

Sam Mathai Chacko

On Thu, Nov 3, 2011 at 11:43 PM, dguillett1  wrote:

> try
> =4+(DAY(B$1+34)
>
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: DaveO
> Sent: Thursday, November 03, 2011 12:58 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports
> February
>
>
> I've written this formula to count Fridays in a month, where cell b1
> contains a date such as 11/1/2011:
> =SUMPRODUCT(--(WEEKDAY(DATE(**YEAR(B1),MONTH(B1),ROW($A$1:$**A$31)))=6))
>
> This formula works for any month except February. Can anyone suggest a
> reason why this happens?
>
> --
> FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --**--**
> --**
> To post to this group, send email to excel-macros@googlegroups.com
> --
> FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --**--**
> --**
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports February

[dguillett1]

try
=4+(DAY(B$1+34)-Original Message- 
From: DaveO

Sent: Thursday, November 03, 2011 12:58 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Formula to count Fridays in a month mis-reports 
February


I've written this formula to count Fridays in a month, where cell b1
contains a date such as 11/1/2011:
=SUMPRODUCT(--(WEEKDAY(DATE(YEAR(B1),MONTH(B1),ROW($A$1:$A$31)))=6))

This formula works for any month except February. Can anyone suggest a
reason why this happens?

--
FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com 


--
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Re: Advanced Filter

[Haseeb Avarakkan]

Akhilesh,

Please attach a dummy sheet with your desired result. So the members can 
look on it.

__
Haseeb

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Formula to count Fridays in a month mis-reports February

[DaveO]

I've written this formula to count Fridays in a month, where cell b1
contains a date such as 11/1/2011:
=SUMPRODUCT(--(WEEKDAY(DATE(YEAR(B1),MONTH(B1),ROW($A$1:$A$31)))=6))

This formula works for any month except February. Can anyone suggest a
reason why this happens?

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Excel-marco- need u r help -- $unil

[Haseeb Avarakkan]

Hello Sunil;

Also, you can use SUMIF,

=SUMIF(A2:A11,"<="&TODAY(),B2:B11)

_
HTH
Haseeb

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

[dguillett1]

That's what I get for NOT testing

Sheets("start").Range("h6:i6").Copy Range("f" & ActiveCell.Row)


Sheets("start").Range("h6:l6").Copy  cells(activecell.row,”f”)
end sub



Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Eddie

Sent: Thursday, November 03, 2011 11:46 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

This looks good but gettin a run time error 1004!

On Nov 3, 4:36 pm, "dguillett1"  wrote:

Sub cc()
   Sheets("start").Range("h6:l6").Copy  cells(activecell.row,”f”)
end sub

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko
Sent: Thursday, November 03, 2011 11:18 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

Sub PasteStat()

   Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" & 
Selection.Row)


End Sub

Regards,

Sam Mathai Chacko

On Thu, Nov 3, 2011 at 9:25 PM, Eddie  wrote:

  Sub PasteStat()

 Sheets("start").Select
 Range("h6:l6").Select
 Selection.Copy
 Sheets("Sheet1").Select
 Range("f" & Selection.Row).Select
 ActiveSheet.Paste

  End Sub

  Hi,

  How do I edit the above so that the selected sheet (in this case
  "Sheet1") is the active sheet. I.e. if i was working on Sheet30 the
  cells would be pasted into this sheet rather than Sheet1.

  Thanks in advance.

  Ed.

  --
  FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


  NOTE  : Don't ever post personal or confidential data in a workbook. 
Forum owners and members are not responsible for any loss.


  
---­---
  To post to this group, send email to excel-macros@googlegroups.com

--
Sam Mathai Chacko
--
FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


---­---
To post to this group, send email to excel-macros@googlegroups.com


--
FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com 


--
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

[Eddie]

Thats exactly it. It works great. Many thanks.

On Nov 3, 5:27 pm, Sam Mathai Chacko  wrote:
> So what exactly are you trying to do? Want to copy from start to any of the
> active sheets?
>
> Sub PasteStat()
>
>    Sheets("start").Range("h6:l6").Copy Activesheet.Range("f" &
> Selection.Row)
>
> End Sub
>
> Sam
>
>
>
>
>
> On Thu, Nov 3, 2011 at 10:54 PM, Eddie  wrote:
> > Yes, works great on sheet1 but doesnt work on others...
>
> > On Nov 3, 5:21 pm, Sam Mathai Chacko  wrote:
> > > Did you try this?
>
> > > Sub PasteStat()
>
> > >     Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" &
> > > Selection.Row)
>
> > >   End Sub
>
> > > Sam
>
> > > On Thu, Nov 3, 2011 at 10:16 PM, Eddie 
> > wrote:
> > > > This looks good but gettin a run time error 1004!
>
> > > > On Nov 3, 4:36 pm, "dguillett1"  wrote:
> > > > > Sub cc()
> > > > >    Sheets("start").Range("h6:l6").Copy  cells(activecell.row,”f”)
> > > > > end sub
>
> > > > > Don Guillett
> > > > > SalesAid Software
> > > > > dguille...@gmail.com
>
> > > > > From: Sam Mathai Chacko
> > > > > Sent: Thursday, November 03, 2011 11:18 AM
> > > > > To: excel-macros@googlegroups.com
> > > > > Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into active
> > sheet)
>
> > > > > Sub PasteStat()
>
> > > > >    Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" &
> > > > Selection.Row)
>
> > > > > End Sub
>
> > > > > Regards,
>
> > > > > Sam Mathai Chacko
>
> > > > > On Thu, Nov 3, 2011 at 9:25 PM, Eddie 
> > > > wrote:
>
> > > > >   Sub PasteStat()
>
> > > > >      Sheets("start").Select
> > > > >      Range("h6:l6").Select
> > > > >      Selection.Copy
> > > > >      Sheets("Sheet1").Select
> > > > >      Range("f" & Selection.Row).Select
> > > > >      ActiveSheet.Paste
>
> > > > >   End Sub
>
> > > > >   Hi,
>
> > > > >   How do I edit the above so that the selected sheet (in this case
> > > > >   "Sheet1") is the active sheet. I.e. if i was working on Sheet30 the
> > > > >   cells would be pasted into this sheet rather than Sheet1.
>
> > > > >   Thanks in advance.
>
> > > > >   Ed.
>
> > > > >   --
> > > > >   FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this
> > forum
> > > > in signatures are prohibited.
>
> > > > >   NOTE  : Don't ever post personal or confidential data in a
> > workbook.
> > > > Forum owners and members are not responsible for any loss.
>
> > ---­­­---
> > > > >   To post to this group, send email to excel-macros@googlegroups.com
>
> > > > > --
> > > > > Sam Mathai Chacko
> > > > > --
> > > > > FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum
> > in
> > > > signatures are prohibited.
>
> > > > > NOTE : Don't ever post personal or confidential data in a workbook.
> > > > Forum owners and members are not responsible for any loss.
>
> > ---­­­---
> > > > > To post to this group, send email to excel-macros@googlegroups.com
>
> > > > --
> > > > FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum
> > in
> > > > signatures are prohibited.
>
> > > > NOTE  : Don't ever post personal or confidential data in a workbook.
> > Forum
> > > > owners and members are not responsible for any loss.
>
> > -

$$Excel-Macros$$ Determine scope of name range

[hanumant shinde]

Hi Friends,
 
i need to find out scope of the name range i.e. if the defined name is has a 
scope of worksheet or workbook.
 
below is my code
 
sub test
dim namerange as name
for each nameange in thisworkbook.names
a = namerange.name
 
'here i want to find out th scope of the name range.
lets say 
b = namerange.scope
end sub
how can i achieve this?
 
please let me know as soon as possible. 
 
thanks
hanumant

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

[Sam Mathai Chacko]

So what exactly are you trying to do? Want to copy from start to any of the
active sheets?

Sub PasteStat()

   Sheets("start").Range("h6:l6").Copy Activesheet.Range("f" &
Selection.Row)

End Sub

Sam

On Thu, Nov 3, 2011 at 10:54 PM, Eddie  wrote:

> Yes, works great on sheet1 but doesnt work on others...
>
> On Nov 3, 5:21 pm, Sam Mathai Chacko  wrote:
> > Did you try this?
> >
> > Sub PasteStat()
> >
> > Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" &
> > Selection.Row)
> >
> >   End Sub
> >
> > Sam
> >
> >
> >
> >
> >
> > On Thu, Nov 3, 2011 at 10:16 PM, Eddie 
> wrote:
> > > This looks good but gettin a run time error 1004!
> >
> > > On Nov 3, 4:36 pm, "dguillett1"  wrote:
> > > > Sub cc()
> > > >Sheets("start").Range("h6:l6").Copy  cells(activecell.row,”f”)
> > > > end sub
> >
> > > > Don Guillett
> > > > SalesAid Software
> > > > dguille...@gmail.com
> >
> > > > From: Sam Mathai Chacko
> > > > Sent: Thursday, November 03, 2011 11:18 AM
> > > > To: excel-macros@googlegroups.com
> > > > Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into active
> sheet)
> >
> > > > Sub PasteStat()
> >
> > > >Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" &
> > > Selection.Row)
> >
> > > > End Sub
> >
> > > > Regards,
> >
> > > > Sam Mathai Chacko
> >
> > > > On Thu, Nov 3, 2011 at 9:25 PM, Eddie 
> > > wrote:
> >
> > > >   Sub PasteStat()
> >
> > > >  Sheets("start").Select
> > > >  Range("h6:l6").Select
> > > >  Selection.Copy
> > > >  Sheets("Sheet1").Select
> > > >  Range("f" & Selection.Row).Select
> > > >  ActiveSheet.Paste
> >
> > > >   End Sub
> >
> > > >   Hi,
> >
> > > >   How do I edit the above so that the selected sheet (in this case
> > > >   "Sheet1") is the active sheet. I.e. if i was working on Sheet30 the
> > > >   cells would be pasted into this sheet rather than Sheet1.
> >
> > > >   Thanks in advance.
> >
> > > >   Ed.
> >
> > > >   --
> > > >   FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this
> forum
> > > in signatures are prohibited.
> >
> > > >   NOTE  : Don't ever post personal or confidential data in a
> workbook.
> > > Forum owners and members are not responsible for any loss.
> >
> > >
> ---­­---
> > > >   To post to this group, send email to excel-macros@googlegroups.com
> >
> > > > --
> > > > Sam Mathai Chacko
> > > > --
> > > > FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum
> in
> > > signatures are prohibited.
> >
> > > > NOTE : Don't ever post personal or confidential data in a workbook.
> > > Forum owners and members are not responsible for any loss.
> >
> > >
> ---­­---
> > > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > --
> > > FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum
> in
> > > signatures are prohibited.
> >
> > > NOTE  : Don't ever post personal or confidential data in a workbook.
> Forum
> > > owners and members are not responsible for any loss.
> >
> > >
> ---­---
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > --
> > Sam Mathai Chacko- Hide quoted text 

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

[Eddie]

Yes, works great on sheet1 but doesnt work on others...

On Nov 3, 5:21 pm, Sam Mathai Chacko  wrote:
> Did you try this?
>
> Sub PasteStat()
>
>     Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" &
> Selection.Row)
>
>   End Sub
>
> Sam
>
>
>
>
>
> On Thu, Nov 3, 2011 at 10:16 PM, Eddie  wrote:
> > This looks good but gettin a run time error 1004!
>
> > On Nov 3, 4:36 pm, "dguillett1"  wrote:
> > > Sub cc()
> > >    Sheets("start").Range("h6:l6").Copy  cells(activecell.row,”f”)
> > > end sub
>
> > > Don Guillett
> > > SalesAid Software
> > > dguille...@gmail.com
>
> > > From: Sam Mathai Chacko
> > > Sent: Thursday, November 03, 2011 11:18 AM
> > > To: excel-macros@googlegroups.com
> > > Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)
>
> > > Sub PasteStat()
>
> > >    Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" &
> > Selection.Row)
>
> > > End Sub
>
> > > Regards,
>
> > > Sam Mathai Chacko
>
> > > On Thu, Nov 3, 2011 at 9:25 PM, Eddie 
> > wrote:
>
> > >   Sub PasteStat()
>
> > >      Sheets("start").Select
> > >      Range("h6:l6").Select
> > >      Selection.Copy
> > >      Sheets("Sheet1").Select
> > >      Range("f" & Selection.Row).Select
> > >      ActiveSheet.Paste
>
> > >   End Sub
>
> > >   Hi,
>
> > >   How do I edit the above so that the selected sheet (in this case
> > >   "Sheet1") is the active sheet. I.e. if i was working on Sheet30 the
> > >   cells would be pasted into this sheet rather than Sheet1.
>
> > >   Thanks in advance.
>
> > >   Ed.
>
> > >   --
> > >   FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum
> > in signatures are prohibited.
>
> > >   NOTE  : Don't ever post personal or confidential data in a workbook.
> > Forum owners and members are not responsible for any loss.
>
> > ---­­---
> > >   To post to this group, send email to excel-macros@googlegroups.com
>
> > > --
> > > Sam Mathai Chacko
> > > --
> > > FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
>
> > > NOTE : Don't ever post personal or confidential data in a workbook.
> > Forum owners and members are not responsible for any loss.
>
> > ---­­---
> > > To post to this group, send email to excel-macros@googlegroups.com
>
> > --
> > FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
>
> > NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
>
> > ---­---
> > To post to this group, send email to excel-macros@googlegroups.com
>
> --
> Sam Mathai Chacko- Hide quoted text -
>
> - Show quoted text -

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
si

Re: $$Excel-Macros$$ Help

[Sam Mathai Chacko]

So did you check my post?

Sam

On Thu, Nov 3, 2011 at 10:03 PM, Mahreen Ellahi wrote:

> I want the user either to have score or NA. When all boxes are marked by
> NA or score, all scores should be added for final score.
>
>
> On Thu, Nov 3, 2011 at 9:30 PM, dguillett1  wrote:
>
>>   What do you want when one or the other is NA and how is the cell
>> populated with NA
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Mahreen Ellahi 
>> *Sent:* Thursday, November 03, 2011 10:33 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Help
>>
>> I ve to add points scored in each table. When the points are NA, total is
>> not possible. Plz see attached file.
>>
>> Mahreen
>>
>> On Thu, Nov 3, 2011 at 4:49 AM, Haseeb Avarakkan <
>> haseeb.avarak...@gmail.com> wrote:
>>
>>> Mahreen,
>>>
>>> If you have multiple ratio values define a name for them each, like
>>> Table1, Table2 & choose which table to use.
>>>
>>> See the attached.
>>>
>>>
>>> 
>>> HTH
>>> Haseeb
>>> --
>>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>> --
>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (925+ 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 
quick attention or may not be answered.

2) Don't post

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

[Sam Mathai Chacko]

Did you try this?

Sub PasteStat()

Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" &
Selection.Row)

  End Sub

Sam

On Thu, Nov 3, 2011 at 10:16 PM, Eddie  wrote:

> This looks good but gettin a run time error 1004!
>
> On Nov 3, 4:36 pm, "dguillett1"  wrote:
> > Sub cc()
> >Sheets("start").Range("h6:l6").Copy  cells(activecell.row,”f”)
> > end sub
> >
> > Don Guillett
> > SalesAid Software
> > dguille...@gmail.com
> >
> > From: Sam Mathai Chacko
> > Sent: Thursday, November 03, 2011 11:18 AM
> > To: excel-macros@googlegroups.com
> > Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)
> >
> > Sub PasteStat()
> >
> >Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" &
> Selection.Row)
> >
> > End Sub
> >
> > Regards,
> >
> > Sam Mathai Chacko
> >
> > On Thu, Nov 3, 2011 at 9:25 PM, Eddie 
> wrote:
> >
> >   Sub PasteStat()
> >
> >  Sheets("start").Select
> >  Range("h6:l6").Select
> >  Selection.Copy
> >  Sheets("Sheet1").Select
> >  Range("f" & Selection.Row).Select
> >  ActiveSheet.Paste
> >
> >   End Sub
> >
> >   Hi,
> >
> >   How do I edit the above so that the selected sheet (in this case
> >   "Sheet1") is the active sheet. I.e. if i was working on Sheet30 the
> >   cells would be pasted into this sheet rather than Sheet1.
> >
> >   Thanks in advance.
> >
> >   Ed.
> >
> >   --
> >   FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
> >
> >   NOTE  : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
> >
> >
> ---­---
> >   To post to this group, send email to excel-macros@googlegroups.com
> >
> > --
> > Sam Mathai Chacko
> > --
> > FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
> >
> > NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
> >
> >
> ---­---
> > To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To pos

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

[Eddie]

This looks good but gettin a run time error 1004!

On Nov 3, 4:36 pm, "dguillett1"  wrote:
> Sub cc()
>    Sheets("start").Range("h6:l6").Copy  cells(activecell.row,”f”)
> end sub
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Sam Mathai Chacko
> Sent: Thursday, November 03, 2011 11:18 AM
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)
>
> Sub PasteStat()
>
>    Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" & 
> Selection.Row)
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko
>
> On Thu, Nov 3, 2011 at 9:25 PM, Eddie  wrote:
>
>   Sub PasteStat()
>
>      Sheets("start").Select
>      Range("h6:l6").Select
>      Selection.Copy
>      Sheets("Sheet1").Select
>      Range("f" & Selection.Row).Select
>      ActiveSheet.Paste
>
>   End Sub
>
>   Hi,
>
>   How do I edit the above so that the selected sheet (in this case
>   "Sheet1") is the active sheet. I.e. if i was working on Sheet30 the
>   cells would be pasted into this sheet rather than Sheet1.
>
>   Thanks in advance.
>
>   Ed.
>
>   --
>   FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited.
>
>   NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
>
>   
> ---­---
>   To post to this group, send email to excel-macros@googlegroups.com
>
> --
> Sam Mathai Chacko
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
>
> ---­---
> To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

[Eddie]

Thanks,

However, can you automate this so I dont have to edit the sheet number
everytime i use a differnt sheet?

On Nov 3, 4:17 pm, ashish koul  wrote:
> replace sheet1 with ur  Sheet30 in the ur code like
>
> Sheets("Sheet30").Select
>
>
>
>
>
> On Thu, Nov 3, 2011 at 9:25 PM, Eddie  wrote:
>
> > Sub PasteStat()
>
> >    Sheets("start").Select
> >    Range("h6:l6").Select
> >    Selection.Copy
> >    Sheets("Sheet1").Select
> >    Range("f" & Selection.Row).Select
> >    ActiveSheet.Paste
>
> > End Sub
>
> > Hi,
>
> > How do I edit the above so that the selected sheet (in this case
> > "Sheet1") is the active sheet. I.e. if i was working on Sheet30 the
> > cells would be pasted into this sheet rather than Sheet1.
>
> > Thanks in advance.
>
> > Ed.
>
> > --
> > FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
>
> > NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
>
> > ---­---
> > To post to this group, send email to excel-macros@googlegroups.com
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
>
> P Before printing, think about the environment.- Hide quoted text -
>
> - Show quoted text -

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Help

[Mahreen Ellahi]

I want the user either to have score or NA. When all boxes are marked by NA
or score, all scores should be added for final score.

On Thu, Nov 3, 2011 at 9:30 PM, dguillett1  wrote:

>   What do you want when one or the other is NA and how is the cell
> populated with NA
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Mahreen Ellahi 
> *Sent:* Thursday, November 03, 2011 10:33 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help
>
> I ve to add points scored in each table. When the points are NA, total is
> not possible. Plz see attached file.
>
> Mahreen
>
> On Thu, Nov 3, 2011 at 4:49 AM, Haseeb Avarakkan <
> haseeb.avarak...@gmail.com> wrote:
>
>> Mahreen,
>>
>> If you have multiple ratio values define a name for them each, like
>> Table1, Table2 & choose which table to use.
>>
>> See the attached.
>>
>>
>> 
>> HTH
>> Haseeb
>> --
>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Help

[Sam Mathai Chacko]

=N(E8)+N(K8)

Score=IF(ISNUMBER(Sheet1!$E$2),(IF(Sheet1!$E$2<=2,3,IF(Sheet1!$E$2<=3,1,IF(Sheet1!$E$2<=4,0,IF(Sheet1!$E$2>4,-3,0),0)

Score1=IF(ISNUMBER(Sheet1!$J$2),(IF(Sheet1!$J$2<=0.5,-2,IF(Sheet1!$J$2<=0.75,0,IF(Sheet1!$J$2<=1,1,IF(Sheet1!$J$2>1,2,0),0)

Regards,

Sam Mathai Chacko
On Thu, Nov 3, 2011 at 10:00 PM, dguillett1  wrote:

>   What do you want when one or the other is NA and how is the cell
> populated with NA
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Mahreen Ellahi 
> *Sent:* Thursday, November 03, 2011 10:33 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help
>
> I ve to add points scored in each table. When the points are NA, total is
> not possible. Plz see attached file.
>
> Mahreen
>
> On Thu, Nov 3, 2011 at 4:49 AM, Haseeb Avarakkan <
> haseeb.avarak...@gmail.com> wrote:
>
>> Mahreen,
>>
>> If you have multiple ratio values define a name for them each, like
>> Table1, Table2 & choose which table to use.
>>
>> See the attached.
>>
>>
>> 
>> HTH
>> Haseeb
>> --
>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Formula In Validation List(3).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

[dguillett1]

Sub cc()
   Sheets("start").Range("h6:l6").Copy  cells(activecell.row,”f”)
end sub

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko 
Sent: Thursday, November 03, 2011 11:18 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

Sub PasteStat()

   Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" & 
Selection.Row)

End Sub

Regards,

Sam Mathai Chacko


On Thu, Nov 3, 2011 at 9:25 PM, Eddie  wrote:


  Sub PasteStat()

 Sheets("start").Select
 Range("h6:l6").Select
 Selection.Copy
 Sheets("Sheet1").Select
 Range("f" & Selection.Row).Select
 ActiveSheet.Paste

  End Sub

  Hi,

  How do I edit the above so that the selected sheet (in this case
  "Sheet1") is the active sheet. I.e. if i was working on Sheet30 the
  cells would be pasted into this sheet rather than Sheet1.

  Thanks in advance.

  Ed.

  --
  FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.

  NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

  
--
  To post to this group, send email to excel-macros@googlegroups.com




-- 
Sam Mathai Chacko
-- 
FORUM RULES (925+ 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 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Help

[dguillett1]

What do you want when one or the other is NA and how is the cell populated with 
NA

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Mahreen Ellahi 
Sent: Thursday, November 03, 2011 10:33 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Help

I ve to add points scored in each table. When the points are NA, total is not 
possible. Plz see attached file.

Mahreen


On Thu, Nov 3, 2011 at 4:49 AM, Haseeb Avarakkan  
wrote:

  Mahreen,

  If you have multiple ratio values define a name for them each, like Table1, 
Table2 & choose which table to use.

  See the attached. 


  
  HTH
  Haseeb
  -- 
  FORUM RULES (925+ 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 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com


-- 
FORUM RULES (925+ 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 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ INSERT THE ROW

[dguillett1]

Selections could be removed.

Don Guillett
SalesAid Software
dguille...@gmail.com

From: NOORAIN ANSARI 
Sent: Thursday, November 03, 2011 10:49 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ INSERT THE ROW

Dear Jai,

Please use below code as per your requirement.

Sub InsertSpecificRows()
Dim InsQuan As Integer
On Error Resume Next
InsQuan = InputBox("Enter number of rows to insert", "Your Call")
If InsQuan <= 0 Then
MsgBox "Invalid number entered", vbCritical, "Stop!"
Exit Sub
End If
Application.ScreenUpdating = False
Do Until Selection.Value = ""
ActiveCell.Offset(1, 0).Range("A1:A" & InsQuan).Select
Selection.Insert Shift:=xlDown
ActiveCell.Offset(InsQuan, 0).Select
Loop
[A1].Select
Application.ScreenUpdating = True
End Sub


-- 

Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
On Thu, Nov 3, 2011 at 3:50 PM, Jai  wrote:

  HOW CAN INSERT THE PLEASE GIVE THE VBA CODE OR FORMULA -- 
  FORUM RULES (925+ 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 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com





-- 
FORUM RULES (925+ 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 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

[Sam Mathai Chacko]

Sub PasteStat()

   Sheets("start").Range("h6:l6").Copy Sheets("Sheet1").Range("f" &
Selection.Row)

End Sub

Regards,

Sam Mathai Chacko

On Thu, Nov 3, 2011 at 9:25 PM, Eddie  wrote:

>
> Sub PasteStat()
>
>Sheets("start").Select
>Range("h6:l6").Select
>Selection.Copy
>Sheets("Sheet1").Select
>Range("f" & Selection.Row).Select
>ActiveSheet.Paste
>
> End Sub
>
> Hi,
>
> How do I edit the above so that the selected sheet (in this case
> "Sheet1") is the active sheet. I.e. if i was working on Sheet30 the
> cells would be pasted into this sheet rather than Sheet1.
>
> Thanks in advance.
>
> Ed.
>
> --
> FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Copy and Paste Macro (into active sheet)

[ashish koul]

replace sheet1 with ur  Sheet30 in the ur code like


Sheets("Sheet30").Select


On Thu, Nov 3, 2011 at 9:25 PM, Eddie  wrote:

>
> Sub PasteStat()
>
>Sheets("start").Select
>Range("h6:l6").Select
>Selection.Copy
>Sheets("Sheet1").Select
>Range("f" & Selection.Row).Select
>ActiveSheet.Paste
>
> End Sub
>
> Hi,
>
> How do I edit the above so that the selected sheet (in this case
> "Sheet1") is the active sheet. I.e. if i was working on Sheet30 the
> cells would be pasted into this sheet rather than Sheet1.
>
> Thanks in advance.
>
> Ed.
>
> --
> FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Copy and Paste Macro (into active sheet)

[Eddie]

Sub PasteStat()

Sheets("start").Select
Range("h6:l6").Select
Selection.Copy
Sheets("Sheet1").Select
Range("f" & Selection.Row).Select
ActiveSheet.Paste

End Sub

Hi,

How do I edit the above so that the selected sheet (in this case
"Sheet1") is the active sheet. I.e. if i was working on Sheet30 the
cells would be pasted into this sheet rather than Sheet1.

Thanks in advance.

Ed.

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Help

[Mahreen Ellahi]

I ve to add points scored in each table. When the points are NA, total is
not possible. Plz see attached file.

Mahreen

On Thu, Nov 3, 2011 at 4:49 AM, Haseeb Avarakkan  wrote:

> Mahreen,
>
> If you have multiple ratio values define a name for them each, like
> Table1, Table2 & choose which table to use.
>
> See the attached.
>
>
> 
> HTH
> Haseeb
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Formula In Validation List.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ formula for diff. in string

[krishnanm2006]

To make it more simple try A1=B1


Sent on my BlackBerryŽ from Vodafone

-Original Message-
From: NOORAIN ANSARI 
Sender: excel-macros@googlegroups.com
Date: Thu, 3 Nov 2011 20:50:01 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ formula for diff. in string

Dear Ankit,

For exact match you can use
=EXACT(A1,B1)


-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Thu, Nov 3, 2011 at 12:15 PM, Ankit Agrawal
wrote:

> Hi Expert,
>
> Plz give me any formula for diff in string
>
> example-
>
> If cell A1 contain Ashish & B1 contain Ashish
>
> & we want to diff in A1 & B1 then how we can formulate it
>
> Thanks & Regards,
> Ankit
>
>
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ INSERT THE ROW

[NOORAIN ANSARI]

Dear Jai,

Please use below code as per your requirement.

*Sub InsertSpecificRows()
Dim InsQuan As Integer
On Error Resume Next
InsQuan = InputBox("Enter number of rows to insert", "Your Call")
If InsQuan <= 0 Then
MsgBox "Invalid number entered", vbCritical, "Stop!"
Exit Sub
End If
Application.ScreenUpdating = False
Do Until Selection.Value = ""
ActiveCell.Offset(1, 0).Range("A1:A" & InsQuan).Select
Selection.Insert Shift:=xlDown
ActiveCell.Offset(InsQuan, 0).Select
Loop
[A1].Select
Application.ScreenUpdating = True
End Sub
*

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Thu, Nov 3, 2011 at 3:50 PM, Jai  wrote:

> HOW CAN INSERT THE PLEASE GIVE THE VBA CODE OR FORMULA
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ conditional formatting for real time stock quotes

[Sam Mathai Chacko]

Here's a simulated refresh to give you the idea of how it can be done. Now,
my trigger is the click of a button. But in your case, it could be the
query refresh.

Regards

Sam

On Thu, Nov 3, 2011 at 8:23 PM, Sam Mathai Chacko wrote:

> For that you'll have to first tell how your sheet gets refreshed? Is it
> linked to a web query? Normally, you'd want to save the existing values in
> a second sheet, and make the conditional comparison based on the current
> value.
>
> Regards,
>
> Sam
>
>
> On Thu, Nov 3, 2011 at 8:20 PM, ajjw123  wrote:
>
>> i have a excel sheet in which real time stock quotes gets updated
>> automatically every second.
>> I would like to highlight the value as red if the new stock quote is
>> greater than the previous one.
>> And highlight the quote as blue if the new stock quote is lesser than
>> the previous one.
>> thanks.
>>
>> --
>> FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Live Change Track.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ formula for diff. in string

[NOORAIN ANSARI]

Dear Ankit,

For exact match you can use
=EXACT(A1,B1)


-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Thu, Nov 3, 2011 at 12:15 PM, Ankit Agrawal
wrote:

> Hi Expert,
>
> Plz give me any formula for diff in string
>
> example-
>
> If cell A1 contain Ashish & B1 contain Ashish
>
> & we want to diff in A1 & B1 then how we can formulate it
>
> Thanks & Regards,
> Ankit
>
>
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ formula for diff. in string

[Bé Trần Văn]

2011/11/3 ashish koul 

> check the attachment
>
>
> On Thu, Nov 3, 2011 at 6:12 PM, Ankit Agrawal 
> wrote:
>
>> HI,
>>
>> If both string are same then 1 or anything else like true otherwise false
>> o anything else/
>>
>> Regards,
>> Ankit
>>
>>
>> On Thu, Nov 3, 2011 at 5:56 PM, dguillett1  wrote:
>>
>>>   If?? I understand your question then
>>> =if(a1<>b1,”diff”,””)
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Ankit Agrawal 
>>> *Sent:* Thursday, November 03, 2011 1:45 AM
>>> *To:* excel-macros 
>>> *Subject:* $$Excel-Macros$$ formula for diff. in string
>>>
>>>   Hi Expert,
>>>
>>> Plz give me any formula for diff in string
>>>
>>> example-
>>>
>>> If cell A1 contain Ashish & B1 contain Ashish
>>>
>>> & we want to diff in A1 & B1 then how we can formulate it
>>>
>>> Thanks & Regards,
>>> Ankit
>>>
>>>
>>>
>>> --
>>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> --
>>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>> --
>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
>
>
> P Before printing, think about the environment.
>
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

*You** **can use the** **following function:***

example: If cell A1 contain Ashish & B1 contain Ashish

= EXACT (A1, B1)

Result is TRUE



If cell A1 contain Ashish & B1 contain Ashis

= EXACT (A1, B1)

Result is FALSE

-- 
FORUM RULES (925+ members already BANNED for violation)

1) Use concise, accurate th

Re: $$Excel-Macros$$ conditional formatting for real time stock quotes

[Sam Mathai Chacko]

For that you'll have to first tell how your sheet gets refreshed? Is it
linked to a web query? Normally, you'd want to save the existing values in
a second sheet, and make the conditional comparison based on the current
value.

Regards,

Sam

On Thu, Nov 3, 2011 at 8:20 PM, ajjw123  wrote:

> i have a excel sheet in which real time stock quotes gets updated
> automatically every second.
> I would like to highlight the value as red if the new stock quote is
> greater than the previous one.
> And highlight the quote as blue if the new stock quote is lesser than
> the previous one.
> thanks.
>
> --
> FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ conditional formatting for real time stock quotes

[ajjw123]

i have a excel sheet in which real time stock quotes gets updated
automatically every second.
I would like to highlight the value as red if the new stock quote is
greater than the previous one.
And highlight the quote as blue if the new stock quote is lesser than
the previous one.
thanks.

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need to copy of 1st sheet of every workbook in a single work book

[chhajersandeep]

Thanks sir.

Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone

-Original Message-
From: ashish koul 
Sender: excel-macros@googlegroups.com
Date: Thu, 3 Nov 2011 13:16:56 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need to copy of 1st sheet of every workbook in a
 single work book

Sub copy_first_sheet_from_different_workbooks_to_single()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Dim fld As Object, fil As Object
Dim ask As Workbook, ask2 As Workbook
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "Choose the folder"
.InitialFileName = "c:\"
.Show
End With
fldpath =
Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) & "\"
Set fso = CreateObject("scripting.filesystemobject")
Set fld = fso.getfolder(fldpath)
Set ask = Workbooks.Add
For Each fil In fld.Files
If UCase(Right(fil.Path, 4)) = UCase(".xls") Or UCase(Right(fil.Path, 5)) =
UCase(".xlsx") Then
Set ask2 = Workbooks.Open(fil.Path)
ask2.Sheets(1).UsedRange.Copy
ask.Activate
ask.Sheets.Add after:=Sheets(Sheets.Count)
ActiveSheet.Range("a1").Select
Selection.PasteSpecial xlValues
ask2.Close
End If
Next fil
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub

On Thu, Nov 3, 2011 at 1:06 PM,  wrote:

> **
> My files are saved in .xls format. But I am working in .xlxs.
>
>
> Sandeep Chhajer.
> Sent on my BlackBerryŽ from Vodafone
> --
> *From: * ashish koul 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Thu, 3 Nov 2011 13:04:02 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Need to copy of 1st sheet of every
> workbook in a single work book
>
> in which format ur files are saved  .xls or xlsx
>
>
>
> On Thu, Nov 3, 2011 at 11:56 AM, sandeep chhajer  > wrote:
>
>> Dear Ashish,
>>
>> I have copied it but when i am running the code it showing error msg pls
>> help.
>>
>> On 3 November 2011 10:53, ashish koul  wrote:
>>
>>> Sub copy_first_sheet_from_different_workbooks_to_single()
>>> Application.DisplayAlerts = False
>>> Application.ScreenUpdating = False
>>>
>>> Dim fld As Object, fil As Object
>>> Dim ask As Workbook, ask2 As Workbook
>>>
>>> With Application.FileDialog(msoFileDialogFolderPicker)
>>> .Title = "Choose the folder"
>>> .InitialFileName = "c:\"
>>> .Show
>>> End With
>>> fldpath =
>>> Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) & "\"
>>> Set fso = CreateObject("scripting.filesystemobject")
>>>
>>> Set fld = fso.getfolder(fldpath)
>>>
>>> Set ask = Workbooks.Add
>>>
>>> For Each fil In fld.Files
>>> If UCase(Right(fil.Path, 4)) = UCase(".xls") Or UCase(Right(fil.Path,
>>> 5)) = UCase(".xlsx") Then
>>> Set ask2 = Workbooks.Open(fil.Path)
>>> ask2.Sheets(1).Copy After:=ask.Sheets(Sheets.Count)
>>> ask2.Close
>>>
>>> End If
>>> Next fil
>>>
>>> Application.DisplayAlerts = True
>>> Application.ScreenUpdating = True
>>> End Sub
>>>
>>> On Wed, Nov 2, 2011 at 3:43 PM, mrinal saha  wrote:
>>>
 Hi Sandeep,

 Save this attachment in the folder where you have all the workbooks and
 try to run the macro (Button) on page 1 of this file.

 Hope this helps,

 Mrinal

  On Wed, Nov 2, 2011 at 2:08 PM,  wrote:

> Dear all,
>
> I have many work book in a single folder. I need a macro which if I
> run will copy the 1st sheet of every workbook in a single workbook (though
> as separate sheet).
>
> Like if I have 2 workbook viz WB1 and WB2 then I want the 1st
> worksheet of WB1 as 1st worksheet in a new workbook (say WB3) and again 
> 1st
> worksheet of WB2 as 2nd worksheet of WB3.
>
>
> Thanks in advance.
> Sandeep Chhajer.
> Sent on my BlackBerryŽ from Vodafone
>
> --
> FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

 --
 FORUM RULES (925+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Co

Re: $$Excel-Macros$$ formula for diff. in string

[ashish koul]

check the attachment

On Thu, Nov 3, 2011 at 6:12 PM, Ankit Agrawal wrote:

> HI,
>
> If both string are same then 1 or anything else like true otherwise false
> o anything else/
>
> Regards,
> Ankit
>
>
> On Thu, Nov 3, 2011 at 5:56 PM, dguillett1  wrote:
>
>>   If?? I understand your question then
>> =if(a1<>b1,”diff”,””)
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Ankit Agrawal 
>> *Sent:* Thursday, November 03, 2011 1:45 AM
>> *To:* excel-macros 
>> *Subject:* $$Excel-Macros$$ formula for diff. in string
>>
>> Hi Expert,
>>
>> Plz give me any formula for diff in string
>>
>> example-
>>
>> If cell A1 contain Ashish & B1 contain Ashish
>>
>> & we want to diff in A1 & B1 then how we can formulate it
>>
>> Thanks & Regards,
>> Ankit
>>
>>
>>
>> --
>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


ankit.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Excel-marco- need u r help -- $unil

[dguillett1]

Please read the rules at the bottom about subject lines and “nee ur help:
This formula will do it
=SUM(B2:OFFSET(A2,MATCH(TODAY(),A:A)-2,1,1))

Don Guillett
SalesAid Software
dguille...@gmail.com

From: sunil bn 
Sent: Thursday, November 03, 2011 8:13 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Excel-marco- need u r help -- $unil

Hi Expert,

I Need the formula here to calculate from 1st of Nov to current day on daily 
basis automatically. attached file your reference.

-- 

*Regards*
**Sunil B.N
***9035858585


-- 
FORUM RULES (925+ 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 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Excel-marco- need u r help -- $unil

[sunil bn]

Hi Expert,

I Need the formula here to calculate from 1st of Nov to current day on
daily basis automatically. attached file your reference.

-- 

*Regards*
**Sunil B.N
***9035858585

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Book11.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ INSERT THE ROW

[dguillett1]

Save your file as .xls or .xlsM and run this
Sub inserttworows()
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
Rows(i).Resize(2).Insert
'MsgBox i
Next i
End Sub

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Jai 
Sent: Thursday, November 03, 2011 5:20 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ INSERT THE ROW

HOW CAN INSERT THE PLEASE GIVE THE VBA CODE OR FORMULA -- 
FORUM RULES (925+ 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 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ formula for diff. in string

[Ankit Agrawal]

HI,

If both string are same then 1 or anything else like true otherwise false o
anything else/

Regards,
Ankit

On Thu, Nov 3, 2011 at 5:56 PM, dguillett1  wrote:

>   If?? I understand your question then
> =if(a1<>b1,”diff”,””)
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Ankit Agrawal 
> *Sent:* Thursday, November 03, 2011 1:45 AM
> *To:* excel-macros 
> *Subject:* $$Excel-Macros$$ formula for diff. in string
>
> Hi Expert,
>
> Plz give me any formula for diff in string
>
> example-
>
> If cell A1 contain Ashish & B1 contain Ashish
>
> & we want to diff in A1 & B1 then how we can formulate it
>
> Thanks & Regards,
> Ankit
>
>
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ formula for diff. in string

[dguillett1]

If?? I understand your question then
=if(a1<>b1,”diff”,””)

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Ankit Agrawal 
Sent: Thursday, November 03, 2011 1:45 AM
To: excel-macros 
Subject: $$Excel-Macros$$ formula for diff. in string

Hi Expert,

Plz give me any formula for diff in string
 
example-

If cell A1 contain Ashish & B1 contain Ashish 

& we want to diff in A1 & B1 then how we can formulate it

Thanks & Regards,
Ankit

  

 
 
-- 
FORUM RULES (925+ 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 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Time Calculation From Two Different Formats

[John A. Smith]

Sam,

Thank you for that, it saves a column.

John

On Wed, Nov 2, 2011 at 9:25 PM, Sam Mathai Chacko wrote:

> If you only want the finish time without splitting it in to Date and Time,
> you could also use
>
> =LEFT(TRIM(A23),10)+TEXT(RIGHT(TRIM(A23),4),"00\:00")+(B23/(60*24)) in
> mm/dd/ hh:mm format
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Thu, Nov 3, 2011 at 5:52 AM, Haseeb Avarakkan <
> haseeb.avarak...@gmail.com> wrote:
>
>> Hello John,
>>
>> If the Arrival Date & Time is "09/08/2011 2310" & Length is 343 (Row 3
>> data) Finish date & time is 09/09/2011 04:53. Arrival & Finish Date are not
>> same.
>>
>> Here is the another way. See the attached.
>>
>> __
>> Haseeb
>>
>> --
>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ INSERT THE ROW

[Jai]

THANKS A LOT

On Thu, Nov 3, 2011 at 3:56 PM, ashish koul  wrote:

> check the attachment
>
>
>
>
> On Thu, Nov 3, 2011 at 3:50 PM, Jai  wrote:
>
>> HOW CAN INSERT THE PLEASE GIVE THE VBA CODE OR FORMULA
>>
>> --
>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
>
>
> P Before printing, think about the environment.
>
>
>   --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Time Calculation From Two Different Formats

[John A. Smith]

Haseeb,

Thank you for that.  That solved an unrelated issue and was very helpful,
thank you.

John

On Wed, Nov 2, 2011 at 8:22 PM, Haseeb Avarakkan  wrote:

> Hello John,
>
> If the Arrival Date & Time is "09/08/2011 2310" & Length is 343 (Row 3
> data) Finish date & time is 09/09/2011 04:53. Arrival & Finish Date are not
> same.
>
> Here is the another way. See the attached.
>
> __
> Haseeb
>
> --
> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ INSERT THE ROW

[Jai]

HOW CAN INSERT THE PLEASE GIVE THE VBA CODE OR FORMULA

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


QUERY.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Advanced Filter

[airen]

Haseeb,

Is it possible to apply when I have records of two or more than two
column?

Thanks
Akhilesh

-- 
FORUM RULES (925+ 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 
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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need to copy of 1st sheet of every workbook in a single work book

[ashish koul]

Sub copy_first_sheet_from_different_workbooks_to_single()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Dim fld As Object, fil As Object
Dim ask As Workbook, ask2 As Workbook
With Application.FileDialog(msoFileDialogFolderPicker)
.Title = "Choose the folder"
.InitialFileName = "c:\"
.Show
End With
fldpath =
Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) & "\"
Set fso = CreateObject("scripting.filesystemobject")
Set fld = fso.getfolder(fldpath)
Set ask = Workbooks.Add
For Each fil In fld.Files
If UCase(Right(fil.Path, 4)) = UCase(".xls") Or UCase(Right(fil.Path, 5)) =
UCase(".xlsx") Then
Set ask2 = Workbooks.Open(fil.Path)
ask2.Sheets(1).UsedRange.Copy
ask.Activate
ask.Sheets.Add after:=Sheets(Sheets.Count)
ActiveSheet.Range("a1").Select
Selection.PasteSpecial xlValues
ask2.Close
End If
Next fil
Application.DisplayAlerts = True
Application.ScreenUpdating = True
End Sub

On Thu, Nov 3, 2011 at 1:06 PM,  wrote:

> **
> My files are saved in .xls format. But I am working in .xlxs.
>
>
> Sandeep Chhajer.
> Sent on my BlackBerryŽ from Vodafone
> --
> *From: * ashish koul 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Thu, 3 Nov 2011 13:04:02 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Need to copy of 1st sheet of every
> workbook in a single work book
>
> in which format ur files are saved  .xls or xlsx
>
>
>
> On Thu, Nov 3, 2011 at 11:56 AM, sandeep chhajer  > wrote:
>
>> Dear Ashish,
>>
>> I have copied it but when i am running the code it showing error msg pls
>> help.
>>
>> On 3 November 2011 10:53, ashish koul  wrote:
>>
>>> Sub copy_first_sheet_from_different_workbooks_to_single()
>>> Application.DisplayAlerts = False
>>> Application.ScreenUpdating = False
>>>
>>> Dim fld As Object, fil As Object
>>> Dim ask As Workbook, ask2 As Workbook
>>>
>>> With Application.FileDialog(msoFileDialogFolderPicker)
>>> .Title = "Choose the folder"
>>> .InitialFileName = "c:\"
>>> .Show
>>> End With
>>> fldpath =
>>> Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) & "\"
>>> Set fso = CreateObject("scripting.filesystemobject")
>>>
>>> Set fld = fso.getfolder(fldpath)
>>>
>>> Set ask = Workbooks.Add
>>>
>>> For Each fil In fld.Files
>>> If UCase(Right(fil.Path, 4)) = UCase(".xls") Or UCase(Right(fil.Path,
>>> 5)) = UCase(".xlsx") Then
>>> Set ask2 = Workbooks.Open(fil.Path)
>>> ask2.Sheets(1).Copy After:=ask.Sheets(Sheets.Count)
>>> ask2.Close
>>>
>>> End If
>>> Next fil
>>>
>>> Application.DisplayAlerts = True
>>> Application.ScreenUpdating = True
>>> End Sub
>>>
>>> On Wed, Nov 2, 2011 at 3:43 PM, mrinal saha  wrote:
>>>
 Hi Sandeep,

 Save this attachment in the folder where you have all the workbooks and
 try to run the macro (Button) on page 1 of this file.

 Hope this helps,

 Mrinal

  On Wed, Nov 2, 2011 at 2:08 PM,  wrote:

> Dear all,
>
> I have many work book in a single folder. I need a macro which if I
> run will copy the 1st sheet of every workbook in a single workbook (though
> as separate sheet).
>
> Like if I have 2 workbook viz WB1 and WB2 then I want the 1st
> worksheet of WB1 as 1st worksheet in a new workbook (say WB3) and again 
> 1st
> worksheet of WB2 as 2nd worksheet of WB3.
>
>
> Thanks in advance.
> Sandeep Chhajer.
> Sent on my BlackBerryŽ from Vodafone
>
> --
> FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

 --
 FORUM RULES (925+ 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 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) Cr

Re: $$Excel-Macros$$ Need to copy of 1st sheet of every workbook in a single work book

[chhajersandeep]

My files are saved in .xls format. But I am working in .xlxs.

Sandeep Chhajer.

Sent on my BlackBerry® from Vodafone

-Original Message-
From: ashish koul 
Sender: excel-macros@googlegroups.com
Date: Thu, 3 Nov 2011 13:04:02 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need to copy of 1st sheet of every workbook in a
 single work book

in which format ur files are saved  .xls or xlsx



On Thu, Nov 3, 2011 at 11:56 AM, sandeep chhajer
wrote:

> Dear Ashish,
>
> I have copied it but when i am running the code it showing error msg pls
> help.
>
> On 3 November 2011 10:53, ashish koul  wrote:
>
>> Sub copy_first_sheet_from_different_workbooks_to_single()
>> Application.DisplayAlerts = False
>> Application.ScreenUpdating = False
>>
>> Dim fld As Object, fil As Object
>> Dim ask As Workbook, ask2 As Workbook
>>
>> With Application.FileDialog(msoFileDialogFolderPicker)
>> .Title = "Choose the folder"
>> .InitialFileName = "c:\"
>> .Show
>> End With
>> fldpath =
>> Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) & "\"
>> Set fso = CreateObject("scripting.filesystemobject")
>>
>> Set fld = fso.getfolder(fldpath)
>>
>> Set ask = Workbooks.Add
>>
>> For Each fil In fld.Files
>> If UCase(Right(fil.Path, 4)) = UCase(".xls") Or UCase(Right(fil.Path, 5))
>> = UCase(".xlsx") Then
>> Set ask2 = Workbooks.Open(fil.Path)
>> ask2.Sheets(1).Copy After:=ask.Sheets(Sheets.Count)
>> ask2.Close
>>
>> End If
>> Next fil
>>
>> Application.DisplayAlerts = True
>> Application.ScreenUpdating = True
>> End Sub
>>
>> On Wed, Nov 2, 2011 at 3:43 PM, mrinal saha  wrote:
>>
>>> Hi Sandeep,
>>>
>>> Save this attachment in the folder where you have all the workbooks and
>>> try to run the macro (Button) on page 1 of this file.
>>>
>>> Hope this helps,
>>>
>>> Mrinal
>>>
>>>  On Wed, Nov 2, 2011 at 2:08 PM,  wrote:
>>>
 Dear all,

 I have many work book in a single folder. I need a macro which if I run
 will copy the 1st sheet of every workbook in a single workbook (though as
 separate sheet).

 Like if I have 2 workbook viz WB1 and WB2 then I want the 1st worksheet
 of WB1 as 1st worksheet in a new workbook (say WB3) and again 1st worksheet
 of WB2 as 2nd worksheet of WB3.


 Thanks in advance.
 Sandeep Chhajer.
 Sent on my BlackBerryŽ from Vodafone

 --
 FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum
 in signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

>>>
>>> --
>>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *http://www.excelvbamacros.com/*
>>
>>
>> P Before printing, think about the environment.
>>
>>
>> --
>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>>

Re: $$Excel-Macros$$ Need to copy of 1st sheet of every workbook in a single work book

[ashish koul]

in which format ur files are saved  .xls or xlsx



On Thu, Nov 3, 2011 at 11:56 AM, sandeep chhajer
wrote:

> Dear Ashish,
>
> I have copied it but when i am running the code it showing error msg pls
> help.
>
> On 3 November 2011 10:53, ashish koul  wrote:
>
>> Sub copy_first_sheet_from_different_workbooks_to_single()
>> Application.DisplayAlerts = False
>> Application.ScreenUpdating = False
>>
>> Dim fld As Object, fil As Object
>> Dim ask As Workbook, ask2 As Workbook
>>
>> With Application.FileDialog(msoFileDialogFolderPicker)
>> .Title = "Choose the folder"
>> .InitialFileName = "c:\"
>> .Show
>> End With
>> fldpath =
>> Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) & "\"
>> Set fso = CreateObject("scripting.filesystemobject")
>>
>> Set fld = fso.getfolder(fldpath)
>>
>> Set ask = Workbooks.Add
>>
>> For Each fil In fld.Files
>> If UCase(Right(fil.Path, 4)) = UCase(".xls") Or UCase(Right(fil.Path, 5))
>> = UCase(".xlsx") Then
>> Set ask2 = Workbooks.Open(fil.Path)
>> ask2.Sheets(1).Copy After:=ask.Sheets(Sheets.Count)
>> ask2.Close
>>
>> End If
>> Next fil
>>
>> Application.DisplayAlerts = True
>> Application.ScreenUpdating = True
>> End Sub
>>
>> On Wed, Nov 2, 2011 at 3:43 PM, mrinal saha  wrote:
>>
>>> Hi Sandeep,
>>>
>>> Save this attachment in the folder where you have all the workbooks and
>>> try to run the macro (Button) on page 1 of this file.
>>>
>>> Hope this helps,
>>>
>>> Mrinal
>>>
>>>  On Wed, Nov 2, 2011 at 2:08 PM,  wrote:
>>>
 Dear all,

 I have many work book in a single folder. I need a macro which if I run
 will copy the 1st sheet of every workbook in a single workbook (though as
 separate sheet).

 Like if I have 2 workbook viz WB1 and WB2 then I want the 1st worksheet
 of WB1 as 1st worksheet in a new workbook (say WB3) and again 1st worksheet
 of WB2 as 2nd worksheet of WB3.


 Thanks in advance.
 Sandeep Chhajer.
 Sent on my BlackBerryŽ from Vodafone

 --
 FORUM RULES (925+ 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 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)  Cross-promotion of, or links to, forums competitive to this forum
 in signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

>>>
>>> --
>>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *http://www.excelvbamacros.com/*
>>
>>
>> P Before printing, think about the environment.
>>
>>
>> --
>> FORUM RULES (925+ 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 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Regards,
> Sande