Re: $$Excel-Macros$$ creating hyperlink on userform

[Abhishek Jain]

Dear Shankar,

Please find attached the solution you want. Change the path of your file in
the code of the form.

I have used a hand shaped cursor file to give a look of a hyperlink to the
label. For this I used a cursor file which is also attached. If you are not
seeing the "hand-shape" while hovering over the label, select this *han**
d.cur* file as the Label's MouseIcon image.

Feel free to revert in case you need anything else.

Cheers!

AJ

On Sat, Mar 24, 2012 at 9:11 AM, Shankar Bheema wrote:

> good morning abhishek
>
> thank you for providing solution, is it possible to open the file without
> mentioning path in the label caption ?
>
>
> On Thu, Mar 22, 2012 at 10:03 PM, Abhishek Jain wrote:
>
>> Assuming that you have placed full path of your file in the caption of
>> your label (label1 in this case) itself...
>>
>> *Private Sub Label1_Click()*
>> *Application.ThisWorkbook.FollowHyperlink Label1.Caption*
>> *End Sub*
>>
>> ...should work.
>>
>> HTH
>>
>>
>>
>> On Thu, Mar 22, 2012 at 4:17 PM, Shankar Bheema 
>> wrote:
>>
>>> Dear Experts
>>>
>>> If a pdf file name is placed on a Label form and assume its location is
>>> in D:/.  How it would be hyperlinked from the USerform.
>>>
>>> regards
>>> shankar sb
>>>
>>> --
>>> 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
>>>
>>
>>
>

-- 
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


HyperLink in U_Form.xlsm
Description: Binary data


hand.cur
Description: Binary data

$$Excel-Macros$$ Service Count problem

[Shankar Bheema]

Dear Experts

In the userform of the attached workbook contains Date of Joining text box
and Date of Retirement textbox.  The difference of both the values should
come to
23 yrs 01 mth 29 days  but it is showing as 23 yrs 01 mth 01 day


In my office procedure resultant date should be given 1 bonus day with
this, the result should be 23 yrs 01 mnth 30 days
In general, as per my office rules 30 days will be considered as 1 month
for calculation of salary

Final result should come like 23 yrs 02 mths 00 days

Pls rectify the problem.

regards
shankar sb

-- 
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


total service problem.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Help on Chart

[Shrinivas Shevde]

Respected All,
Please find attached sheet I want help to make chart.
I want to make a bar chart of 2 different thing having the difference very
vast
for an example reading of one graph is 13,13.5 13.8 14.5 and another
reading  is 0.98,0.97,0.91,0.87
If I make it on the samoe graph it looks odd .
I tried to put the another on secondary axis then the bar is overlapping .
I want both the graph side by side .
Please look at the sheet
Thanks in advance



-- 
Shrini

-- 
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


Chart in Microsoft PowerPoint.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

[Abhishek Jain]

Thanks all for their encouraging comments.

2012/3/24 Ram Naresh Verma 

> Congrates for fice year...
> And thanks
>
> Regards
> Ram
> On Mar 23, 2012 12:12 AM, "NOORAIN ANSARI" 
> wrote:
>
>>  जहाँ Excel के दीवानों की,  है बहूत घनी आबादी.
>> जहाँ Question,Answer करने की,है खूब आज़ादी.
>> जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो  गया.
>> दोस्तों उस अपने Excel-Macro ग्रुप का उम्र,  अब 5 साल हो गया.
>> चाहे सुबह हो या शाम, चाहे दिन हो या रात.
>> हर समय होती है यहाँ पोस्टिंग की बरसात.
>>ये उपवन सजा है दोस्तों, कई Talented फूलों से.
>>  यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से.
>> Logic की खेती होती है यहाँ solutions के खलिहानों में.
>> यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में..
>>जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया.
>>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
>> *Haseeb,SAM,DON,Ashish* जैसी हस्ती यहाँ पे बसती है.
>> Man of BT *Krishna* के solution को दुनिया तरसती है.
>>   *ASA,Rajan,Dilip,Maries* सब के सब कोहिनूर है.
>>   *Venkat,Sunny,Abhishekh* भी कम नहीं मशहूर है.
>> और भी यहाँ बहूत सारी शख्सियत है निराली.
>> *Ayush* बाबू करते है इस बगीया  की रखवाली.
>>ये  forum  अब मिशाल नहीं रहा, बल्कि बेमिशाल हो गया.
>>
>>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  ** *http://noorainansari.com/*
>> *http://excelmacroworld.blogspot.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
>>
>  --
> 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
>

-- 
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

Re: $$Excel-Macros$$ Simple VBA to Fill in blanks

[Mahesh parab]

Hi Jim

Please always reply to group for  prompt response of your query & better
solution.
someone else may find the solution helpful.


HTH
Mahesh
On Fri, Mar 23, 2012 at 11:12 PM, Jim Schug  wrote:

> Hi Mahesh, 
>
> Thank you very much. I works perfectly.
>
> ** **
>
> I’m new to posting.  Do I reply to you and post a reply to the group as
> well.
>
> Jim
>
> ** **
>
> *From:* Mahesh parab [mailto:mahes...@gmail.com]
> *Sent:* Friday, March 23, 2012 12:07 PM
> *To:* excel-macros@googlegroups.com; sch...@gmail.com
> *Subject:* Re: $$Excel-Macros$$ Simple VBA to Fill in blanks
>
> ** **
>
> Hi
>
> ** **
>
> PFA
>
> Try :
>
> Sub Mtest()
>
> Dim i As Long
>
> Dim Temp As String
>
> Temp = Cells(1, 1)
>
> For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row
>
> If Trim((Cells(i, 1)) = "") Then
>
> Cells(i, 1) = Temp
>
> Else
>
> Temp = Cells(i, 1)
>
> End If
>
> Next
>
> End Sub
>
> ** **
>
> HTH
>
> Mahesh
>
> ** **
>
> On Fri, Mar 23, 2012 at 6:34 PM, dguillett1  wrote:*
> ***
>
> http://contextures.com/xlDataEntry02.html#Fill 
>
>  
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  
>
> *From:* Jim Schug  
>
> *Sent:* Thursday, March 22, 2012 8:34 PM
>
> *To:* excel-macros@googlegroups.com 
>
> *Subject:* $$Excel-Macros$$ Simple VBA to Fill in blanks
>
>  
>
> Hi,
>
> I'm nearly brain dead (tired) and can't think straight. I have a simple
> issue. A macro to fill in blank values if found with the value from the
> cell above.
>
>  
>
> For example
>
>  
>
> 101
>
>  
>
>  
>
>  
>
> 1015
>
>  
>
> Would fill the blank rows with 101 until the next number 1015 is found,
> then it would use 1015 until another number...
>
>  
>
> A file with sample data is attached. Thanks in advance.
>
>  
>
>  
>
>  
>
>  
>
>  
>
>  
>
> --
> 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
>
> --
> 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
>
> ** **
>

-- 
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

Re: $$Excel-Macros$$ Excel formula help needed

[Kris]

Hi

In B3 on Sheet1

