Re: $$Excel-Macros$$ Shortcut key to Align Left, Right & Center in Excel

[Shreedar]

Hi, Please find the shortcuts you are looking for...Alt+H+AL for Left 
Alignments, Alt+H+AC for Center Alignments, & Alt+H+AR for Right Alignments

Regards...Shreedar

On 30-Jul-2012, at 8:57 AM, "Anjali ."  wrote:

> Hi Group,
> Can any one please help me to know how to align left, right and center in a 
> cell in excel file through shortcut key.
> 
> 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
>  
> To unsubscribe, send a blank email to 
> excel-macros+unsubscr...@googlegroups.com
>  
>  

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Download MS Office 2013 (Trial version)

[NOORAIN ANSARI]

Dear Group,

Use the following links to download, MS Office 2013 64 Bit & 32 Bit - 60
days trial version:

http://kat.ph/microsoft-office-professional-2013-with-serial-t6517550.html

http://kat.ph/microsoft-office-preview-2013-standalone-installer-x86-tejasnair-t6513972.html

http://www.hacktrix.com/download-microsoft-office-2013-now

N.B. You need a torrent download client, like Utorrent, Bitcomet etc.



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

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Multiple Versions of Excel

[Anoop K Sharma]

Hi Ashish,

You won't face any version clash issue after installing Office 2010.
Installing process will offer you to keep your previous version of Office.
However the Outlook will be upgraded.

Regards,
Anoop


On Mon, Jul 30, 2012 at 1:43 AM, David Grugeon  wrote:

> What do you mean by "sharing"? Do you mean you want someone to support you
> illegally installing a copy of office you do not have a licence for? That
> is theft.
>
>
> On Wednesday, 30 May 2012, Ashish Pradhan wrote:
>
>>
>> Hey
>>
>> Thanks Don and CoRe for the prompt replies. Am going ahead with the
>> multiple installations. Hope all goes well. :-)
>>
>> Thanks
>>
>> Ashish Pradhan
>>
>>
>> On 29-05-2012 20:25, dguillett1 wrote:
>>
>>  Just install in a directory OTHER than the previous verion. ie:
>> MyExcel2010
>>
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Ashish Pradhan
>> *Sent:* Tuesday, May 29, 2012 9:16 AM
>> *To:* Excel Macros
>> *Subject:* $$Excel-Macros$$ Multiple Versions of Excel
>>
>>
>> Hello
>>
>> I currently have installed Excel 2003 on my machine. However would also
>> like to install 2010 now. If I change the default destination path, will it
>> create any problems? Will I be easily able to open any excel file without
>> any "Version Clash issues"
>>
>> I understand that very recently, someone suggested on this forum that
>> multiple versions can be installed. Has anyone ever faced any "Version
>> Clash" issues before?
>>
>>  --
>> Thanks
>>
>> Ashish Pradhan
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
> --
> Regards
> David Grugeon
>
>  --
> 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 f

$$Excel-Macros$$ Shortcut key to Align Left, Right & Center in Excel

[Anjali .]

Hi Group,
Can any one please help me to know how to align left, right and center in a
cell in excel file through shortcut key.

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Multiple Versions of Excel

[David Grugeon]

What do you mean by "sharing"? Do you mean you want someone to support you
illegally installing a copy of office you do not have a licence for? That
is theft.

On Wednesday, 30 May 2012, Ashish Pradhan wrote:

>
> Hey
>
> Thanks Don and CoRe for the prompt replies. Am going ahead with the
> multiple installations. Hope all goes well. :-)
>
> Thanks
>
> Ashish Pradhan
>
>
> On 29-05-2012 20:25, dguillett1 wrote:
>
>  Just install in a directory OTHER than the previous verion. ie:
> MyExcel2010
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Ashish Pradhan
> *Sent:* Tuesday, May 29, 2012 9:16 AM
> *To:* Excel Macros
> *Subject:* $$Excel-Macros$$ Multiple Versions of Excel
>
>
> Hello
>
> I currently have installed Excel 2003 on my machine. However would also
> like to install 2010 now. If I change the default destination path, will it
> create any problems? Will I be easily able to open any excel file without
> any "Version Clash issues"
>
> I understand that very recently, someone suggested on this forum that
> multiple versions can be installed. Has anyone ever faced any "Version
> Clash" issues before?
>
>  --
> Thanks
>
> Ashish Pradhan
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to
>
>  --
> 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@googlegroups.com');>
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com  'excel-macros%2bunsubscr...@googlegroups.com');>



