Re: $$Excel-Macros$$ Hightlight the text for day Fridays only.....

[vijayajith VA]

use ths below code...

.

Sub highlight_friday()
Dim rng As Range
Dim cell As Range
Dim sh As Worksheet
Set rng = Sheet1.Range("A2:A" & Sheet1.Range("A" &
Rows.Count).End(xlUp).Row)
For Each cell In rng
If VBA.Weekday(cell) = 6 Then
cell.Offset(0, 1).Interior.Color = vbCyan
End If
Next cell
End Sub




On Wed, Aug 15, 2012 at 12:07 PM, vijayajith VA wrote:

> HI Muneer,,,
>
> I think Few days back noorain & rajan had answered for same questions
>
>
> On Wed, Aug 15, 2012 at 11:28 AM, Mohammed Muneer wrote:
>
>> **
>> Dear Group,
>>
>> Please highlight the text in column B based on Friday.
>>
>>
>> Regards,
>> Muneer,
>> CC
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Hightlight the text for day Fridays only.....

[vijayajith VA]

HI Muneer,,,

I think Few days back noorain & rajan had answered for same questions


On Wed, Aug 15, 2012 at 11:28 AM, Mohammed Muneer wrote:

> **
> Dear Group,
>
> Please highlight the text in column B based on Friday.
>
>
> Regards,
> Muneer,
> CC
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Hightlight the text for day Fridays only.....

[Mohammed Muneer]

Dear Group, 
 
Please highlight the text in column B based on Friday.
 
 
Regards,
Muneer,
CC

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




hi-lite based on date.xls
Description: hi-lite based on date.xls

$$Excel-Macros$$ Word Wrap in Excel......

[Mohammed Muneer]

  

  Dear Rajan,

 

  See the attached sheet (Word Wrap 1)

  

  Ref: to the reply

 

  And thanx for the reply

 

  Regards,

  Muneer,

  CC

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


<>

word wrap 1.xls
Description: word wrap 1.xls

RE: $$Excel-Macros$$ Please help (Word Wrap in Excel).....

[Mohammed Muneer]

I want word wrap option to be active in excel - its effect should be
like this.

 

  Condition 1 :  the word / font train should not cross the page break
line.

 

  Condition 2 : on the completion of one line the font should adjust the
line previous and jump to the another cell or row to continue doing the
next line.

 

 

If your work fulfill this two conditions then it will be a great help to
me to carry on my further work because I have lots of data to be written
in excel following to the WBS (Work Break   Down System)

 

 

Note: See the attached file word wrap 1. ( I want to share an example
also with u)

 

Help me: please share the answered attachment in 2003 format as my
system doesn't have dual operating system.

 

 

Regards,

Muneer,

CC.


--

 

What is your issue.? Please explain

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer
Sent: 15 August 2012 10:23
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help (Word Wrap in Excel).

 

Dear Group,

 

Please help to solve this issue'

 

 

Regards,

Muneer,

CC  

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ Please help (Word Wrap in Excel).....

[Rajan_Verma]

What is your issue.? Please explain

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mohammed Muneer
Sent: 15 August 2012 10:23
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help (Word Wrap in Excel).

 

Dear Group,

 

Please help to solve this issue'

 

 

Regards,

Muneer,

CC..  

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


<>

$$Excel-Macros$$ Happy independence day

[Mohammed Muneer]

Dear Ayush,

 

Please allow me to send the greetings to my friends for a moment.

 

 Happy independence day to all

my Indian brothers

 

   Happy Independence Day 

-

Regards,

Muneer,

CC...

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


<>

Re: $$Excel-Macros$$ Urgent Required Oracle AIA Consultant,Sunrise, FL

[noorain . ansari]

Dear Ayush,

Please ban thiS user



Sent from BlackBerry® on Airtel

-Original Message-
From: Karan Bhatia 
Sender: excel-macros@googlegroups.com
Date: Wed, 15 Aug 2012 01:36:30 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Required Oracle AIA Consultant,Sunrise, FL

Please respond to @ karanbhatia...@yahoo.com
**

*Position:* Oracle AIA Consultant



*Location: *Sunrise, FL



*Duration: *6 Months* *


*Skills Set** *

* *

· Oracle AIA

· Should have worked in at least 1 prior AIA project

· Important Skill - Should have AIA experience.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.



-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ macro for detecting date in row

[pawel lupinski]

Paul,
 
It's great this what I wanted
Thank you so so so so much
 
Pawel
 


 From: Paul Schreiner 
To: excel-macros@googlegroups.com 
Sent: Tuesday, August 14, 2012 12:22 PM
Subject: Re: $$Excel-Macros$$ macro for detecting date in row
  

 
Ahh... I see what you're trying to do. 
Your worksheet has formulas. 
on any given day, you want to "freeze" the previous values 
so that they will no longer update. 

You PROBABLY only need to freeze the current date,  
because yesterday's data would have been "frozen" yesteday, 
and the day before that was frozen then, and so on. 

however, this macro should do what you asked: 

Sub Freeze_Values()
    Dim C, nCols
    nCols = ActiveCell.SpecialCells(xlLastCell).Column
    For C = 1 To nCols
    If (IsDate(Cells(6, C).Value)) Then
    If (DateDiff("D", Cells(6, C).Value, Now()) = 0) Then
    Range(Cells(1, 1), Cells(1, C)).EntireColumn.Select
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, 
SkipBlanks _
    :=False,
 Transpose:=False
    Cells(6, C).Select
    Exit For
    End If
    End If
    Next C