=IFERROR(MATCH('P&L 
(2)'!$H$4,INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A4:i4"),0),2)

Define B3 '*MatchCol'*
*
*
Now in B12 and copy down & across,

=IF(COLUMNS($A12:B12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(B$12:B12),MatchCol+COLUMNS($B12:B12)-1),"")

Kris

-- 
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

$$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

[Mohammed Muneer]

Dear Mr. Ayush congratulations for successful completion of 5 years of
tenure in helping the others it's a remarkable achievement that
cannot be taught by teachers, lecturers & their successors in any of the
circumstances in our future life.

 

Our teachers have done! their job to keep their profession alive, to
complete the syllabus for their part and to render financial help to
their family.  But you people carry the position some thing greater than
them anyway thanx Mr. Ayush and party for utmost help.

 

This generation machines & medicines cant show effect the sooner than
this Excel Macro Group.

 

Heads up to U Mr. Ayush & Party...and thanx to all my Group
Members..

 

Special thanx to those who r active in helping others

 

I can say we the learners are hesitant to say our problems but the speed
of the Experts doesn't rest at the same place

 

Really great to join this group..

 

Again thanx..

 

 

Regards,

Muneer,

CC...

 

 

-- 
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

$$Excel-Macros$$

[Mohammed Muneer]

Dear Mr. Ayush congratulations for successful completion of 5 years of
tenure in helping the others it's a remarkable achievement that
cannot be taught by teachers, lecturers & their successors in any of the
circumstances in our future life.

 

Our teachers have done! their job to keep their profession alive, to
complete the syllabus for their part and to render financial help to
their family.  But you people carry the position some thing greater than
them anyway thanx Mr. Ayush and party for utmost help.

 

This generation machines & medicines cant show effect the sooner than
this Excel Macro Group.

 

Heads up to U Mr. Ayush & Party...and thanx to all my Group
Members..

 

Special thanx to those who r active in helping others

 

I can say we the learners are hesitant to say our problems but the speed
of the Experts doesn't rest at the same place

 

Really great to join this group..

 

Again thanx..

 

 

Regards,

Muneer,

CC...

 

 

-- 
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

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

[Ram Naresh Verma]

Congrates for fice year...
And thanks

Regards
Ram
On Mar 23, 2012 12:12 AM, "NOORAIN ANSARI"  wrote:

> जहाँ Excel के दीवानों की,  है बहूत घनी आबादी.
> जहाँ Question,Answer करने की,है खूब आज़ादी.
> जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो  गया.
> दोस्तों उस अपने Excel-Macro ग्रुप का उम्र,  अब 5 साल हो गया.
> चाहे सुबह हो या शाम, चाहे दिन हो या रात.
> हर समय होती है यहाँ पोस्टिंग की बरसात.
>ये उपवन सजा है दोस्तों, कई Talented फूलों से.
>  यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से.
> Logic की खेती होती है यहाँ solutions के खलिहानों में.
> यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में..
>जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया.
>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
> *Haseeb,SAM,DON,Ashish* जैसी हस्ती यहाँ पे बसती है.
> Man of BT *Krishna* के solution को दुनिया तरसती है.
>   *ASA,Rajan,Dilip,Maries* सब के सब कोहिनूर है.
>   *Venkat,Sunny,Abhishekh* भी कम नहीं मशहूर है.
> और भी यहाँ बहूत सारी शख्सियत है निराली.
> *Ayush* बाबू करते है इस बगीया  की रखवाली.
>ये  forum  अब मिशाल नहीं रहा, बल्कि बेमिशाल हो गया.
>
>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://noorainansari.com/* 
> *http://excelmacroworld.blogspot.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
>

-- 
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

$$Excel-Macros$$ Show Image on Form

[Mr excel]

hi forum,
  Is it possible to show an image on the userform based on the selection of
a check box.Say for example i had four countries like
Australia,Newzealand,England & West Indies.I had created four check boxes
for these four countries.I want to show their Country Flags based on the
selection of each Country opposite to the check box...Kindly help.

Thanks & 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

Re: $$Excel-Macros$$ कविता: अपने E xcel-Macro ग्रुप का उम्र,अब 5 स ाल हो गया.****** FIVE YEARS COMPLETION******TH ANK YOU******

[dguillett1]

Thanks for the translation so I could also enjoy this wonderful poem.

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

From: chhajersand...@gmail.com 
Sent: Friday, March 23, 2012 10:50 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ कविता: अपने E xcel-Macro ग्रुप का उम्र,अब 5 स ाल 
हो गया.** FIVE YEARS COMPLETION**TH ANK YOU**

After reading the translation I just want to say...
3 cheers for Excel macros group, Noorain for his original master piece and 
avishek for ur spellbound translation!!
Hip Hip Hurrah!!

Sandeep Chhajer. 
Sent on my BlackBerry® from Vodafone



From: Abhishek Jain  
Sender: excel-macros@googlegroups.com 
Date: Fri, 23 Mar 2012 19:15:27 +0530
To: 
ReplyTo: excel-macros@googlegroups.com 
Cc: Don Guillett
Subject: Re: $$Excel-Macros$$ कविता: अपने E xcel-Macro ग्रुप का उम्र,अब 5 स ाल 
हो गया.** FIVE YEARS COMPLETION**TH ANK YOU**

Here, Don...


Where the population of excel lovers is very high
Where complete freedom is given to ask and reply
Following the posts of which many careers were happily told
That excel-macro group, my friends, is now 5 years old..

Be it dusk, dawn, day or night...
Posts keep raining just right...
This garden is decorated with flowers of talent...
Here happens cold wars with formulas of excel...

Logic is cultivated here in the fields of solutions...
Here, competition is mainly for offering solutions...
One got lucky be having which group's hold...

That excel-macro group, my friends, is now 5 years old.. 

Legends like Haseed, Sam, Don, Ashish reside here...
Man of BT Krishna give the world their pride here
Asa, Rajan, Dilip, Maries are the solitares...
Venkat and Sunny are the known volunteers


Many more wonders are also a part of this prize
This garden is nourished by Ayush's expertise
The group which has now become excellent in bold...
That excel-macro group, my friends, is now 5 years old.. 

Sorry for terrible translationits not easy to reproduce a masterpiece

2012/3/23 dguillett1 

  From the comments, I only wish I could read it.??

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

  From: NOORAIN ANSARI 
  Sent: Thursday, March 22, 2012 1:42 PM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो 
गया.** FIVE YEARS COMPLETION**THANK YOU**

  जहाँ Excel के दीवानों की,  है बहूत घनी आबादी.
  जहाँ Question,Answer करने की,है खूब आज़ादी.
  जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो  गया.
  दोस्तों उस अपने Excel-Macro ग्रुप का उम्र,  अब 5 साल हो गया.
  चाहे सुबह हो या शाम, चाहे दिन हो या रात.
  हर समय होती है यहाँ पोस्टिंग की बरसात.
 ये उपवन सजा है दोस्तों, कई Talented फूलों से.
   यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से.
  Logic की खेती होती है यहाँ solutions के खलिहानों में.
  यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में..
 जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया. 
 दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
  Haseeb,SAM,DON,Ashish जैसी हस्ती यहाँ पे बसती है.
  Man of BT Krishna के solution को दुनिया तरसती है.
ASA,Rajan,Dilip,Maries सब के सब कोहिनूर है.
Venkat,Sunny,Abhishekh भी कम नहीं मशहूर है. 

  और भी यहाँ बहूत सारी शख्सियत है निराली.
  Ayush बाबू करते है इस बगीया  की रखवाली.
 ये  forum  अब मिशाल नहीं रहा, बल्कि बेमिशाल हो गया.
   
 दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.



  -- 

  Thanks & regards,
  Noorain Ansari
  http://noorainansari.com/
  http://excelmacroworld.blogspot.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

  -- 
  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

RE: $$Excel-Macros$$ SQL Query - Excel VBA

[Asa Rossoff]

Hi Sharma,

I replied two weeks ago when you posted this question with a detailed
response with tips and requesting more information if you still needed help.

 

You didn't reply, but here is my post again.  I can help more, bnut please
review what I already said and let me know what help you still need.

  _  

Hi Sharma,

How do you define failure for the first query?  0 records returned?  an
error from the database server/engine?

 

What do you want to do with the result of the query?  Put it on a (new?)
sheet in your workbook?

*writing* the queries using VBA is very simple.  The following assembles the
first query statement in a string variable:

Sub WriteSQLquery ()

Dim SQL As String

SQL = _

"SELECT " & _

"  distinct AMRCostCtr " & _

"FROM " & _

"  [SRT1].[RequestToolDev].[dbo].[vReqsocs] a, " & _

"  [SRT1].[RequestToolDev].[dbo].[ReqMain] b " & _

"WHERE " & _

"  a.ReqID = b.ReqID and MainRequestNumber = '365700';"

End Sub

 

Here's a robust-looking, general-purpose procedure called SQLLoad to open a
recordset for your query and copy the data to a worksheet: Beyond Excel -
Say Goodbye to QueryTables
 .  The associated blog actually contains a lot of good information
and code for working with databases from Excel (some of it advanced).

 

You will need a connection string to identify your data source and (if
needed) credentials.  Connectionstrings.com
  has a large index of connection string
examples.  You should avoid Microsoft Jet connection strings and in cases
where there are alternatives, ODBC connection strings, which have been
replaced by newer drivers.  (ODBC is still fine and commonly used with many
non-Microsoft data stores).

 

See if the above info gets you started.  I can provide more help if needed.

Asa

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amrahs k
Sent: Friday, March 23, 2012 6:22 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ SQL Query - Excel VBA

 

Hi Team,

 

Here I am posting a request for running sql queries in excel macro. I have
listed my queries below. Currently am running these queries manually. I want
these queries needs to be run automatically.

 

SELECT distinct AMRCostCtr
 FROM [SRT1].[RequestToolDev].[dbo].[vReqsocs]
a,[SRT1].[RequestToolDev].[dbo].[ReqMain] b
  where a.ReqID = b.ReqID and MainRequestNumber = '353817'

 

If the above query does not return a result then it should automatically run
the second query and then second query as shown below.

 

SELECT StationBranch
FROM [SRT1].RequestToolDev.dbo.ReqAMROOS
WHERE ReqID  in (select reqid from [SRT1].RequestToolDev.dbo.ReqMain
where mainrequestnumber = 353817)

 

if the above one fails then it should run for the third one which is given
below.

 

SELECT BillableStationBranch
FROM [SRT1].RequestToolDev.dbo.ReqAMRIMAC
WHERE ReqID  in (select reqid from [SRT1].RequestToolDev.dbo.ReqMain
where mainrequestnumber = 353817)

 

Please help me to get this done.

 

Thanks,

Sharma Krishnan

-- 
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

-- 
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

Re: $$Excel-Macros$$ Excel formula help needed

[respuzy]

Hi Kris

Pls why is it that when you select ALL YEAR from cell H4 it seem to give a 
error?  
Sent from my BlackBerry® smartphone from Airtel Ghana

-Original Message-
From: Kris 
Sender: excel-macros@googlegroups.com
Date: Fri, 23 Mar 2012 08:52:30 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel formula help needed

OK. In B12 and copied down & across,

=IF(COLUMNS($A12:B12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(B$12:B12),MATCH($H$4,INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A4:i4"),0)+COLUMNS($B12:B12)-1),"")

Kris


>

-- 
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

-- 
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

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

[Dilip Pandey]

Thanks Noorain... you are awesome and multi - talented..

regards,
DILIPandey

On Fri, Mar 23, 2012 at 10:56 PM, Rajan_Verma wrote:

> Fantablus!!
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *xlstime
> *Sent:* Mar/Fri/2012 10:07
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब5
> साल हो गया.** FIVE YEARS COMPLETION**THANK YOU**
>
> ** **
>
> Thanks Brother...and really superb 
>
> 2012/3/23 NOORAIN ANSARI 
>
> जहाँ Excel के दीवानों की,  है बहूत घनी आबादी.
>
> जहाँ Question,Answer करने की,है खूब आज़ादी.
>
> जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो  गया.**
> **
>
> दोस्तों उस अपने Excel-Macro ग्रुप का उम्र,  अब 5 साल हो गया.
>
> चाहे सुबह हो या शाम, चाहे दिन हो या रात.
>
> हर समय होती है यहाँ पोस्टिंग की बरसात.
>
>ये उपवन सजा है दोस्तों, कई Talented फूलों से.
>
>  यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से.
>
> Logic की खेती होती है यहाँ solutions के खलिहानों में.
>
> यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में..
>
>जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया. 
>
>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
>
> *Haseeb,SAM,DON,Ashish* जैसी हस्ती यहाँ पे बसती है.
> Man of BT *Krishna* के solution को दुनिया तरसती है.
>   *ASA,Rajan,Dilip,Maries* सब के सब कोहिनूर है.
>   *Venkat,Sunny,Abhishekh* भी कम नहीं मशहूर है. 
>
> और भी यहाँ बहूत सारी शख्सियत है निराली.
> *Ayush* बाबू करते है इस बगीया  की रखवाली.
>ये  forum  अब मिशाल नहीं रहा, बल्कि बेमिशाल हो गया.
>
>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
> 
>
>
>
> -- 
>
> Thanks & regards,
>
> Noorain Ansari
>
> *http://noorainansari.com/*
>
> *http://excelmacroworld.blogspot.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
>
>
>
>
> --
> .
>
> --
> 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
>
> --
> 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
>



-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

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

1) Use concise, accurat

$$Excel-Macros$$ Re: date should be today's date in calendar in user form of excel

[Damimkader S. Meeran]

Hi,

In the workbook open module please write the following code

Private Sub Workbook_Open()
UserForm1.Calendar1.Value = DateTime.Date
End Sub

Regards,
Damimkader S. Meeran

On Friday, March 23, 2012 10:03:44 PM UTC+5:30, Raj Mahapatra wrote:
>
> hi group,
>
> i want date in calendar in user form should be today's date automatically.
>
> Thanks & 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

RE: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

[Rajan_Verma]

Fantablus!!

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of xlstime
Sent: Mar/Fri/2012 10:07
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो 
गया.** FIVE YEARS COMPLETION**THANK YOU**

 

Thanks Brother...and really superb 

2012/3/23 NOORAIN ANSARI 

जहाँ Excel के दीवानों की,  है बहूत घनी आबादी.

जहाँ Question,Answer करने की,है खूब आज़ादी.

जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो  गया.

दोस्तों उस अपने Excel-Macro ग्रुप का उम्र,  अब 5 साल हो गया.

चाहे सुबह हो या शाम, चाहे दिन हो या रात.

हर समय होती है यहाँ पोस्टिंग की बरसात.

   ये उपवन सजा है दोस्तों, कई Talented फूलों से.

 यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से.

Logic की खेती होती है यहाँ solutions के खलिहानों में.

यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में..

   जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया. 

   दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.

Haseeb,SAM,DON,Ashish जैसी हस्ती यहाँ पे बसती है.
Man of BT Krishna के solution को दुनिया तरसती है.
  ASA,Rajan,Dilip,Maries सब के सब कोहिनूर है.
  Venkat,Sunny,Abhishekh भी कम नहीं मशहूर है. 

और भी यहाँ बहूत सारी शख्सियत है निराली.
Ayush बाबू करते है इस बगीया  की रखवाली.
   ये  forum  अब मिशाल नहीं रहा, बल्कि बेमिशाल हो गया.  
 
   दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.




-- 

Thanks & regards,

Noorain Ansari

http://noorainansari.com/

  http://excelmacroworld.blogspot.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




-- 
.

-- 
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

-- 
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

Re: $$Excel-Macros$$ macro vba coding for html file search and paste the path as hyperlink

[Raj Mahapatra]

hi venkat,

appreciating for your assistance..

actually i have stored some html files in a particular folder and i wants
to search and hyperlink the path of that file in the sheet.

Thanks & Regards

On Fri, Mar 23, 2012 at 9:49 AM, Venkat CV  wrote:

> Hi ,
>
> See below link..
>
> http://www.pcreview.co.uk/forums/re-search-html-access-vba-t3992723.html
>
> *Best Regards,*
> *Venkat *
> *Chennai*
> *
> *
>
> On Thu, Mar 22, 2012 at 12:13 AM, Raj Mahapatra wrote:
>
>> hi all
>>
>> i am looking for some vba codes which will search html files (bases file
>> names in the sheet) from specified locations and paste the path of the same
>> file as hyperlink in the sheet
>>
>> Thanks
>>
>>
>>  --
>> 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
>>
>
>
>
> --
> *
> *
> *
> *
>
>
>  --
> 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
>

-- 
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

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

[xlstime]

Thanks Brother...and really superb

2012/3/23 NOORAIN ANSARI 

> जहाँ Excel के दीवानों की,  है बहूत घनी आबादी.
> जहाँ Question,Answer करने की,है खूब आज़ादी.
> जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो  गया.
> दोस्तों उस अपने Excel-Macro ग्रुप का उम्र,  अब 5 साल हो गया.
> चाहे सुबह हो या शाम, चाहे दिन हो या रात.
> हर समय होती है यहाँ पोस्टिंग की बरसात.
>ये उपवन सजा है दोस्तों, कई Talented फूलों से.
>  यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से.
> Logic की खेती होती है यहाँ solutions के खलिहानों में.
> यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में..
>जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया.
>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
> *Haseeb,SAM,DON,Ashish* जैसी हस्ती यहाँ पे बसती है.
> Man of BT *Krishna* के solution को दुनिया तरसती है.
>   *ASA,Rajan,Dilip,Maries* सब के सब कोहिनूर है.
>   *Venkat,Sunny,Abhishekh* भी कम नहीं मशहूर है.
> और भी यहाँ बहूत सारी शख्सियत है निराली.
> *Ayush* बाबू करते है इस बगीया  की रखवाली.
>ये  forum  अब मिशाल नहीं रहा, बल्कि बेमिशाल हो गया.
>
>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  ** *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.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
>



-- 
.

-- 
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

$$Excel-Macros$$ date should be today's date in calendar in user form of excel

[Raj Mahapatra]

hi group,

i want date in calendar in user form should be today's date automatically.

Thanks & 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

Re: $$Excel-Macros$$ Excel formula help needed

[hilary lomotey]

Thanks Kris its working great. 100% THIS time around


Maries thanks a zillion too your formula is also working 100%

i just realised that you made cell B11 an absolute reference, i just
changed it to B$11 and its now working 100%.

thanks both for you assistance

=IFERROR(CHOOSE(index,INDIRECT("ALW!"&CHAR(MATCH(B$11,ALW!$B$4:$H$4,0)+65)&ROW()-7),INDIRECT("AYRTN!"&CHAR(MATCH(B$11,AYRTN!$B$4:$H$4,0)+65)&ROW()-7),INDIRECT("BOPP!"&CHAR(MATCH(B$11,BOPP!$B$4:$H$4,0)+65)&ROW()-7),INDIRECT("CAL!"&CHAR(MATCH(B$11,CAL!$B$4:$H$4,0)+65)&ROW()-7)),"")

On Fri, Mar 23, 2012 at 3:52 PM, Kris  wrote:

> OK. In B12 and copied down & across,
>
>
> =IF(COLUMNS($A12:B12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(B$12:B12),MATCH($H$4,INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A4:i4"),0)+COLUMNS($B12:B12)-1),"")
>
> Kris
>
>
>>  --
> 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
>

-- 
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

$$Excel-Macros$$ Re: So is it common for even an easy question on the forum to not get answered?

[tangledweb]

I determine it by sorting the column.  If the first row is left out of the 
sort then it is treating it as a header.
You say you can override excel on this.   How is that done?

On Friday, March 23, 2012 12:41:57 AM UTC-7, Asa R. wrote: 
>
> Hi H.,
> Not sure how you are determining that Excel knows or doesn't know your
> column headings are column headings. 
>
> Do you mean it guesses correctly when you go to sort your data whether you
> have headings or not? 
>
> Excel is not a database management system, so you have to get used to the
> fact that Excel has kind of a wild-west, lawless attitude (both in general
> and in handling data). 
>
> You can clue Excel that your headings are headings by formatting them in
> bold and/or underline.  Excel uses various (undocumented) clues to make 
> it's
> educated guesses.  You can always override Excel's guesses when it does 
> make
> them, so it's not a huge deal either way. 
>
> The exception is in Excel 2007+ if you use the Table feature I mentioned
> previously: the first row of the table must have headings, and Excel knows
> they are headings.  You can refer to columns by column name when working
> with Tables. 
>
> Asa 
>
>

-- 
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

$$Excel-Macros$$ Re: So is it common for even an easy question on the forum to not get answered?

[tangledweb]

I determine it by sorting the column.  If the first row is left out of the 
sort then it is treating it as a header.
You say you can override excel on this.   How is that done?
 
 

On Friday, March 23, 2012 12:41:57 AM UTC-7, Asa R. wrote:

> Hi H.,
> Not sure how you are determining that Excel knows or doesn't know your
> column headings are column headings. 
>
> Do you mean it guesses correctly when you go to sort your data whether you
> have headings or not? 
>
> Excel is not a database management system, so you have to get used to the
> fact that Excel has kind of a wild-west, lawless attitude (both in general
> and in handling data). 
>
> You can clue Excel that your headings are headings by formatting them in
> bold and/or underline.  Excel uses various (undocumented) clues to make 
> it's
> educated guesses.  You can always override Excel's guesses when it does 
> make
> them, so it's not a huge deal either way. 
>
> The exception is in Excel 2007+ if you use the Table feature I mentioned
> previously: the first row of the table must have headings, and Excel knows
> they are headings.  You can refer to columns by column name when working
> with Tables. 
>
> Asa 
>
>

-- 
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

Re: $$Excel-Macros$$ Excel formula help needed

[Kris]

OK. In B12 and copied down & across,

=IF(COLUMNS($A12:B12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(B$12:B12),MATCH($H$4,INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A4:i4"),0)+COLUMNS($B12:B12)-1),"")

Kris


>

-- 
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

Re: $$Excel-Macros$$ कविता: अपने E xcel-Macro ग्रुप का उम्र,अब 5 स ाल हो गया.****** FIVE YEARS COMPLETION******TH ANK YOU******

[chhajersandeep]

After reading the translation I just want to say...
3 cheers for Excel macros group, Noorain for his original master piece and 
avishek for ur spellbound translation!!
Hip Hip Hurrah!!

Sandeep Chhajer. 
Sent on my BlackBerry® from Vodafone

-Original Message-
From: Abhishek Jain 
Sender: excel-macros@googlegroups.com
Date: Fri, 23 Mar 2012 19:15:27 
To: 
Reply-To: excel-macros@googlegroups.com
Cc: Don Guillett
Subject: Re: $$Excel-Macros$$ कविता: अपने E
xcel-Macro ग्रुप का उम्र,अब 5 स
ाल हो गया.** FIVE YEARS COMPLETION**TH
ANK YOU**

Here, Don...

Where the population of excel lovers is very high
Where complete freedom is given to ask and reply
Following the posts of which many careers were happily told
That excel-macro group, my friends, is now 5 years old..

Be it dusk, dawn, day or night...
Posts keep raining just right...
This garden is decorated with flowers of talent...
Here happens cold wars with formulas of excel...

Logic is cultivated here in the fields of solutions...
Here, competition is mainly for offering solutions...
One got lucky be having which group's hold...
That excel-macro group, my friends, is now 5 years old..

Legends like Haseed, Sam, Don, Ashish reside here...
Man of BT Krishna give the world their pride here
Asa, Rajan, Dilip, Maries are the solitares...
Venkat and Sunny are the known volunteers

Many more wonders are also a part of this prize
This garden is nourished by Ayush's expertise
The group which has now become excellent in *bold*...
That excel-macro group, my friends, is now 5 years old..

Sorry for terrible translationits not easy to reproduce a
masterpiece

2012/3/23 dguillett1 

>   From the comments, I only wish I could read it.??
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* NOORAIN ANSARI 
> *Sent:* Thursday, March 22, 2012 1:42 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5
> साल हो गया.** FIVE YEARS COMPLETION**THANK YOU**
>
>  जहाँ Excel के दीवानों की,  है बहूत घनी आबादी.
> जहाँ Question,Answer करने की,है खूब आज़ादी.
> जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो  गया.
> दोस्तों उस अपने Excel-Macro ग्रुप का उम्र,  अब 5 साल हो गया.
> चाहे सुबह हो या शाम, चाहे दिन हो या रात.
> हर समय होती है यहाँ पोस्टिंग की बरसात.
>ये उपवन सजा है दोस्तों, कई Talented फूलों से.
>  यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से.
> Logic की खेती होती है यहाँ solutions के खलिहानों में.
> यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में..
>जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया.
>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
> *Haseeb,SAM,DON,Ashish* जैसी हस्ती यहाँ पे बसती है.
> Man of BT *Krishna* के solution को दुनिया तरसती है.
>   *ASA,Rajan,Dilip,Maries* सब के सब कोहिनूर है.
>   *Venkat,Sunny,Abhishekh* भी कम नहीं मशहूर है.
> और भी यहाँ बहूत सारी शख्सियत है निराली.
> *Ayush* बाबू करते है इस बगीया  की रखवाली.
>ये  forum  अब मिशाल नहीं रहा, बल्कि बेमिशाल हो
> गया.
>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  ** *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.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
>
> --
> 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 w

Re: $$Excel-Macros$$ Excel formula help needed

[hilary lomotey]

i think i get excited over the first few trials but i just realised a few
bug .the figures  doesnt match the years when you for instance select a
year to view

On Fri, Mar 23, 2012 at 3:41 PM, hilary lomotey  wrote:

> Kris, this solution is spot  on. thanks working to perfection
>
>
> On Fri, Mar 23, 2012 at 3:33 PM, Kris  wrote:
>
>> Hi
>>
>> on Sheet1
>>
>> In D2:D5
>>
>>  FML  SIC  GCB  GGBL
>> and define the range *'ShtName*'
>>
>> Define B2 '*SheetSelected*'
>>
>> In A12 and copied down & across on P&L(2)
>>
>>
>> =IF(COLUMNS($A12:A12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(A$12:A12),COLUMNS($A12:A12)),"")
>>
>> Kris
>>
>>>
>>>  --
>> 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
>>
>
>

-- 
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

Re: $$Excel-Macros$$ Excel formula help needed

[hilary lomotey]

Kris, this solution is spot  on. thanks working to perfection

On Fri, Mar 23, 2012 at 3:33 PM, Kris  wrote:

> Hi
>
> on Sheet1
>
> In D2:D5
>
>  FML  SIC  GCB  GGBL
> and define the range *'ShtName*'
>
> Define B2 '*SheetSelected*'
>
> In A12 and copied down & across on P&L(2)
>
>
> =IF(COLUMNS($A12:A12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(A$12:A12),COLUMNS($A12:A12)),"")
>
> Kris
>
>>
>>  --
> 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
>

-- 
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

Re: $$Excel-Macros$$ Excel formula help needed

[Kris]

Hi

on Sheet1

In D2:D5 

 FML  SIC  GCB  GGBL 
and define the range *'ShtName*'

Define B2 '*SheetSelected*'

In A12 and copied down & across on P&L(2)

=IF(COLUMNS($A12:A12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(A$12:A12),COLUMNS($A12:A12)),"")

Kris

>
>

-- 
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

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

[NOORAIN ANSARI]

Dear Abhishek,

Excellent, Mind blowing translation...
Thank you very much dear.

Now Don sir can comment.

-- 
Thanks & regards,
Noorain Ansari
 *http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*

2012/3/23 Abhishek Jain 

> Here, Don...
>
> Where the population of excel lovers is very high
> Where complete freedom is given to ask and reply
> Following the posts of which many careers were happily told
> That excel-macro group, my friends, is now 5 years old..
>
> Be it dusk, dawn, day or night...
> Posts keep raining just right...
> This garden is decorated with flowers of talent...
> Here happens cold wars with formulas of excel...
>
> Logic is cultivated here in the fields of solutions...
> Here, competition is mainly for offering solutions...
> One got lucky be having which group's hold...
> That excel-macro group, my friends, is now 5 years old..
>
> Legends like Haseed, Sam, Don, Ashish reside here...
> Man of BT Krishna give the world their pride here
> Asa, Rajan, Dilip, Maries are the solitares...
> Venkat and Sunny are the known volunteers
>
> Many more wonders are also a part of this prize
> This garden is nourished by Ayush's expertise
> The group which has now become excellent in *bold*...
> That excel-macro group, my friends, is now 5 years old..
>
> Sorry for terrible translationits not easy to reproduce a
> masterpiece
>
> 2012/3/23 dguillett1 
>
>>   From the comments, I only wish I could read it.??
>>
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* NOORAIN ANSARI 
>> *Sent:* Thursday, March 22, 2012 1:42 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5
>> साल हो गया.** FIVE YEARS COMPLETION**THANK YOU**
>>
>>  जहाँ Excel के दीवानों की,  है बहूत घनी आबादी.
>> जहाँ Question,Answer करने की,है खूब आज़ादी.
>> जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो  गया.
>> दोस्तों उस अपने Excel-Macro ग्रुप का उम्र,  अब 5 साल हो गया.
>> चाहे सुबह हो या शाम, चाहे दिन हो या रात.
>> हर समय होती है यहाँ पोस्टिंग की बरसात.
>>ये उपवन सजा है दोस्तों, कई Talented फूलों से.
>>  यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से.
>> Logic की खेती होती है यहाँ solutions के खलिहानों में.
>> यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में..
>>जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया.
>>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
>> *Haseeb,SAM,DON,Ashish* जैसी हस्ती यहाँ पे बसती है.
>> Man of BT *Krishna* के solution को दुनिया तरसती है.
>>   *ASA,Rajan,Dilip,Maries* सब के सब कोहिनूर है.
>>   *Venkat,Sunny,Abhishekh* भी कम नहीं मशहूर है.
>> और भी यहाँ बहूत सारी शख्सियत है निराली.
>> *Ayush* बाबू करते है इस बगीया  की रखवाली.
>>ये  forum  अब मिशाल नहीं रहा, बल्कि बेमिशाल हो
>> गया.
>>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
>>
>>
>>
>>
>> --
>> 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
>>
>> --
>> 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
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accura

$$Excel-Macros$$ Re: Simple VBA to Fill in blanks

[Kris]

Hi

Sub kTest()

On Error Resume Next
Columns(1).SpecialCells(4).FormulaR1C1 = "=r[-1]c"
Columns(1) = Columns(1).Value
On Error GoTo 0

End Sub

Kris

-- 
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

$$Excel-Macros$$ Re: Simple VBA to Fill in blanks

[Damimkader S. Meeran]

Hi,

Try the following code

Sub Fill_In_The_Blanks()
Dim i As Long
For i = 1 To 1
If Cells(i, 1) = "End" Then
Exit For
Else
If Cells(i, 1) = "" Then
Cells(i, 1) = Cells(i - 1, 1)
End If
End If
Next i
End Sub

The above code would require you to specify where the data ends.

Additionally, this could also be done without a VBA code using autofilters 
in Excel.

1. Select the Range to autofilter and press ALT+D+F+F
2. In the first blank cell below 101 in your example type a formula 
referencing the top cell using relative reference (without any dollar 
signs) and copy this formula.
3. In the column where you want to populate the missing values select 
blanks.
4. Paste this formula in the blanks cells. (Excel would paste the formula 
reference the top non blank cell for the rest of the cells).

Let me know if you need more help or if there are questions.

Regards,
Damimkader S. Meeran

On Friday, March 23, 2012 7:04:18 AM UTC+5:30, Jim Schug wrote:
>
> Hi,
> I'm nearly brain dead (tired) and can't think straight. I have a simple 
> issue. A macro to fill in blank values if found with the value from the 
> cell above.
>  
> For example
>  
> 101
>  
>  
>  
> 1015
>  
> Would fill the blank rows with 101 until the next number 1015 is found, 
> then it would use 1015 until another number...
>  
> A file with sample data is attached. Thanks in advance.
>  
>  
>  
>  
>  
>  
>

On Friday, March 23, 2012 7:04:18 AM UTC+5:30, Jim Schug wrote:
>
> Hi,
> I'm nearly brain dead (tired) and can't think straight. I have a simple 
> issue. A macro to fill in blank values if found with the value from the 
> cell above.
>  
> For example
>  
> 101
>  
>  
>  
> 1015
>  
> Would fill the blank rows with 101 until the next number 1015 is found, 
> then it would use 1015 until another number...
>  
> A file with sample data is attached. Thanks in advance.
>  
>  
>  
>  
>  
>  
>

-- 
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

$$Excel-Macros$$ Re: Insert rows with missing data

[Damimkader S. Meeran]

Hi,

Based on the explanation you provided. I've created a workbook which is 
attached herewith. Below are some of the requirements for this to function.

1. There is a sheet called "Time Groups" which contains all the time groups 
in the data once. And they should match the time groups in the data exactly.
2. Cell B2 contains a count of the groups. It is used by the macro to 
understand the number of unique groups in Times Groups.
3. Column F is a column which contains a formula which checks the count of 
the "Country" + "Year" + "Age Group", based on the explanation you provided 
it is seems that the combine CYA should appear 4 times if there are 4 
groups. The program uses this logic to populate the missing information.
4. Run the macro "Insert_Missing_Rows".
5. This has been written in Excel 2007. So if it is run on an earlier or 
later version of excel this might not function as certain VBA functions 
might not be available.

Please run it and let me know if this helps. Holler with questions.

The Code for reference 

Sub Insert_Missing_Rows()
Dim i As Long, j As Integer, k As Integer, cnt  As Integer, TempSheetName 
As String
cnt = 0

For i = 5 To 1000
If Cells(i, 1) <> "" Then
If Cells(i, 1) <> Cells(i + 1, 1) And Cells(i, 6) < Cells(1, 2) Then
Sheet1.Select
Diff = Cells(1, 2) - Cells(i, 6)

For j = 1 To Diff
Rows(i + 1 & ":" & i + 1).Select
Selection.Insert Shift:=xlDown
Next j

Sheets("Time Groups").Select
Sheets("Time Groups").Copy After:=Sheets(3)
TempSheetName = ActiveSheet.Name
Sheet1.Select

For k = i - (Cells(i, 6) - 1) To i
For j = 1 To Sheet1.Cells(1, 2)
If Cells(k, 4) = Sheets("" & TempSheetName).Cells(j, 1) 
Then
Sheets("" & TempSheetName).Select
Rows(j & ":" & j).Select
Selection.Delete Shift:=xlUp
Sheet1.Select
Exit For
End If
Next j
Next k

  Sheets("" & TempSheetName).Select
  Range("A1:A" & Diff).Select
  Selection.Copy
  Sheet1.Select
  Range("D" & i + 1).Select
  ActiveCell.PasteSpecial xlPasteAll

  Sheets("" & TempSheetName).Select
  Application.DisplayAlerts = False
  ActiveWindow.SelectedSheets.Delete
  Application.DisplayAlerts = True
  Sheet1.Select
  
  For k = i + 1 To i + (Diff)
Range("A" & k & ":C" & k).Select
Selection.FillDown
  Next k
  i = i + (Diff)
End If
Else
Exit For
End If
Next i

End Sub


Regards,
Damimkader S. Meeran




On Thursday, March 22, 2012 11:40:31 PM UTC+5:30, 0 1 wrote:
>
> I have data like so:
>
> Country Year AgeGroup Time  Count 
> A   05   10-6mo 10
> A   05   16-12mo5
> --​---
> B   05   10-6mo 12
> B   05   112-18mo   4
> B   05   118-24mo   75
>
> (I added the "-" dividing line just to help visualize things ... it's 
> not actually in the spreadsheet.)
>
> Every unique group - defined by unique concatenation of 
> Country+Year+AgeGroup should have four rows, one for each of these Time 
> intervals: 0-6mo, 6-12mo, 12-18mo, and 18-24mo. 
>
> The group defined by CountryA+05+1 is missing rows for 12-18 and 18-24.
> The group defined by CountryB+05+1 is missing rows for 6-12.
>
> How can I automatically detect when a unique group has < 4 rows, and then 
> insert the missing number of rows (doesn't matter where I insert them), 
> imputing the value for County, Year, AgeGroup, and Time (i.e., the Time 
> interval(s) that are missing). Count should get a value of 0. 
>
> So the code would build and add these three rows:
>
> Country Year AgeGroup Time  Count 
> A   05   112-18mo   0
> A   05   118-24mo   0
> B   05   16-12mo0
>
> Any suggestions?
>
>

-- 
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 

Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....

[dguillett1]

Glad to help

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

From: Indrajit $nai 
Sent: Thursday, March 22, 2012 5:59 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Need a small help, related to the Date and Time 
macro.

Thanks @ dguillett1.



On Thu, Mar 22, 2012 at 6:36 PM, dguillett1  wrote:

  Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Count > 1 _
  Or Target.Row < 2 Then Exit Sub
  If Target.Column = 1 Or Target.Column = 3 Then
  If Len(Application.Trim(Target)) > 0 Then _
  Target.Offset(, 1) = Now
  End If
  End Sub

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

  From: Indrajit $nai 
  Sent: Thursday, March 22, 2012 1:23 AM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ Need a small help, related to the Date and Time 
macro.

  @ dguillett1, PFA for your reference. 



  On Thu, Mar 22, 2012 at 4:28 AM, dguillett1  wrote:

Without seeing what you want with an example I can’t help

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

From: Indrajit $nai 
Sent: Wednesday, March 21, 2012 5:21 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Need a small help, related to the Date and 
Time macro.

Thanks @ Ranjan, but I don't track it in MS-Access File, can you 
incorporate this codes for MS-Excel?

Thanks @ dguillett1, but I'm not able to use the same code for Logout time 
tracking in a different column, can you please help me once again?

@ Abdulgani Shaikh, I have attached the same file in .xls format.




On Wed, Mar 21, 2012 at 11:12 PM, Rajan_Verma  
wrote:



  It’s a old post on this group ,I have created a small tool to track punch 
in and punch out Time , hope it can help.



  ‘=

  Hi Lokesh,

  I am attaching Two files here..

  1). Save Access file at  Shared Location.

  2). In Code Module Replace Thisworkbook.Path with shared Path

  3). Fill AllEmpID table in Database with EMPID for validation.



  ObjConnection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data 
Source=" & ThisWorkbook.Path & "\table.accdb" & ";"



  ‘=





  Regards

  Rajan





  From: excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai
  Sent: Mar/Wed/2012 03:17


  To: excel-macros@googlegroups.com
  Subject: $$Excel-Macros$$ Need a small help, related to the Date and Time 
macro.


  Hi All,



  Need a small help from you all. I have attached a file with this mail. 
Now if you open the file you can see there is a button named Login, if you 
click on it, it will take the system time and date.

  There are two columns available, Name (Column A) and Login Time (Column 
B), now I want if the respective Column A is blank then it will not put the 
date and time in Column B, if there is a name in column A then only date and 
time will be captured in the column B, other wise it will give me a error 
message. If you have the code for the same then please provide me.

  Thanks in advance.

  -- 
  Indrajit
  talk2indra...@gmail.com 

  Disclaimer:
  This electronic message and any files transmitted with it are 
confidential and intended solely for the use of the individual or entity to 
whom they are addressed. If you are not the intended recipient you are hereby 
notified that any disclosure, copying, distribution or taking any action in 
reliance on the contents of this information is strictly prohibited and may be 
unlawful.
  -- 
  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

  -- 
  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 w

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

[Abhishek Jain]

Here, Don...

Where the population of excel lovers is very high
Where complete freedom is given to ask and reply
Following the posts of which many careers were happily told
That excel-macro group, my friends, is now 5 years old..

Be it dusk, dawn, day or night...
Posts keep raining just right...
This garden is decorated with flowers of talent...
Here happens cold wars with formulas of excel...

Logic is cultivated here in the fields of solutions...
Here, competition is mainly for offering solutions...
One got lucky be having which group's hold...
That excel-macro group, my friends, is now 5 years old..

Legends like Haseed, Sam, Don, Ashish reside here...
Man of BT Krishna give the world their pride here
Asa, Rajan, Dilip, Maries are the solitares...
Venkat and Sunny are the known volunteers

Many more wonders are also a part of this prize
This garden is nourished by Ayush's expertise
The group which has now become excellent in *bold*...
That excel-macro group, my friends, is now 5 years old..

Sorry for terrible translationits not easy to reproduce a
masterpiece

2012/3/23 dguillett1 

>   From the comments, I only wish I could read it.??
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* NOORAIN ANSARI 
> *Sent:* Thursday, March 22, 2012 1:42 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5
> साल हो गया.** FIVE YEARS COMPLETION**THANK YOU**
>
>  जहाँ Excel के दीवानों की,  है बहूत घनी आबादी.
> जहाँ Question,Answer करने की,है खूब आज़ादी.
> जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो  गया.
> दोस्तों उस अपने Excel-Macro ग्रुप का उम्र,  अब 5 साल हो गया.
> चाहे सुबह हो या शाम, चाहे दिन हो या रात.
> हर समय होती है यहाँ पोस्टिंग की बरसात.
>ये उपवन सजा है दोस्तों, कई Talented फूलों से.
>  यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से.
> Logic की खेती होती है यहाँ solutions के खलिहानों में.
> यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में..
>जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया.
>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
> *Haseeb,SAM,DON,Ashish* जैसी हस्ती यहाँ पे बसती है.
> Man of BT *Krishna* के solution को दुनिया तरसती है.
>   *ASA,Rajan,Dilip,Maries* सब के सब कोहिनूर है.
>   *Venkat,Sunny,Abhishekh* भी कम नहीं मशहूर है.
> और भी यहाँ बहूत सारी शख्सियत है निराली.
> *Ayush* बाबू करते है इस बगीया  की रखवाली.
>ये  forum  अब मिशाल नहीं रहा, बल्कि बेमिशाल हो
> गया.
>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  ** *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.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
>
> --
> 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
>

-- 
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 

$$Excel-Macros$$ SQL Query - Excel VBA

[amrahs k]

Hi Team,

Here I am posting a request for running sql queries in excel macro. I have
listed my queries below. Currently am running these queries manually. I
want these queries needs to be run automatically.

SELECT distinct AMRCostCtr
 FROM [SRT1].[RequestToolDev].[dbo].[vReqsocs]
a,[SRT1].[RequestToolDev].[dbo].[ReqMain] b
  where a.ReqID = b.ReqID and MainRequestNumber = '353817'

If the above query does not return a result then it should automatically
run the second query and then second query as shown below.

SELECT StationBranch
FROM [SRT1].RequestToolDev.dbo.ReqAMROOS
WHERE ReqID  in (select reqid from [SRT1].RequestToolDev.dbo.ReqMain
where mainrequestnumber = 353817)

if the above one fails then it should run for the third one which is given
below.

SELECT BillableStationBranch
FROM [SRT1].RequestToolDev.dbo.ReqAMRIMAC
WHERE ReqID  in (select reqid from [SRT1].RequestToolDev.dbo.ReqMain
where mainrequestnumber = 353817)

Please help me to get this done.

Thanks,
Sharma Krishnan

-- 
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

Re: $$Excel-Macros$$ Simple VBA to Fill in blanks

[dguillett1]

http://contextures.com/xlDataEntry02.html#Fill 

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

From: Jim Schug 
Sent: Thursday, March 22, 2012 8:34 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Simple VBA to Fill in blanks

Hi,
I'm nearly brain dead (tired) and can't think straight. I have a simple issue. 
A macro to fill in blank values if found with the value from the cell above.

For example

101



1015

Would fill the blank rows with 101 until the next number 1015 is found, then it 
would use 1015 until another number...

A file with sample data is attached. Thanks in advance.






-- 
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

-- 
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

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

[dguillett1]

From the comments, I only wish I could read it.??

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

From: NOORAIN ANSARI 
Sent: Thursday, March 22, 2012 1:42 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो 
गया.** FIVE YEARS COMPLETION**THANK YOU**

जहाँ Excel के दीवानों की,  है बहूत घनी आबादी.
जहाँ Question,Answer करने की,है खूब आज़ादी.
जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो  गया.
दोस्तों उस अपने Excel-Macro ग्रुप का उम्र,  अब 5 साल हो गया.
चाहे सुबह हो या शाम, चाहे दिन हो या रात.
हर समय होती है यहाँ पोस्टिंग की बरसात.
   ये उपवन सजा है दोस्तों, कई Talented फूलों से.
 यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से.
Logic की खेती होती है यहाँ solutions के खलिहानों में.
यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में..
   जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया. 
   दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
Haseeb,SAM,DON,Ashish जैसी हस्ती यहाँ पे बसती है.
Man of BT Krishna के solution को दुनिया तरसती है.
  ASA,Rajan,Dilip,Maries सब के सब कोहिनूर है.
  Venkat,Sunny,Abhishekh भी कम नहीं मशहूर है. 

और भी यहाँ बहूत सारी शख्सियत है निराली.
Ayush बाबू करते है इस बगीया  की रखवाली.
   ये  forum  अब मिशाल नहीं रहा, बल्कि बेमिशाल हो गया.  
 
   दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.



-- 

Thanks & regards,
Noorain Ansari
http://noorainansari.com/
http://excelmacroworld.blogspot.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

-- 
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

Re: $$Excel-Macros$$ Is there any short formula for this result

[dguillett1]

I would suggest a table such as with numbers in col 1 and d in col2 I col 3, 
etc (easier to change in future)
then use match index


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

From: LAKSHMAN PRASAD 
Sent: Friday, March 23, 2012 2:25 AM
To: excel-macros@googlegroups.com 
Cc: noorain.ans...@gmail.com 
Subject: $$Excel-Macros$$ Is there any short formula for this result

Dear Noorian and expert,
Plz see the attached file. Is there any short formula for this result
Regards
LAKSHMAN
9582279261
-- 
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

-- 
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

Re: $$Excel-Macros$$ Simple VBA to Fill in blanks

[Sanjib Chatterjee]

you can also assign the macro task

1 select column a
2 press f5
3 press special
4 select blank
5 ok
6 edit menue
7 press delete
8 shift cells up
ok


On Fri, Mar 23, 2012 at 7:04 AM, Jim Schug  wrote:

> Hi,
> I'm nearly brain dead (tired) and can't think straight. I have a simple
> issue. A macro to fill in blank values if found with the value from the
> cell above.
>
> For example
>
> 101
>
>
>
> 1015
>
> Would fill the blank rows with 101 until the next number 1015 is found,
> then it would use 1015 until another number...
>
> A file with sample data is attached. Thanks in advance.
>
>
>
>
>
>
>
> --
> 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
>



-- 
-

-- 
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

$$Excel-Macros$$ Re: Is there any short formula for this result

[CoRe]

Hello, 

PFA!


Good luck

On Friday, March 23, 2012 9:25:33 AM UTC+2, lakshm...@yahoo.com wrote:
>
> Dear Noorian and expert,
> Plz see the attached file. Is there any short formula for this result
> Regards
> LAKSHMAN
> 9582279261
>

-- 
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


Due+Amount(CoRe Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Excel formula help needed

[hilary lomotey]

Hi Maries

The formula works perfectly for SIC, however for GCB and GGBL, it seems to
pick the same figures for all the years. with FML , its picking the an
incorrect figures.

kindly verify for me. thanks

On Thu, Mar 22, 2012 at 8:30 PM, Maries  wrote:

> GCB & GGBL Error Rectified. PFA latest.
>
>
> On Thu, Mar 22, 2012 at 11:11 PM, hilary lomotey wrote:
>
>> genius Maries
>>
>> Great solution. works to perfection.  thanks boss
>>
>> On Thu, Mar 22, 2012 at 3:56 PM, Maries  wrote:
>>
>>> HI,
>>>
>>> Please find the attached file of Revised one. Ignore Previous one.
>>>
>>> Regards,
>>>
>>> MARIES.
>>>
>>>
>>> On Thu, Mar 22, 2012 at 7:07 PM, Maries  wrote:
>>>
 Hi,

 PFA.

 =IF(B11="","",CHOOSE(Sheet1!$B$2,FML!B5,SIC!B5,GCB!B5,GGBL!B5))

 Regards,

 MARIES



 On Thu, Mar 22, 2012 at 6:00 PM, hilary lomotey wrote:

> PERFECT, exactly what i needed. tx so much.
>
> sorry i didnt mention this earlier in my mail, how do i handle a
> situation where you have you have figures under those years, how do the
> figures manipulate them with formulas for the right figures to appear 
> under
> the respective years
>
>
> On Thu, Mar 22, 2012 at 1:13 PM, Maries  wrote:
>
>> HI,
>>
>> PFA.
>>
>> Regards,
>>
>> MARIES.
>>
>> On Thu, Mar 22, 2012 at 4:40 PM, hilary lomotey wrote:
>>
>>> Hi Oxford Excel Gurus
>>>
>>> In the fill attached sheet "P&L" i have been able to write a formula
>>> that can show how many number of years i want to view the report ie if i
>>> want to see 5 years report i will select from the drop down, and so 
>>> forth.
>>> and the number o years specified will show
>>>
>>> In the 2nd sheet ie "P&L (2)" I have also written a formula to  view
>>> which year the report should begin from say year 2007 , or 2008 etc.
>>>
>>> the problem is how to combine these two formulae into one when i can
>>> have a situation where i can select a particular year to view the report
>>> and specify how many years from there to view the report.
>>>
>>> kindly help with a formula. tx
>>>
>>>
>>>  --
>>> 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
>>>
>>
>>  --
>> 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
>>
>
>  --
> 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

RE: $$Excel-Macros$$ Handling Large Blocks of Text in Excel

[Asa Rossoff]

Hi Padre,

Just enable Resize Shape to Fit Text in the properties.

 

You might also consider using a userform and Active X Text Box, which has
scroll bars available.

See Debra Dalgleish's tutorial at
www.contextures.com/exceltextboxformat.html for more on the worksheet Text
Box.

 

Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Padre
Sent: Monday, March 19, 2012 10:50 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Handling Large Blocks of Text in Excel

 

I have a number of different Excel front-ends that I use to extract
information from various corporate database systems. One area of
frustration arises when I am pulling large blocks of text from various note
fields on various SQL servers.I often hit the Excel's built in text
limits for individual cells.  As a work around I starting using Excel's
built in Text Boxes which works, however I am struggling with dynamically
resizing these text boxes.  I want to keep a certain width and adjust the
length/height of the text boxes to accommodate varying amounts of text (this
is required for printouts containing various information stored in cells +
the entire text entry)

OR 

If there are alternative method besides Text Boxes, I'm all ears...

Thank  you in advance for your help.

-- 
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

-- 
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

$$Excel-Macros$$ RE: So is it common for even an easy question on the forum to not get answered?

[Asa Rossoff]

Hi H.,
Not sure how you are determining that Excel knows or doesn't know your
column headings are column headings.

Do you mean it guesses correctly when you go to sort your data whether you
have headings or not?

Excel is not a database management system, so you have to get used to the
fact that Excel has kind of a wild-west, lawless attitude (both in general
and in handling data).

You can clue Excel that your headings are headings by formatting them in
bold and/or underline.  Excel uses various (undocumented) clues to make it's
educated guesses.  You can always override Excel's guesses when it does make
them, so it's not a huge deal either way.

The exception is in Excel 2007+ if you use the Table feature I mentioned
previously: the first row of the table must have headings, and Excel knows
they are headings.  You can refer to columns by column name when working
with Tables.

Asa

-Original Message-
From: Domain Admin [mailto:domainqu...@gmail.com] 
Sent: Wednesday, March 21, 2012 4:49 PM
To: Asa Rossoff
Subject: So is it common for even an easy question on the forum to not get
answered?

I posted this question a day ago which I assumed many would be able to
answer but no replies at all



Excel does a very good job of knowing row 1 is column names even if
the data type is the same for the entire column.
But it is not always correct.   If I insert columns of numbers then
insert a new row1 and put in text headers it considers them
column names even if the entire column is set to text.  But if I
insert text data then insert a new row of text names it thinks they
are data.  There must be some way to tell it the row is column names
both from the interface and programmatically I would think.
Does anyone know the rules here and how to directly set if col names or not?

-- 
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

$$Excel-Macros$$ Is there any short formula for this result

[LAKSHMAN PRASAD]

Dear Noorian and expert,
Plz see the attached file. Is there any short formula for this result
Regards
LAKSHMAN
9582279261

-- 
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


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

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

[Kal xcel]

Dear Brother,

 I am really falling short of words to describe your dexterity. Your all
poems are simply mesmerizing and exhibit your talent not only over IT, but
in Literature too.

 Keep on charming all of us with your talent.

 Kalyan

2012/3/23 Venkat CV 

> Dear Noorain,
>
> Superb
>
> *Best Regards,*
> *Venkat *
> *Chennai*
>
>
> 2012/3/23 NOORAIN ANSARI 
>
>>  जहाँ Excel के दीवानों की,  है बहूत घनी आबादी.
>> जहाँ Question,Answer करने की,है खूब आज़ादी.
>> जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो  गया.
>> दोस्तों उस अपने Excel-Macro ग्रुप का उम्र,  अब 5 साल हो गया.
>> चाहे सुबह हो या शाम, चाहे दिन हो या रात.
>> हर समय होती है यहाँ पोस्टिंग की बरसात.
>>ये उपवन सजा है दोस्तों, कई Talented फूलों से.
>>  यहाँ शीत युद्ध चलती है अक्सर Excel के फर्मुलों से.
>> Logic की खेती होती है यहाँ solutions के खलिहानों में.
>> यहाँ मदद की होड़ मची रहती है EXCEL के दिवानो में..
>>जिसने पा लिया साथ इस ग्रुप का, समझो निहाल हो गया.
>>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
>> *Haseeb,SAM,DON,Ashish* जैसी हस्ती यहाँ पे बसती है.
>> Man of BT *Krishna* के solution को दुनिया तरसती है.
>>   *ASA,Rajan,Dilip,Maries* सब के सब कोहिनूर है.
>>   *Venkat,Sunny,Abhishekh* भी कम नहीं मशहूर है.
>> और भी यहाँ बहूत सारी शख्सियत है निराली.
>> *Ayush* बाबू करते है इस बगीया  की रखवाली.
>>ये  forum  अब मिशाल नहीं रहा, बल्कि बेमिशाल हो गया.
>>
>>दोस्तों अपने Excel-Macro ग्रुप का उम्र अब 5 साल हो गया.
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  ** *http://noorainansari.com/*
>> *http://excelmacroworld.blogspot.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
>>
>
>
>
> --
>  *
> *
> *
> *
> *
> *
>
>
> --
> 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
>



-- 
*Kalyan Chattopadhyay*

*Executive Sales Coordinator*
*R. S. H. Pvt. Ltd.*

-- 
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