-- 
Regards
David Grugeon

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To 

RE: $$Excel-Macros$$ watch help

[danial mansoor]

ya u r rite,i though abt trace dependant and add watch feature but it takes 
lots of time,any short cut?


> Date: Sun, 29 Jul 2012 07:45:48 +0530
> Subject: Re: $$Excel-Macros$$ watch help
> From: samde...@gmail.com
> To: excel-macros@googlegroups.com
> 
> by effect you mean how other sheets are linked to that sheet by
> formula, why don't you try looking at the trace dependants feature in
> the formula tab of Excel.
> 
> 
> On 7/29/12, danial mansoor  wrote:
> >
> >
> > Dear experts,
> >
> > i have bunch of sheets which was created by someone else,i have one input
> > sheet  it effects many sheets is there a way where i could see my input
> > effects  which sheets results?.is there any easy way?navigation on every
> > sheet is quite hectic could any one suggest easy way or macro or some thing
> > like that?
> >
> > i just wanted to see my input effect which sheets in one glance is there a
> > way i could do this?
> >
> >
> > regarads,
> >
> > daniyal mansoor
> > 
> >
> > --
> > FORUM RULES (986+ members already BANNED for violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> > not get quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
> >
> > --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > To unsubscribe, send a blank email to
> > excel-macros+unsubscr...@googlegroups.com
> >
> >
> >
> 
> 
> -- 
> Sam Mathai Chacko
> 
> -- 
> FORUM RULES (986+ members already BANNED for violation)
> 
> 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
> Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not 
> get quick attention or may not be answered.
> 
> 2) Don't post a question in the thread of another member.
> 
> 3) Don't post questions regarding breaking or bypassing any security measure.
> 
> 4) Acknowledge the responses you receive, good or bad.
> 
> 5)  Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
> 
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
> 
> --
> To post to this group, send email to excel-macros@googlegroups.com
> 
> To unsubscribe, send a blank email to 
> excel-macros+unsubscr...@googlegroups.com
> 
> 
  

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Pivot table with chart represent

[ashish koul]

hi

why do u want to use vba . simple make the dynamic range and add it to the
source of pivot  whenever u will add or delete the data in source sheet it
will automatically get updated

try the attachment

visit to know more abt

http://www.contextures.com/xlPivot01.html








On Sun, Jul 29, 2012 at 9:07 PM, (%Allmydreams%) <
yogananda.mutha...@gmail.com> wrote:

> Hi,
>
> I have recorded th macro for creating pivot table with pivot chart for the
> 1st time and running for 2nd time gives me an error - Run time error 5
>
> Please help in changing the *vba* code as shows in Sheet("Summary") with
> 1 click button to go.
>
> Request everyone to pls have this resolved asap.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Pivot Table and Chart.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Pivot table with chart represent

[(%Allmydreams%)]

Hi,

I have recorded th macro for creating pivot table with pivot chart for the 
1st time and running for 2nd time gives me an error - Run time error 5

Please help in changing the *vba* code as shows in Sheet("Summary") with 1 
click button to go.

Request everyone to pls have this resolved asap.

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com




Pivot Table and Chart.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re: Amend code to copy worksheets to new Worksheets upon selection via drop down lists.

[skyping1]

Hi David,

Thank you for the file...it looks exactly what I'm after!!!

Many thanks for all your help!

Kevin 


>

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Introduce Yourself !!

[Aju Chacko]

Dear fellow members,
 My name is Aju v chacko (41),I am
working in MRF TYRES,Kottayam,Kerala as SAP coordinator.I have moderate
knowledge in excel macros & I received great help from this community.My
main hobby is reading & I have created a RECONCILIATION TOOL in using VBA,I
will share it you within few days.
 Thank You