End Sub
  
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: pawel lupinski 
To: "excel-macros@googlegroups.com" 
Sent: Mon, August 13, 2012 7:36:01 PM
Subject: $$Excel-Macros$$ macro for detecting date in row


Hi All, 
I'd like to have a macro that will detect curent date (eg in column "H") 
then copy all all columns from "A" to column "H" (column "H" excuded so range 
A:G) and paste all these column as value 
Thanks 
Pawel 
 
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post
 personal or confidential data in a workbook. Forum owners and members are not 
responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their link

Re: $$Excel-Macros$$ Out of Topic -- Request

[David Grugeon]

I expect your IP is processing the email and identifying/deleting spam.
 Contact them and ask them to whitelist the group for you.

On 14 August 2012 23:00, Ashish Pradhan  wrote:

>
> Hello Group and Ayush,
>
>  Over the last few days, I have been missing some emails especially from
> Noorain.
>
> I use Thunderbird and all the emails from Noorain come marked with a
> "Suspected Scam" warning. Result is that Thunderbird automatically
> transfers such emails to the Trash Folder (These settings are at my end). I
> have not specified any particular email to be marked as "Suspected Scam". I
> have been using the same Thunderbird Settings for a long time now and
> perhaps there are some external changes in the way emails are being
> received. (Does not seem likely though).
>
> Any idea anyone what could be the reason. I do not actively participate in
> the resolution of queries (limited knowledge) but try and look at the
> questions and the solutions provided by the experts to enhance my limited
> knowledge. I do not want to miss out on some of the wonderful solutions
> provided by Noorain and many other experts.
>
> Any suggestions?
>
>  Thanks
>
> Ashish Pradhan
>
> On 14-08-2012 17:57, NOORAIN ANSARI wrote:
>
> Dear Kenil,
>
> Without using ctrl+shfit+enter
>
> You can also use..
>
> =SUMPRODUCT(MIN(($D2:$G2>0)*($D2:$G2)))
> =SUMPRODUCT(MAX(($D2:$G2>0)*($D2:$G2)))
>
>
> On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA wrote:
>
>>
>>
>> On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA 
>> wrote:
>>
>>>
>>>  Hi kenil,
>>>
>>>  Pls change accordg to your data.
>>>
>>>  =MAX(IF(B1:B7>0,B1:B7))
>>> =MIN(IF(A1:A7>0,A1:A7))
>>>
>>>
>>> On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala  wrote:
>>>
   hi all,

 i have a query for finding maximum and minimum values.
 i have written my query in the excel sheet attached. pls help me solve
 my query.


 Thanks and Regards,

   --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ 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.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups "MS EXCEL AND VBA MACROS" group.
 To post to this group, send email to excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.



>>>
>>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Probl

Re: $$Excel-Macros$$ query for finding maximum and minimum values

[dguillett1]

I am available for custom excel projects at only $75 hourly .

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: Kenil Gala 
Sent: Tuesday, August 14, 2012 12:20 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values

  Yes Sir,
  Perfect
  Thanks a Ton.

  Thanks & Regards,

  --- On Tue, 8/14/12, dguillett1  wrote:


From: dguillett1 
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum 
values
To: excel-macros@googlegroups.com
Date: Tuesday, August 14, 2012, 5:05 PM


Should do it

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: Kenil Gala 
Sent: Tuesday, August 14, 2012 10:45 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum 
values

  Hello sir ,
  i have explained my query more clearly again in the excel sheet.
  i hope u'll be able to understand the query.

  Thanks and Regards,

  --- On Tue, 8/14/12, dguillett1  wrote:


From: dguillett1 
Subject: Re: $$Excel-Macros$$ query for finding maximum and 
minimum values
To: excel-macros@googlegroups.com
Date: Tuesday, August 14, 2012, 3:02 PM


This is your question in i4 comment
hi, I have daily data of high , low and close of a specific 
stock (BSE). But I want weekly high,low,close and also monthly high, low, close 
in their respective sheets. Eg. Stock market has 5 working days, so any value 
which can be highest and lowest withing the week and the closing price of 
friday. i tried doing this by taking 5 set of data( monday - friday) but at 
times of holiday, markets remain working only 4 or 3 days. so, can you help me 
finding weekly high, low, close and also monthly high, low, close( from 1st to 
31st or 30th or 28th as per month) and also "TO" and "from" date i.e the time 
span of that week or month. that i have mentioned in the table in sheet 2 and 
sheet 3. 
i have taken all this data from www.nseindia.com Thanks.
===
Your query is not understandable. 
If you  want the minimum low and the maximum high and the 
average close for the week, see attached.
Maybe you really want the min CLOSE??

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: Kenil Gala 
Sent: Tuesday, August 14, 2012 6:54 AM
To: excel macros 
Subject: $$Excel-Macros$$ query for finding maximum and minimum 
values

  hi all,

  i have a query for finding maximum and minimum values.
  i have written my query in the excel sheet attached. pls 
help me solve my query.


  Thanks and Regards,
 
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not 
allowed.
 
NOTE : Don't ever post personal or confidential data in a 
workbook. Forum owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the 
Google Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to 
excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
   

Re: $$Excel-Macros$$ query for finding maximum and minimum values

[Kenil Gala]

Yes Sir,
Perfect
Thanks a Ton.
 
Thanks & Regards,

--- On Tue, 8/14/12, dguillett1  wrote:


From: dguillett1 
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
To: excel-macros@googlegroups.com
Date: Tuesday, August 14, 2012, 5:05 PM






Should do it
 
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com


 

From: Kenil Gala 
Sent: Tuesday, August 14, 2012 10:45 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
 





Hello sir ,
i have explained my query more clearly again in the excel sheet.
i hope u'll be able to understand the query.
 
Thanks and Regards,

--- On Tue, 8/14/12, dguillett1  wrote:


From: dguillett1 
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
To: excel-macros@googlegroups.com
Date: Tuesday, August 14, 2012, 3:02 PM






This is your question in i4 comment
hi, I have daily data of high , low and close of a specific stock (BSE). But I 
want weekly high,low,close and also monthly high, low, close in their 
respective sheets. Eg. Stock market has 5 working days, so any value which can 
be highest and lowest withing the week and the closing price of friday. i tried 
doing this by taking 5 set of data( monday - friday) but at times of holiday, 
markets remain working only 4 or 3 days. so, can you help me finding weekly 
high, low, close and also monthly high, low, close( from 1st to 31st or 30th or 
28th as per month) and also "TO" and "from" date i.e the time span of that week 
or month. that i have mentioned in the table in sheet 2 and sheet 3. 
i have taken all this data from www.nseindia.com Thanks.
===
Your query is not understandable. 
If you  want the minimum low and the maximum high and the average close for the 
week, see attached.
Maybe you really want the min CLOSE??
 
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com


 

From: Kenil Gala 
Sent: Tuesday, August 14, 2012 6:54 AM
To: excel macros 
Subject: $$Excel-Macros$$ query for finding maximum and minimum values
 





hi all,
 
i have a query for finding maximum and minimum values.
i have written my query in the excel sheet attached. pls help me solve my query.
 
 
Thanks and Regards,
 -- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
 
 
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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 a

Re: $$Excel-Macros$$ Excel VBA Challenge

[Sam Mathai Chacko]

A suggested way to do it in
http://www.excelfox.com/forum/f13/delete-worksheets-without-loop-515/

Here's a slightly modified version of the same

Sub kTest()

Dim var As Variant

With Application
var = .Transpose(.Evaluate("Row(2:" & Sheets.Count & ")"))
.DisplayAlerts = 0
Sheets(var).Delete
.DisplayAlerts = 1
End With

End Sub

Regards,
Sam Mathai Chacko

On Tue, Aug 14, 2012 at 8:02 PM, Rajan_Verma wrote:

> Hi Guys,
>
> Challenge is to Delete all Sheets Except one without any loop and mapping
> table.
>
> Keep Excelling
>
> * *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Sam Mathai Chacko

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Chart Update Within Date Data Range

[dguillett1]

The macro I gave you answers the question in the post of being able to change 
the chart NAME.
If  you want something else, send me the file again and a complete explanation.

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: amar takale 
Sent: Tuesday, August 14, 2012 12:18 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Chart Update Within Date Data Range

Dear Guillett Sir
I am confused about this code,I put this code but what changes in sheet,I am 
not under stand.Pls in attached sheet solved problem if possible.I think in to 
cell from date & Last date input through data validation & when I change range 
date then update chart between that date range.
Thanks for reply
Amar


On Mon, Aug 13, 2012 at 7:08 PM, dguillett1  wrote:

  Sub namechart()
  For Each c In ActiveSheet.ChartObjects
  c.Name = InputBox("Change the chart name " & c.Name)
  Next c
  End Sub

  Don Guillett
  Microsoft Excel Developer
  SalesAid Software
  dguille...@gmail.com

  From: amar takale 
  Sent: Monday, August 13, 2012 1:58 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Chart Update Within Date Data Range

  I will Attached file Pls solved me problem


  On Fri, Aug 10, 2012 at 3:35 PM, NOORAIN ANSARI  
wrote:

after typing = in Formula bar, Please select I2 cell then press Enter 



On Fri, Aug 10, 2012 at 3:33 PM, Imran khan  wrote:

  Hi Noorain, 

  I am not able do it. When i am selecting Chart title, when typing =, it 
remains = only  



  On Fri, Aug 10, 2012 at 3:15 PM, NOORAIN ANSARI 
 wrote:

Hi Imran,

First you select Chart Title then goto Formula Bar, Type = and select 
Cell "I2"

Hope it will help to you. 

On Fri, Aug 10, 2012 at 3:11 PM, Imran khan  wrote:

  Hi Noorain, 

  How we write formula in Text Box, as you write " Jan to May" 
(='Dynamic Char 2'$I$2). Could you please guide us. Can we do simply put = and 
then go to cell?

  Regards,
  Imran 



  On Fri, Aug 10, 2012 at 3:02 PM, NOORAIN ANSARI 
 wrote:

Dear Amar,

Please find attached Sample file, hope it will fulfill you 
expectation.