Aju V Chacko

On Sat, Jun 9, 2012 at 12:51 AM, Ayush Jain  wrote:

> Hey all new and current posters,
>
> Welcome to excel group,one of the largest online community of excel Fans!
>
> I hope you enjoy your time here & find this forum to be a friendly and
> knowledgeable community. Please feel free to post a small introduction, a
> friendly hello or tell us a bit about yourself. Why not tell us where are
> you from, what you do, what your interests are, how old you are, which is
> your favourite excel site or blog is or anything else that comes to mind!
>
> Thanks for your time
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

RE: $$Excel-Macros$$ Multiple Versions of Excel

[Rajan_Verma]

What do you mean by Genuine ?

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rao
Sent: 29 July 2012 7:36
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Multiple Versions of Excel

 

Hey, Do u have the genuine Excel 2010?? if yes, Do you mine sharing this.

 

 

Cheers,

Prabhakar

On Tue, May 29, 2012 at 10:09 PM, Ashish Pradhan 
wrote:


Hey

Thanks Don and CoRe for the prompt replies. Am going ahead with the multiple
installations. Hope all goes well. :-) 



Thanks
 
Ashish Pradhan


On 29-05-2012 20:25, dguillett1 wrote: 

Just install in a directory OTHER than the previous verion. ie: MyExcel2010

 

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

 

From: Ashish Pradhan   

Sent: Tuesday, May 29, 2012 9:16 AM

To: Excel Macros   

Subject: $$Excel-Macros$$ Multiple Versions of Excel

 


Hello

I currently have installed Excel 2003 on my machine. However would also like
to install 2010 now. If I change the default destination path, will it
create any problems? Will I be easily able to open any excel file without
any "Version Clash issues"

I understand that very recently, someone suggested on this forum that
multiple versions can be installed. Has anyone ever faced any "Version
Clash" issues before?




-- 
Thanks
 
Ashish Pradhan

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
 

 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners 

Re: $$Excel-Macros$$ Multiple Versions of Excel

[rao]

Hey, Do u have the genuine Excel 2010?? if yes, Do you mine sharing this.


Cheers,
Prabhakar

On Tue, May 29, 2012 at 10:09 PM, Ashish Pradhan wrote:

>
> Hey
>
> Thanks Don and CoRe for the prompt replies. Am going ahead with the
> multiple installations. Hope all goes well. :-)
>
> Thanks
>
> Ashish Pradhan
>
>
> On 29-05-2012 20:25, dguillett1 wrote:
>
>  Just install in a directory OTHER than the previous verion. ie:
> MyExcel2010
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Ashish Pradhan 
> *Sent:* Tuesday, May 29, 2012 9:16 AM
> *To:* Excel Macros 
> *Subject:* $$Excel-Macros$$ Multiple Versions of Excel
>
>
> Hello
>
> I currently have installed Excel 2003 on my machine. However would also
> like to install 2010 now. If I change the default destination path, will it
> create any problems? Will I be easily able to open any excel file without
> any "Version Clash issues"
>
> I understand that very recently, someone suggested on this forum that
> multiple versions can be installed. Has anyone ever faced any "Version
> Clash" issues before?
>
>  --
> Thanks
>
> Ashish Pradhan
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubsc

Re: $$Excel-Macros$$ Re: Pls tell me more about Areas Property of the Range

[Sam Mathai Chacko]

variable rng used as obj.. revised

Sub T()

Dim rngCluster As Range
Dim rng As Range

Set rngCluster = Application.Union(Range("A1:C3"), Range("D5:E10"))
For Each rng In rngCluster.Areas
MsgBox rng.Address
Next rng

End Sub

On Sun, Jul 29, 2012 at 5:05 PM, Sam Mathai Chacko wrote:

> Prince,
>
> I missed the part about selecting to contiguous cell groups. And come to
> think of it, it doesn't necessarily have to be non-empty.
>
> Try this
>
> Sub T()
>
> Dim rngCluster As Range
> Dim rng As Range
>
> Set rngCluster = Application.Union(Range("A1:C3"), Range("D5:E10"))
> MsgBox rngCluster.Areas.Count
> For Each obj In rngCluster.Areas
> MsgBox obj.Address
> Next obj
>
> End Sub
>
> Regards,
> Sam Mathai Chacko
>
>
> On Sun, Jul 29, 2012 at 4:33 PM, Prince Dubey wrote:
>
>> Hi Sam,
>>
>>
>> Thanks for the reply,
>> I did the same as you have mentioned in your post i created a range A1:E9
>> in which i inserted data from A1:C3 and then D5:E9 and i wrote
>> Sheet1.range(A1:E9).Areas(1).Address but it returned $A$1:$E$9  as address
>> and in case of Sheet1.range(A1:E9).Areas(1).count it returned 1  .
>>
>>
>> regards
>>
>> On Sunday, 29 July 2012 00:28:46 UTC+5:30, Prince Dubey wrote:
>>>
>>> Hi All,
>>>
>>>
>>> I want to know more about Areas property of the range object,
>>>
>>> If I write:  Range("A1").Areas(1) it return text inside that range  but
>>> i m not able to to understand what is it. And further if we write it like
>>> range("A1").Areas.Count or range("A1").Areas.Creator
>>> or range("A1").Areas.Parent , I m not able understand these.
>>>
>>>
>>> Actually i m confused about these statements because i was expecting
>>> that areas will return Areas ie # on of cells in that range, But it is not
>>> in actual.
>>>
>>>
>>> Prince Dubey.
>>>
>>>
>>>
>>>
>>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
> --
> Sam Mathai Chacko
>



-- 
Sam Mathai Chacko

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Re: Pls tell me more about Areas Property of the Range

[Sam Mathai Chacko]

Prince,

I missed the part about selecting to contiguous cell groups. And come to
think of it, it doesn't necessarily have to be non-empty.

Try this

Sub T()

Dim rngCluster As Range
Dim rng As Range

Set rngCluster = Application.Union(Range("A1:C3"), Range("D5:E10"))
MsgBox rngCluster.Areas.Count
For Each obj In rngCluster.Areas
MsgBox obj.Address
Next obj

End Sub

Regards,
Sam Mathai Chacko

On Sun, Jul 29, 2012 at 4:33 PM, Prince Dubey wrote:

> Hi Sam,
>
>
> Thanks for the reply,
> I did the same as you have mentioned in your post i created a range A1:E9
> in which i inserted data from A1:C3 and then D5:E9 and i wrote
> Sheet1.range(A1:E9).Areas(1).Address but it returned $A$1:$E$9  as address
> and in case of Sheet1.range(A1:E9).Areas(1).count it returned 1  .
>
>
> regards
>
> On Sunday, 29 July 2012 00:28:46 UTC+5:30, Prince Dubey wrote:
>>
>> Hi All,
>>
>>
>> I want to know more about Areas property of the range object,
>>
>> If I write:  Range("A1").Areas(1) it return text inside that range  but i
>> m not able to to understand what is it. And further if we write it like
>> range("A1").Areas.Count or range("A1").Areas.Creator
>> or range("A1").Areas.Parent , I m not able understand these.
>>
>>
>> Actually i m confused about these statements because i was expecting that
>> areas will return Areas ie # on of cells in that range, But it is not in
>> actual.
>>
>>
>> Prince Dubey.
>>
>>
>>
>>
>>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
Sam Mathai Chacko

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: Workdays formula help required

[Prince Dubey]

Hi Vikram,

The Workday() function return the next working day after the specified no 
of days it excludes the weekends and the days you have specified as the 
holidays.

for example if i write: =WORKDAY(DATEVALUE("11/1/2012"),10) the will return 
11/15/2012 because there will be weekends on 3,4 and 10 ,11 nov.

And also pls note:

Dates should be entered by using the DATE function 
A positive value for days yields a future date; a negative value yields a 
past date. 
Prince dubey

Hope this will help you .

Regards