-- 
With Regards,
Noorain Ansari
http://noorainansari.com
http://excelvbaclinic.com 



On Fri, Aug 10, 2012 at 2:19 PM, amar takale  
wrote:

  Dear sir,
  I have One Chart File with Data,I want to if I changed Date 
from... to. (In particular two cell start & End date) Then automatically 
changed chart Range & Update Chart that within Date range.
  Pls send me Example file Then I will use that in my excel

  Thank Sir
  Amar -- 
  Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
   
  FORUM RULES (1120+ 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. 
   
  6) Jobs posting is not allowed.
   
  7) Sharing copyrighted ebooks/pirated ebooks/their links is not 
allowed.
   
  NOTE : Don't ever post personal or confidential data in a 
workbook. Forum owners and members are not responsible for any loss.
  --- 
  You received this message because you are subscribed to the 
Google Groups "MS EXCEL AND VBA MACROS" group.
  To post to this group, send email to 
excel-macros@googlegroups.com.

  To unsubscribe from this group, send email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com.
   
   





-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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

Re: $$Excel-Macros$$ Urgent required Network Engineer,Raleigh NC

[NOORAIN ANSARI]

Dear Karan,

Please follow rule no 5

5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

On Tue, Aug 14, 2012 at 8:38 PM, karan  wrote:

>
> *Please send me the  updated resumes @ ka...@hmgamerica.com
>
> Network Engineer
> Raleigh NC
> Long term.*
>
> L3 – 3 Positions
> L2 – 7 Positions
>
>
> Job Description Level – L2
> Experience – 5 + years
> Certifications:  CCNA and CCNA Voice (mandatory). CCVP (preferred)
> Location – Raleigh NC
>  Required Skills/Knowledge:
> - Cisco Unified Communications Manager (CUCM, formerly Call Manager)
> - CUCME
> - Cisco Unity, CUE
> - Unity Connection
> - Microsoft Windows Server
> - - Voice Gateways (SIP, MGCP, SCCP, H.323) & Gatekeeper
> - Analogue voice gateways, ATA, Basic fax troubleshooting.
> - RTMT usage
> - QoS
> - Basic Routing and Switching
> - ISDN and PRI
>
> Additional Skills/Knowledge:
>
> - CUBE
> - VMware
> -Microsoft Active Directory
> - Unix (preferred RedHaT Linux)
>
>
> Key Skills:
> - Ability to work on incidents of moderate to wide scope and moderate to
> high complexity to provide a solution.
> - Strong analytical and troubleshooting skills.
> - Excellent verbal and written communication skills.
> - Superior people skills.
> - Ability to work effectively with and provide guidance to other members
> of the work group.
> - Promotes and solicits ideas within the team.
> - Working knowledge of Networking industry, products and protocols.
> - Able to determine problems and deliver known solutions with a high level
> of customer satisfaction.
> - Suggests modifications to processes and procedures.
> - Exercises judgment within defined procedures to determine appropriate
> action.
> - Ability to communicate effectively both verbally and in writing.
> - Interacts well with peers.
>
>
> [image: https://mail.google.com/mail/images/cleardot.gif]
>
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ pls help me solve my query.

[dguillett1]

That file is mine and an example. I do custom programming at only $75 hourly 
with UN protected code.

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: amar takale 
Sent: Tuesday, August 14, 2012 8:26 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ pls help me solve my query.

File is same above name GetYahooMultipleHistoryALL_SAS_P1.xls which attached 
above.


On Tue, Aug 14, 2012 at 6:13 PM, dguillett1  wrote:

  Send YOUR file to ME with this msg and I’ll take a look.

  Don Guillett
  Microsoft Excel Developer
  SalesAid Software
  dguille...@gmail.com

  From: amar takale 
  Sent: Tuesday, August 14, 2012 2:23 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ pls help me solve my query.

  Dear dguillett Sir,
  How to do it & which stock price show?
  And also VBA code create passwords So I cant see code.
  Pls Explain it It is very useful for me to update comparative valuation.
  Thanks 
  Amar

  On Sat, Aug 4, 2012 at 6:23 PM, dguillett1  wrote:



Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: Kenil Gala 
Sent: Friday, August 03, 2012 1:09 AM
To: excel macros 
Subject: $$Excel-Macros$$ pls help me solve my query.

  hi folks, 
  i am having a query in getting external data,
  pls help me for the same.
  i have written my query in the excel sheet.


  Thanks in adv,

  Regards, 
-- 
FORUM RULES (986+ 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
 

To unsubscribe, send a blank email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com
 
 

-- 
FORUM RULES (986+ 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
 

To unsubscribe, send a blank email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com
 
 


  -- 
  Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
   
  FORUM RULES (1120+ 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. 
   

  6) Jobs posting is not allowed.
   
  7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. 

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

  You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
  To post to this group, send email to excel-macros@googlegroups.com.
  To unsubscribe from this group, send email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com.
   
   

  -- 
  Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
   
  FORUM RULES (1120+ members already BANNED for violation) 

   
  1) Use c

$$Excel-Macros$$ Excel VBA Challenge

[Rajan_Verma]

Hi Guys,

Challenge is to Delete all Sheets Except one without any loop and mapping
table.

Keep Excelling

 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ pls help me solve my query.

[amar takale]

File is same above name *GetYahooMultipleHistoryALL_SAS_P1.xls which
attached above.*

On Tue, Aug 14, 2012 at 6:13 PM, dguillett1  wrote:

>   Send YOUR file to ME with this msg and I’ll take a look.
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* amar takale 
> *Sent:* Tuesday, August 14, 2012 2:23 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ pls help me solve my query.
>
> Dear dguillett  Sir,
> How to do it & which stock price show?
> And also VBA code create passwords So I cant see code.
> Pls Explain it It is very useful for me to update comparative valuation.
> Thanks
> Amar
> On Sat, Aug 4, 2012 at 6:23 PM, dguillett1  wrote:
>
>>
>>
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Kenil Gala 
>> *Sent:* Friday, August 03, 2012 1:09 AM
>> *To:* excel macros 
>> *Subject:* $$Excel-Macros$$ pls help me solve my query.
>>
>>hi folks,
>> i am having a query in getting external data,
>> pls help me for the same.
>> i have written my query in the excel sheet.
>>
>>
>> Thanks in adv,
>>
>> Regards,
>> --
>> FORUM RULES (986+ 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
>>
>> To unsubscribe, send a blank email to
>> mailto:excel-macros%2bunsubscr...@googlegroups.com
>>
>>
>>  --
>> FORUM RULES (986+ 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
>>
>> To unsubscribe, send a blank email to
>> mailto:excel-macros%2bunsubscr...@googlegroups.com
>>
>>
>>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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 

$$Excel-Macros$$ Out of Topic -- Request

[Ashish Pradhan]

Hello Group and Ayush,

Over the last few days, I have been missing some emails especially from 
Noorain.


I use Thunderbird and all the emails from Noorain come marked with a 
"Suspected Scam" warning. Result is that Thunderbird automatically 
transfers such emails to the Trash Folder (These settings are at my 
end). I have not specified any particular email to be marked as 
"Suspected Scam". I have been using the same Thunderbird Settings for a 
long time now and perhaps there are some external changes in the way 
emails are being received. (Does not seem likely though).


Any idea anyone what could be the reason. I do not actively participate 
in the resolution of queries (limited knowledge) but try and look at the 
questions and the solutions provided by the experts to enhance my 
limited knowledge. I do not want to miss out on some of the wonderful 
solutions provided by Noorain and many other experts.


Any suggestions?

Thanks

Ashish Pradhan

On 14-08-2012 17:57, NOORAIN ANSARI wrote:

Dear Kenil,

Without using ctrl+shfit+enter

You can also use..

=SUMPRODUCT(MIN(($D2:$G2>0)*($D2:$G2)))
=SUMPRODUCT(MAX(($D2:$G2>0)*($D2:$G2)))


On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA 
mailto:vijayajith...@gmail.com>> wrote:




On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA
mailto:vijayajith...@gmail.com>> wrote:


Hi kenil,

Pls change accordg to your data.

=MAX(IF(B1:B7>0,B1:B7))
=MIN(IF(A1:A7>0,A1:A7))


On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala mailto:keni...@yahoo.com>> wrote:

hi all,
i have a query for finding maximum and minimum values.
i have written my query in the excel sheet attached. pls
help me solve my query.
Thanks and Regards,

-- 
Join official facebook page of this forum @

https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links
is not allowed.

NOTE : Don't ever post personal or confidential data in a
workbook. Forum owners and members are not responsible for
any loss.
---
You received this message because you are subscribed to
the Google Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to
excel-macros@googlegroups.com
.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
.




-- 
Join official facebook page of this forum @

https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not
allowed.

NOTE : Don't ever post personal or confidential data in a
workbook. Forum owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com
.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
.





--
With Regards,
Noorain Ansari
http:// noorainansari.com 

http:// excelvbaclinic.com 




--
Join official facebook page of this forum @ 
https:/

Re: $$Excel-Macros$$ query for finding maximum and minimum values

[NOORAIN ANSARI]

Dear Kenil,

There is no attachment with this mail.
Please send attachment with comment.


On Tue, Aug 14, 2012 at 6:19 PM, Kenil Gala  wrote:

> thank u vijayajith and noorain ansari for your reply,
> but i think u have mis understood my query.
> i have written my query with a comment in another cell again,
>
> Thanks and Regards.
>
> --- On *Tue, 8/14/12, NOORAIN ANSARI * wrote:
>
>
> From: NOORAIN ANSARI 
> Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
> To: excel-macros@googlegroups.com
> Date: Tuesday, August 14, 2012, 12:27 PM
>
>
> Dear Kenil,
>
> Without using ctrl+shfit+enter
>
> You can also use..
>
> =SUMPRODUCT(MIN(($D2:$G2>0)*($D2:$G2)))
> =SUMPRODUCT(MAX(($D2:$G2>0)*($D2:$G2)))
>
>
> On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA 
> http://us.mc1144.mail.yahoo.com/mc/compose?to=vijayajith...@gmail.com>
> > wrote:
>
>
>
> On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA 
> http://us.mc1144.mail.yahoo.com/mc/compose?to=vijayajith...@gmail.com>
> > wrote:
>
>
> Hi kenil,
>
> Pls change accordg to your data.
>
> =MAX(IF(B1:B7>0,B1:B7))
> =MIN(IF(A1:A7>0,A1:A7))
>
>
> On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala 
> http://us.mc1144.mail.yahoo.com/mc/compose?to=keni...@yahoo.com>
> > wrote:
>
>   hi all,
>
> i have a query for finding maximum and minimum values.
> i have written my query in the excel sheet attached. pls help me solve my
> query.
>
>
> Thanks and Regards,
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to 
> excel-macros@googlegroups.com
> .
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com
> .
>
>
>
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to 
> excel-macros@googlegroups.com
> .
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com
> .
>
>
>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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 

Re: $$Excel-Macros$$ query for finding maximum and minimum values

[Kenil Gala]

thank u vijayajith and noorain ansari for your reply,
but i think u have mis understood my query.
i have written my query with a comment in another cell again, 
 
Thanks and Regards.

--- On Tue, 8/14/12, NOORAIN ANSARI  wrote:


From: NOORAIN ANSARI 
Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values
To: excel-macros@googlegroups.com
Date: Tuesday, August 14, 2012, 12:27 PM


Dear Kenil,

Without using ctrl+shfit+enter 

You can also use..

=SUMPRODUCT(MIN(($D2:$G2>0)*($D2:$G2)))
=SUMPRODUCT(MAX(($D2:$G2>0)*($D2:$G2)))



On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA  wrote:






On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA  wrote:




Hi kenil,


Pls change accordg to your data.

=MAX(IF(B1:B7>0,B1:B7))
=MIN(IF(A1:A7>0,A1:A7))




On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala  wrote:






hi all,
 
i have a query for finding maximum and minimum values.
i have written my query in the excel sheet attached. pls help me solve my query.
 
 
Thanks and Regards,
 
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
 
 



-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
 
 



-- 
With Regards,
Noorain Ansari
http://noorainansari.com
http://excelvbaclinic.com 




-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 

Re: $$Excel-Macros$$ Re: support

[NOORAIN ANSARI]

Hi Jayendra,

Please share a sample workbook with example

On Mon, Aug 13, 2012 at 11:31 AM, jayendra gaurav  wrote:

> pls support me
>
>
> On Tue, Aug 7, 2012 at 5:36 PM, jayendra gaurav  > wrote:
>
>> Team,
>>
>> I am using excel 2007.
>>
>> I have one file .i need one icon for all excel work book  where i click
>> and that file need to open.
>>
>>
>>
>>
>> --
>> J.Gaurav
>> Call-7838594954
>>
>
>
>
> --
> J.Gaurav
> Call-7838594954
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ pls help me solve my query.

[dguillett1]

Send YOUR file to ME with this msg and I’ll take a look.

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: amar takale 
Sent: Tuesday, August 14, 2012 2:23 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ pls help me solve my query.

Dear dguillett Sir,
How to do it & which stock price show?
And also VBA code create passwords So I cant see code.
Pls Explain it It is very useful for me to update comparative valuation.
Thanks 
Amar

On Sat, Aug 4, 2012 at 6:23 PM, dguillett1  wrote:



  Don Guillett
  Microsoft Excel Developer
  SalesAid Software
  dguille...@gmail.com

  From: Kenil Gala 
  Sent: Friday, August 03, 2012 1:09 AM
  To: excel macros 
  Subject: $$Excel-Macros$$ pls help me solve my query.

hi folks, 
i am having a query in getting external data,
pls help me for the same.
i have written my query in the excel sheet.


Thanks in adv,

Regards, 
  -- 
  FORUM RULES (986+ 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
   
  To unsubscribe, send a blank email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com
   
   

  -- 
  FORUM RULES (986+ 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
   
  To unsubscribe, send a blank email to 
mailto:excel-macros%2bunsubscr...@googlegroups.com
   
   


-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

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

Re: $$Excel-Macros$$ query for finding maximum and minimum values

[NOORAIN ANSARI]

Dear Kenil,

Without using ctrl+shfit+enter

You can also use..

=SUMPRODUCT(MIN(($D2:$G2>0)*($D2:$G2)))
=SUMPRODUCT(MAX(($D2:$G2>0)*($D2:$G2)))


On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA wrote:

>
>
> On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA wrote:
>
>>
>> Hi kenil,
>>
>> Pls change accordg to your data.
>>
>> =MAX(IF(B1:B7>0,B1:B7))
>> =MIN(IF(A1:A7>0,A1:A7))
>>
>>
>> On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala  wrote:
>>
>>> hi all,
>>>
>>> i have a query for finding maximum and minimum values.
>>> i have written my query in the excel sheet attached. pls help me solve
>>> my query.
>>>
>>>
>>> Thanks and Regards,
>>>
>>>
>>> --
>>> Join official facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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.
>>>
>>> 6) Jobs posting is not allowed.
>>>
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Required hep in V Look up formula

[Paul Schreiner]

One problem is that your "numbers" in sheet1 are actually text strings.
while the matching column "B" in sheet2 are actual numbers.
I simply selected column "A" in sheet1 and replaced 1 with 1, 2 with 2, 3 with 3
and it converted the text to numbers
and located these values.
 
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: Pravin Gunjal 
To: excel-macros@googlegroups.com
Sent: Tue, August 14, 2012 8:03:01 AM
Subject: $$Excel-Macros$$ Required hep in V Look up formula

Dear Friends 

I have use a v-look up in Sheet 1 from Sheet 2 of the attached file.

Please see the Sheet 1
Look up value is available in column A
V Look up result should come in column B


But the data is not picking up automatically.  And I need to go to edit the 
Look 
up value one by one to get the results.
The file is attached for reference.

Please help me out on this issue.  Thanks !

With regards,
Pravin Gunjal
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Required hep in V Look up formula

[NOORAIN ANSARI]

Dear Pravin,

Please use

=VLOOKUP(VALUE(A3),Sheet2!$B$1:$C$1886,2,0)

On Tue, Aug 14, 2012 at 5:32 PM, Pravin Gunjal  wrote:

> Dear Friends
>
> I have use a v-look up in Sheet 1 from Sheet 2 of the attached file.
>
> *Please see the Sheet 1*
> Look up value is available in column *A*
> V Look up result should come in column *B*
>
> But the data is not picking up automatically.  And I need to go to edit
> the Look up value one by one to get the results.
> The file is attached for reference.
>
> Please help me out on this issue.  Thanks !
>
> *With regards,
> **Pravin Gunjal**
> *
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ payback Period Formula / Macro

[sharad jain]

Hi David,

Thanks a lot for your help on this. Really appreciate.

Best Regards,
Sharad

On Tue, Aug 14, 2012 at 3:19 PM, David Grugeon  wrote:

> Sorry.  I worked it for each input value being the cash flow for a year.
>  I see that you have put down a "Year 0" and the cash flows for the Year 0
> and Year 1 would both be in what I call Year 1.
>
> I have changed the macro to work in the way you do.
>
> PFA
>
>
> On 14 August 2012 17:04, Sj  wrote:
>
>> Hi David,
>>
>> Though it is working my main sheet. It is giving wrong results.
>>
>> Can you please recheck? I have attached my actual numbers.
>>
>> Thanks,
>> Sharad
>>
>>
>> On Saturday, August 11, 2012 5:26:32 PM UTC+5:30, David Grugeon wrote:
>>>
>>> Hi Sharad
>>>
>>> Use the following function in a general module.  Then use
>>> =Payback(range)
>>>
>>> See attached
>>>
>>> '=**
>>> Function PayBack(ByRef rng As Range) As Variant
>>> 'check that the range has only one dimension
>>> If rng.Rows.Count > 1 And rng.Columns.Count > 1 Then
>>> PayBack = "error"
>>> Else
>>>
>>> Dim t As Double 'The total value
>>> Dim t1 As Double
>>> Dim t2 As Double
>>> Dim x As Long 'cell counter
>>> Dim p As Double 'the part of the following year
>>>
>>> ' find the period
>>> Do Until t > 1
>>> x = x + 1
>>> t = t + rng.Cells(x).Value
>>> Loop
>>>
>>> PayBack = x - (t / rng.Cells(x).Value)
>>> End If
>>>
>>> End Function
>>> '=**
>>>
>>> Regards
>>> David Grugeon
>>>
>>>
>>>
>
>
> --
> Regards
> David Grugeon
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ query for finding maximum and minimum values

[vijayajith VA]

Hi kenil,

Pls change accordg to your data.

=MAX(IF(B1:B7>0,B1:B7))
=MIN(IF(A1:A7>0,A1:A7))

On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala  wrote:

> hi all,
>
> i have a query for finding maximum and minimum values.
> i have written my query in the excel sheet attached. pls help me solve my
> query.
>
>
> Thanks and Regards,
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ macro for detecting date in row

[Paul Schreiner]

Ahh... I see what you're trying to do.
Your worksheet has formulas.
on any given day, you want to "freeze" the previous values
so that they will no longer update.

You PROBABLY only need to freeze the current date, 
because yesterday's data would have been "frozen" yesteday,
and the day before that was frozen then, and so on.

however, this macro should do what you asked:

Sub Freeze_Values()
    Dim C, nCols
    nCols = ActiveCell.SpecialCells(xlLastCell).Column
    For C = 1 To nCols
    If (IsDate(Cells(6, C).Value)) Then
    If (DateDiff("D", Cells(6, C).Value, Now()) = 0) Then
    Range(Cells(1, 1), Cells(1, C)).EntireColumn.Select
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, 
SkipBlanks _
    :=False, Transpose:=False
    Cells(6, C).Select
    Exit For
    End If
    End If
    Next C
End Sub
 
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: pawel lupinski 
To: "excel-macros@googlegroups.com" 
Sent: Mon, August 13, 2012 7:36:01 PM
Subject: $$Excel-Macros$$ macro for detecting date in row


Hi All,
I'd like to have a macro that will detect curent date (eg in column "H")
then copy all all columns from "A" to column "H" (column "H" excuded so range 
A:G) and paste all these column as value
Thanks
Pawel
 -- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 

 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners 
and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Run time error "out of memory 7"

[David Grugeon]

Hi Prince

Is there any reason not to think that an "Out of memory" message mens that
the computer is out of memory.

There are a number of possible causes which could include:

Not enough physical memory
Too many other programs running
Not enough disk space for paging memory
A program (not necessarily your one) which is badly written and uses memory
(a memory leak)
Inappropriately configured virtual memory
Defective physical memory
A virus
and probably many others

Start by finding out how much memory is installed on each of the machines.
Then look at running processes in Task Manager.  See if one of these uses
excessive memory and if it is needed.
have a look at the configuration of virtual memory and see if ti is
appropriate, given the speed of the computer, the hard disk and the amount
of physical memory
See if the amount of memory reported by the system (on My Computer -
properties) is the same as the installed memory
Make sure the computer has a good antivirus program running and that a
recent scan has been done.

If you compare the two computers in all these respects you may find out why
one runs out of memory and the other does not.



Regards
David Grugeon

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

[Ganesh]

Great Job Mr Noorain !!!


Keep on your helps in this and we will expect you as world familiar in this
expert ices.


Thanks & Regards,
Ganesh

On Tue, Aug 14, 2012 at 2:21 PM, amar takale  wrote:

> This is Great Noorain Sir
>
> Thanks Noorain for your effort.
> Also, thanks to all the people in the group for help.
>
>
> On Mon, Aug 6, 2012 at 5:56 PM, Venkat CV  wrote:
>
>> Congrats Noorain.
>>
>> --
>> *Best Regards,*
>> *Venkat *
>> *Chennai*
>> *
>> *
>>
>>
>> On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain wrote:
>>
>>> Dear members,
>>>
>>> Noorain Ansari has been selected as 'Most Helpful Member' for the month
>>> of July'12. He has posted 143 posts in July 2012 and helped many forum
>>> members through his excel expertise.
>>>
>>> I truly appreciate his consistency and commitment to the group. He is
>>> really doing great job.
>>>
>>> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
>>> Sunita and other folks for helping excel enthusiasts voluntarily !!
>>> Keep posting.
>>>
>>> Regards,
>>> Ayush Jain
>>> Group Manager
>>> Microsoft MVP
>>>
>>> --
>>> FORUM RULES (986+ 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
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>
>>
>>
>> *
>> *
>> *
>> *
>>
>>
>>  --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Regards,

Inscribe BPO Pvt. Ltd.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 po

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

[amar takale]

This is Great Noorain Sir
Thanks Noorain for your effort.
Also, thanks to all the people in the group for help.

On Mon, Aug 6, 2012 at 5:56 PM, Venkat CV  wrote:

> Congrats Noorain.
>
> --
> *Best Regards,*
> *Venkat *
> *Chennai*
> *
> *
>
>
> On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain  wrote:
>
>> Dear members,
>>
>> Noorain Ansari has been selected as 'Most Helpful Member' for the month
>> of July'12. He has posted 143 posts in July 2012 and helped many forum
>> members through his excel expertise.
>>
>> I truly appreciate his consistency and commitment to the group. He is
>> really doing great job.
>>
>> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
>> Sunita and other folks for helping excel enthusiasts voluntarily !!
>> Keep posting.
>>
>> Regards,
>> Ayush Jain
>> Group Manager
>> Microsoft MVP
>>
>> --
>> FORUM RULES (986+ 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
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
> *
> *
> *
> *
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Run time error "out of memory 7"

[Prince Dubey]

Hi Group,
 
I have a project which is running fine on my system with XP OS but the same 
project giving error of "Out of Memory 7" on other system with XP platform. 
I am using VBA and Acess  as data source. I tried my level best to track 
the source of error but not able to find it.So can you pls come up with 
your suggetions what may wrong with project.
 
regards
Prince 
 
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ pls help me solve my query.

[amar takale]

Dear dguillett  Sir,
How to do it & which stock price show?
And also VBA code create passwords So I cant see code.
Pls Explain it It is very useful for me to update comparative valuation.
Thanks
Amar
On Sat, Aug 4, 2012 at 6:23 PM, dguillett1  wrote:

>
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Kenil Gala 
> *Sent:* Friday, August 03, 2012 1:09 AM
> *To:* excel macros 
> *Subject:* $$Excel-Macros$$ pls help me solve my query.
>
>   hi folks,
> i am having a query in getting external data,
> pls help me for the same.
> i have written my query in the excel sheet.
>
>
> Thanks in adv,
>
> Regards,
> --
> FORUM RULES (986+ 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>
> --
> FORUM RULES (986+ 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
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ payback Period Formula / Macro

[Sj]

Hi David,

Though it is working my main sheet. It is giving wrong results.

Can you please recheck? I have attached my actual numbers.

Thanks,
Sharad

On Saturday, August 11, 2012 5:26:32 PM UTC+5:30, David Grugeon wrote:
>
> Hi Sharad
>
> Use the following function in a general module.  Then use =Payback(range)  
>
> See attached
>
> '=
> Function PayBack(ByRef rng As Range) As Variant
> 'check that the range has only one dimension
> If rng.Rows.Count > 1 And rng.Columns.Count > 1 Then
> PayBack = "error"
> Else
>
> Dim t As Double 'The total value
> Dim t1 As Double
> Dim t2 As Double
> Dim x As Long 'cell counter
> Dim p As Double 'the part of the following year
>
> ' find the period
> Do Until t > 1
> x = x + 1
> t = t + rng.Cells(x).Value
> Loop
>
> PayBack = x - (t / rng.Cells(x).Value)
> End If
>
> End Function
> '=
>
> Regards
> David Grugeon
>
>
>  

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Example_v1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12