On Sunday, 29 July 2012 13:33:42 UTC+5:30, vic kumar wrote:
>
> H, 
>
> Please help regarding how to implement workdays formula. 
>
>
> -- 
> Regards, 
>
> Vikram Ahuja 
>

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: Pls tell me more about Areas Property of the Range

[Prince Dubey]

Hi Sam,


Thanks for the reply,
I did the same as you have mentioned in your post i created a range A1:E9 
in which i inserted data from A1:C3 and then D5:E9 and i wrote 
Sheet1.range(A1:E9).Areas(1).Address but it returned $A$1:$E$9  as address 
and in case of Sheet1.range(A1:E9).Areas(1).count it returned 1  . 


regards

On Sunday, 29 July 2012 00:28:46 UTC+5:30, Prince Dubey wrote:
>
> Hi All,
>
>
> I want to know more about Areas property of the range object,
>
> If I write:  Range("A1").Areas(1) it return text inside that range  but i 
> m not able to to understand what is it. And further if we write it like 
> range("A1").Areas.Count or range("A1").Areas.Creator 
> or range("A1").Areas.Parent , I m not able understand these.
>
>
> Actually i m confused about these statements because i was expecting that 
> areas will return Areas ie # on of cells in that range, But it is not in 
> actual.
>
>
> Prince Dubey. 
>
>
>
>
>

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: Amend code to copy worksheets to new Worksheets upon selection via drop down lists.

[skyping1]

Hi David... Once again thanks for your response, but no workbook attached, 
so I cant test your code!!!

Please could you resend?

>
>

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Re: Amend code to copy worksheets to new Worksheets upon selection via drop down lists.

[skyping1]

Hi David... Once again thanks for your response, but no workbook attached, 
so I cant test your code!!!

Please could you resend?

On Sunday, July 29, 2012 11:27:01 AM UTC+1, skyping1 wrote:
>
>
>
> On Thursday, July 26, 2012 6:57:03 PM UTC+1, skyping1 wrote:
>>
>> Need your help once again!!!
>>
>> A previous project needs to be updated and I simply cannot my head around 
>> it.
>>
>> I have a workbook that currently comprises of 5 worksheets, 3 of which 
>> are relating to my problem and are hidden. These are called Link1, Link2, 
>> and Link3. 
>>
>> The initial concept of the project was to generate new worksheets 
>> labelled from the contents of c12:c31 on the Intro worksheet. This works 
>> fine…. see macro below:
>>
>> Private Sub GENERATE_Click()
>> On Error Resume Next
>> Call DeleteSheets
>> Dim MyCell As Range, MyRange As Range
>> Set MyRange = Sheets("Intro").Range("c12")
>> Set MyRange = Range(MyRange, MyRange.End(xlDown))
>> For Each MyCell In MyRange
>> Sheets.Add After:=Sheets(Sheets.Count) 'creates a new worksheet
>> Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet
>> Next MyCell
>> End Sub
>>
>> However, I have added another variable which is displayed in a drop down 
>> list in j12:j31, which relates to the content of these 3 new hidden sheets. 
>>
>> What I need to do is when generating the new sheets via the Generate 
>> macro, the corresponding selection in column J, will copy the relevant 
>> sheet (Link1, Link2, Link3 or nothing) to the new sheet with the 
>> corresponding name from column C.
>>
>> I really hope this is coherent (!!) and welcome any advice on this 
>> problem.
>>
>> Many thanks for looking.
>>
>>
> On Thursday, July 26, 2012 6:57:03 PM UTC+1, skyping1 wrote:
>>
>> Need your help once again!!!
>>
>> A previous project needs to be updated and I simply cannot my head around 
>> it.
>>
>> I have a workbook that currently comprises of 5 worksheets, 3 of which 
>> are relating to my problem and are hidden. These are called Link1, Link2, 
>> and Link3. 
>>
>> The initial concept of the project was to generate new worksheets 
>> labelled from the contents of c12:c31 on the Intro worksheet. This works 
>> fine…. see macro below:
>>
>> Private Sub GENERATE_Click()
>> On Error Resume Next
>> Call DeleteSheets
>> Dim MyCell As Range, MyRange As Range
>> Set MyRange = Sheets("Intro").Range("c12")
>> Set MyRange = Range(MyRange, MyRange.End(xlDown))
>> For Each MyCell In MyRange
>> Sheets.Add After:=Sheets(Sheets.Count) 'creates a new worksheet
>> Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet
>> Next MyCell
>> End Sub
>>
>> However, I have added another variable which is displayed in a drop down 
>> list in j12:j31, which relates to the content of these 3 new hidden sheets. 
>>
>> What I need to do is when generating the new sheets via the Generate 
>> macro, the corresponding selection in column J, will copy the relevant 
>> sheet (Link1, Link2, Link3 or nothing) to the new sheet with the 
>> corresponding name from column C.
>>
>> I really hope this is coherent (!!) and welcome any advice on this 
>> problem.
>>
>> Many thanks for looking.
>>
>>
> On Thursday, July 26, 2012 6:57:03 PM UTC+1, skyping1 wrote:
>>
>> Need your help once again!!!
>>
>> A previous project needs to be updated and I simply cannot my head around 
>> it.
>>
>> I have a workbook that currently comprises of 5 worksheets, 3 of which 
>> are relating to my problem and are hidden. These are called Link1, Link2, 
>> and Link3. 
>>
>> The initial concept of the project was to generate new worksheets 
>> labelled from the contents of c12:c31 on the Intro worksheet. This works 
>> fine…. see macro below:
>>
>> Private Sub GENERATE_Click()
>> On Error Resume Next
>> Call DeleteSheets
>> Dim MyCell As Range, MyRange As Range
>> Set MyRange = Sheets("Intro").Range("c12")
>> Set MyRange = Range(MyRange, MyRange.End(xlDown))
>> For Each MyCell In MyRange
>> Sheets.Add After:=Sheets(Sheets.Count) 'creates a new worksheet
>> Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet
>> Next MyCell
>> End Sub
>>
>> However, I have added another variable which is displayed in a drop down 
>> list in j12:j31, which relates to the content of these 3 new hidden sheets. 
>>
>> What I need to do is when generating the new sheets via the Generate 
>> macro, the corresponding selection in column J, will copy the relevant 
>> sheet (Link1, Link2, Link3 or nothing) to the new sheet with the 
>> corresponding name from column C.
>>
>> I really hope this is coherent (!!) and welcome any advice on this 
>> problem.
>>
>> Many thanks for looking.
>>
>>
> On Thursday, July 26, 2012 6:57:03 PM UTC+1, skyping1 wrote:
>>
>> Need your help once again!!!
>>
>> A previous project needs to be updated and I simply cannot my head around 
>> it.
>>
>> I have a workbook that currently comprises of 5 worksheets, 3 of which 
>> are relating to my problem and are hidden. These are called Link1, L

$$Excel-Macros$$ Re: Amend code to copy worksheets to new Worksheets upon selection via drop down lists.

[skyping1]

On Thursday, July 26, 2012 6:57:03 PM UTC+1, skyping1 wrote:
>
> Need your help once again!!!
>
> A previous project needs to be updated and I simply cannot my head around 
> it.
>
> I have a workbook that currently comprises of 5 worksheets, 3 of which are 
> relating to my problem and are hidden. These are called Link1, Link2, and 
> Link3. 
>
> The initial concept of the project was to generate new worksheets labelled 
> from the contents of c12:c31 on the Intro worksheet. This works fine…. see 
> macro below:
>
> Private Sub GENERATE_Click()
> On Error Resume Next
> Call DeleteSheets
> Dim MyCell As Range, MyRange As Range
> Set MyRange = Sheets("Intro").Range("c12")
> Set MyRange = Range(MyRange, MyRange.End(xlDown))
> For Each MyCell In MyRange
> Sheets.Add After:=Sheets(Sheets.Count) 'creates a new worksheet
> Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet
> Next MyCell
> End Sub
>
> However, I have added another variable which is displayed in a drop down 
> list in j12:j31, which relates to the content of these 3 new hidden sheets. 
>
> What I need to do is when generating the new sheets via the Generate 
> macro, the corresponding selection in column J, will copy the relevant 
> sheet (Link1, Link2, Link3 or nothing) to the new sheet with the 
> corresponding name from column C.
>
> I really hope this is coherent (!!) and welcome any advice on this problem.
>
> Many thanks for looking.
>
>
On Thursday, July 26, 2012 6:57:03 PM UTC+1, skyping1 wrote:
>
> Need your help once again!!!
>
> A previous project needs to be updated and I simply cannot my head around 
> it.
>
> I have a workbook that currently comprises of 5 worksheets, 3 of which are 
> relating to my problem and are hidden. These are called Link1, Link2, and 
> Link3. 
>
> The initial concept of the project was to generate new worksheets labelled 
> from the contents of c12:c31 on the Intro worksheet. This works fine…. see 
> macro below:
>
> Private Sub GENERATE_Click()
> On Error Resume Next
> Call DeleteSheets
> Dim MyCell As Range, MyRange As Range
> Set MyRange = Sheets("Intro").Range("c12")
> Set MyRange = Range(MyRange, MyRange.End(xlDown))
> For Each MyCell In MyRange
> Sheets.Add After:=Sheets(Sheets.Count) 'creates a new worksheet
> Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet
> Next MyCell
> End Sub
>
> However, I have added another variable which is displayed in a drop down 
> list in j12:j31, which relates to the content of these 3 new hidden sheets. 
>
> What I need to do is when generating the new sheets via the Generate 
> macro, the corresponding selection in column J, will copy the relevant 
> sheet (Link1, Link2, Link3 or nothing) to the new sheet with the 
> corresponding name from column C.
>
> I really hope this is coherent (!!) and welcome any advice on this problem.
>
> Many thanks for looking.
>
>
On Thursday, July 26, 2012 6:57:03 PM UTC+1, skyping1 wrote:
>
> Need your help once again!!!
>
> A previous project needs to be updated and I simply cannot my head around 
> it.
>
> I have a workbook that currently comprises of 5 worksheets, 3 of which are 
> relating to my problem and are hidden. These are called Link1, Link2, and 
> Link3. 
>
> The initial concept of the project was to generate new worksheets labelled 
> from the contents of c12:c31 on the Intro worksheet. This works fine…. see 
> macro below:
>
> Private Sub GENERATE_Click()
> On Error Resume Next
> Call DeleteSheets
> Dim MyCell As Range, MyRange As Range
> Set MyRange = Sheets("Intro").Range("c12")
> Set MyRange = Range(MyRange, MyRange.End(xlDown))
> For Each MyCell In MyRange
> Sheets.Add After:=Sheets(Sheets.Count) 'creates a new worksheet
> Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet
> Next MyCell
> End Sub
>
> However, I have added another variable which is displayed in a drop down 
> list in j12:j31, which relates to the content of these 3 new hidden sheets. 
>
> What I need to do is when generating the new sheets via the Generate 
> macro, the corresponding selection in column J, will copy the relevant 
> sheet (Link1, Link2, Link3 or nothing) to the new sheet with the 
> corresponding name from column C.
>
> I really hope this is coherent (!!) and welcome any advice on this problem.
>
> Many thanks for looking.
>
>
On Thursday, July 26, 2012 6:57:03 PM UTC+1, skyping1 wrote:
>
> Need your help once again!!!
>
> A previous project needs to be updated and I simply cannot my head around 
> it.
>
> I have a workbook that currently comprises of 5 worksheets, 3 of which are 
> relating to my problem and are hidden. These are called Link1, Link2, and 
> Link3. 
>
> The initial concept of the project was to generate new worksheets labelled 
> from the contents of c12:c31 on the Intro worksheet. This works fine…. see 
> macro below:
>
> Private Sub GENERATE_Click()
> On Error Resume Next
> Call DeleteSheets
> Dim MyCell As Range, MyRange As Range
> Set MyRange = Sheets("Intro"

$$Excel-Macros$$ Workdays formula help required

[venus]

H,

Please help regarding how to implement workdays formula.


-- 
Regards,

Vikram Ahuja

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

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

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

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

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

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com