subject:"$$Excel\-Macros$$ How do i"

Re: $$Excel-Macros$$ How do I arrange formula in Microsoft Excel

2016-07-14 Thread Paul Schreiner

In this case, in cell C5 you could use a calculation like:=(Q35 -1) * 10
 Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
- 

   

 On Thursday, July 14, 2016 7:27 AM, David Jones  
wrote:
 

 Hi,Can any one please help me to arrange a formula, so that if the number in a 
selected cell increases, the corresponding answer in another cell will increase 
accordingly.

How do i arrange the formula in Excel, so that if Q35(cell number)=1, the 
answer (in cell C5) is 0;                                                       
                   if Q35 =2, the answer (in cell C5) is 10;                    
                                                      if Q35=3, the answer (in 
cell C5) is 20                                                                  
         if Q35=4, the answer (in cell C5) is 30 and so on...

I am trying to set a spreadsheet up for a friend to help him set up in 
business, the numbers 0 through to 4 (and onwards in cell Q35) are the number 
of stops on a delivery route, the answer in increments of (say 10), in cell C5, 
is the assumed additional cost per extra stop beyond the first stop. i.e. if 
only stops once, no extra charge, if he stops a second time, he will charge an 
extra £10 and if he stops three times in total, the extra charge would be £20 
etc...
I hope that someone can please help me on this-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


  

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

$$Excel-Macros$$ How do I arrange formula in Microsoft Excel

2016-07-14 Thread David Jones

Hi,
Can any one please help me to arrange a formula, so that if the number in a 
selected cell increases, the corresponding answer in another cell will 
increase accordingly.

How do i arrange the formula in Excel, so that if Q35(cell number)=1, the 
answer (in cell C5) is 0;
  
if Q35 =2, the answer (in cell C5) is 10;
  
if Q35=3, the answer (in cell C5) is 20 
  
if Q35=4, the answer (in cell C5) is 30 and so on...

I am trying to set a spreadsheet up for a friend to help him set up in 
business, the numbers 0 through to 4 (and onwards in cell Q35) are the 
number of stops on a delivery route, the answer in increments of (say 10), 
in cell C5, is the assumed additional cost per extra stop beyond the first 
stop. i.e. if only stops once, no extra charge, if he stops a second time, 
he will charge an extra £10 and if he stops three times in total, the extra 
charge would be £20 etc...

I hope that someone can please help me on this

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

Re: $$Excel-Macros$$ HOW DO I SAVE TABLE DESIGN DATA

2013-12-22 Thread xlstime

please elaborate

.

Enjoy
Team XLS



On Tue, Dec 17, 2013 at 3:23 PM, sridher sharma wrote:

> how do I save a table? I have taken my data, created a table and then
> tried to 'save as' but when I reopen it, it is back in the original
> worksheet format. What am I missing?
>
>
>
> Thanks in Advances
> Sridher Sharma
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

$$Excel-Macros$$ HOW DO I SAVE TABLE DESIGN DATA

2013-12-17 Thread sridher sharma

how do I save a table? I have taken my data, created a table and then tried
to 'save as' but when I reopen it, it is back in the original worksheet
format. What am I missing?



Thanks in Advances
Sridher Sharma

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

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

Re: $$Excel-Macros$$ How do I decrease the size of this file.....

2013-12-08 Thread Indrajit $nai

Thanks to all of you.


On Sun, Dec 8, 2013 at 4:01 AM, Amit Desai (MERU)
wrote:

>  I have converted the file in .xlsb version.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* 08 December 2013 13:45
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ How do I decrease the size of this file.
>
>
>
> Hi All,
>
>
>
> Kindly assist me how do I decrease the size of the attached file.
>
>
>
> Please let me know the procedure as well.
>
>
>
> 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.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT

Re: $$Excel-Macros$$ How do i print all files [any file type (.pdf,.doc,.tiff)] in a folder using vba macros

2011-11-17 Thread manhar prajapati

Hi dear

Use Adobe professional 7.0 for making pdf file from any file and save in
pdf to folder

Regards
Manahr

On Thu, Nov 17, 2011 at 2:52 PM, jmothilal  wrote:

> Dear Any one,
>
> How can I want print all notepad files in landscape left 0.5 right 0.5
> margin in one time
>
> Thanks with
>
> On Wed, Nov 16, 2011 at 6:49 PM, dguillett1  wrote:
>
>> http://forums.techguy.org/**business-applications/485943-**
>> printing-multiple-files-**folder.html<http://forums.techguy.org/business-applications/485943-printing-multiple-files-folder.html>
>>
>> try this.
>> sub printemall()
>> set shApp = createobject("shell.**application")
>> set shFolder = shApp.namespace("C:\**yourfoldername")
>> set shItems = shFolder.Items()
>> for each shItem in shItems
>>  shItem.invokeverb "&Print"
>> next
>> end sub
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>> -Original Message- From: ameya
>> Sent: Tuesday, November 15, 2011 10:57 AM
>> To: MS EXCEL AND VBA MACROS
>> Subject: $$Excel-Macros$$ How do i print all files [any file type
>> (.pdf,.doc,.tiff)] in a folder using vba macros
>>
>>
>> Hello,
>>
>> Could you please guide me on how do i print all files [any file type
>> (.pdf,.doc,.tiff)] in a folder using vba macros.
>> The folder path is pre-defined.
>>
>> Thanks
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) 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 (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) 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
>>
>
>
>
> --
>
> *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
> :Otteri, Vellore-2*
>
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) 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 (934+ members already BANNED for violation)

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

Re: $$Excel-Macros$$ How do i print all files [any file type (.pdf,.doc,.tiff)] in a folder using vba macros

2011-11-17 Thread jmothilal

Dear Any one,

How can I want print all notepad files in landscape left 0.5 right 0.5
margin in one time

Thanks with

On Wed, Nov 16, 2011 at 6:49 PM, dguillett1  wrote:

> http://forums.techguy.org/**business-applications/485943-**
> printing-multiple-files-**folder.html<http://forums.techguy.org/business-applications/485943-printing-multiple-files-folder.html>
>
> try this.
> sub printemall()
> set shApp = createobject("shell.**application")
> set shFolder = shApp.namespace("C:\**yourfoldername")
> set shItems = shFolder.Items()
> for each shItem in shItems
>  shItem.invokeverb "&Print"
> next
> end sub
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: ameya
> Sent: Tuesday, November 15, 2011 10:57 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ How do i print all files [any file type
> (.pdf,.doc,.tiff)] in a folder using vba macros
>
>
> Hello,
>
> Could you please guide me on how do i print all files [any file type
> (.pdf,.doc,.tiff)] in a folder using vba macros.
> The folder path is pre-defined.
>
> Thanks
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) 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 (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) 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
>



-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

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

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

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

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

4) 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$$ How do i print all files [any file type (.pdf,.doc,.tiff)] in a folder using vba macros

2011-11-16 Thread dguillett1


http://forums.techguy.org/business-applications/485943-printing-multiple-files-folder.html

try this.
sub printemall()
set shApp = createobject("shell.application")
set shFolder = shApp.namespace("C:\yourfoldername")
set shItems = shFolder.Items()
for each shItem in shItems
 shItem.invokeverb "&Print"
next
end sub

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

Sent: Tuesday, November 15, 2011 10:57 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ How do i print all files [any file type 
(.pdf,.doc,.tiff)] in a folder using vba macros


Hello,

Could you please guide me on how do i print all files [any file type
(.pdf,.doc,.tiff)] in a folder using vba macros.
The folder path is pre-defined.

Thanks

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

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


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

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


4) 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 (934+ members already BANNED for violation)

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

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

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

4) 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$$ How do i print all files [any file type (.pdf,.doc,.tiff)] in a folder using vba macros

2011-11-15 Thread ameya

Hello,

Could you please guide me on how do i print all files [any file type
(.pdf,.doc,.tiff)] in a folder using vba macros.
The folder path is pre-defined.

Thanks

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

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

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

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

4) 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$$ How do I transfer subtotal account Nr. alongwith its balance?

2011-04-29 Thread celadol_a

Rajan,
Please, kindly send again the sample file as I did not get the attached file 
referenced. Thanks.
Sent from my BlackBerry® wireless handheld from Glo Mobile.

-Original Message-
From: rajan verma 
Sender: excel-macros@googlegroups.com
Date: Fri, 29 Apr 2011 21:03:21 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How do I transfer subtotal account Nr. along
 with its balance?

Please attach a Sample File..

On Fri, Apr 29, 2011 at 2:56 PM,  wrote:

> Hello Guys,
>
> Please, I have generated a subtotal spreadsheet with over 150 accounting
> numbers with their balances that need to be transfered to another sheet to
> generate Trial Balance figures and Balance Sheet. Kindly tell me on how to
> do it.
>
> Thank you and Best Regards.
> Reginald Ok
> Sent from my BlackBerry® wireless handheld from Glo Mobile.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How do I transfer subtotal account Nr. along with its balance?

2011-04-29 Thread rajan verma

Please attach a Sample File..

On Fri, Apr 29, 2011 at 2:56 PM,  wrote:

> Hello Guys,
>
> Please, I have generated a subtotal spreadsheet with over 150 accounting
> numbers with their balances that need to be transfered to another sheet to
> generate Trial Balance figures and Balance Sheet. Kindly tell me on how to
> do it.
>
> Thank you and Best Regards.
> Reginald Ok
> Sent from my BlackBerry® wireless handheld from Glo Mobile.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ How do I transfer subtotal account Nr. along with its balance?

2011-04-29 Thread celadol_a

Hello Guys,

Please, I have generated a subtotal spreadsheet with over 150 accounting 
numbers with their balances that need to be transfered to another sheet to 
generate Trial Balance figures and Balance Sheet. Kindly tell me on how to do 
it.

Thank you and Best Regards.
Reginald Ok
Sent from my BlackBerry® wireless handheld from Glo Mobile.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

2011-01-08 Thread Ms-Exl-Learner .

Hi All,

Have a look in the attached excel and you can find the solution.

The formula is given below for your reference.  Adapt the Cell Range A3:A8
to your desired Range.

=IF(COUNTIF(A3:A8,LARGE(A3:A8,1))=COUNTIF(A3:A8,MODE(A3:A8)),LARGE(A3:A8,1),MODE(A3:A8))

*Suggestions For All*
*
*
1) Always try to avoid the usage of the helper column(s).
2) Never go for array formula when the same can be achieved by normal one.
3) Please don't go for VBA (Macro) solution for simple things when excel
holds lot of functions to do the work as expected (Like the above).

---
Ms.Exl.Learner
---

On Thu, Jan 6, 2011 at 6:17 AM, Kim  wrote:

> Hi,
> I have a list of numbers and I need to find the highest of the most
> frequent occurrances.
>
> For example:
>
> List 1
> 1
> 3
> 3
> 4
> 4
>
> Should return the value 4 because its the highest of the most
> frequent
> occurrances of any number.
>
> List 2
> 1
> 3
> 3
> 3
> 4
> 4
>
> Should return 3 because it's the most frequent occurrance outright.
>
> I've tried using the mode command but it returns the first of the
> most
> frequent occurances but I want the highest of the most frequent
> occurrances.
>
> Any help would be greatly appreciated.
>
> Thanks
>
> Kim
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



--

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Solution (9-Jan-2011).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

2011-01-06 Thread Kim

Thanks so much Paul.

I really do need a single formula to do it but again, I'm so impressed
with the assistance you and others have given me on this forum.

I've actually reorganised my base data as a workaround so the need has
passed but I've kept a copy of this code for future reference.

Thanks guys.

Kim



On Jan 7, 1:32 am, Paul Schreiner  wrote:
> Do you care if it is done with a macro?
>
> Option Explicit
> Public Dict_Vals
> Sub CheckVals()
>     Dim KeyVals, R, MaxVal, MaxCnt, RowCnt
>     Set Dict_Vals = CreateObject("Scripting.Dictionary")
>     Dict_Vals.RemoveAll
>     RowCnt = Application.WorksheetFunction.CountA(Range("A1:A65000"))
>     For R = 1 To RowCnt
>     If (Dict_Vals.exists(Sheets("Sheet1").Cells(R, "A").Value)) Then
>     Dict_Vals.Item(Cells(R, "A").Value) = Dict_Vals.Item(Cells(R,
> "A").Value) + 1
>     Else
>     Dict_Vals.Add (Cells(R, "A").Value), 1
>     End If
>     Next R
>     MaxVal = 0
>     MaxCnt = 0
>     KeyVals = Dict_Vals.keys
>     For R = 0 To UBound(KeyVals)
>     If Dict_Vals.Item(KeyVals(R)) > MaxCnt Then
>     MaxVal = KeyVals(R)
>     MaxCnt = Dict_Vals.Item(KeyVals(R))
>     Debug.Print "VAL: " & MaxVal & " Cnt: " & MaxCnt
>     ElseIf Dict_Vals.Item(KeyVals(R)) = MaxCnt Then
>     If KeyVals(R) > MaxVal Then
>     MaxVal = KeyVals(R)
>     MaxCnt = Dict_Vals.Item(KeyVals(R))
>     End If
>     End If
>     Next R
>     MsgBox "VAL: " & MaxVal & Chr(13) & "Cnt: " & MaxCnt
> End Sub
>
> Paul
>
> 
> From: Kim 
> To: MS EXCEL AND VBA MACROS 
> Sent: Thu, January 6, 2011 1:16:15 AM
> Subject: Re: $$Excel-Macros$$ How do I find the highest of the most repeating
> values in a list of numbers ie. the max of the modes
>
> Thanks so much Ashish but the problem is in the temporary column.  I
> really need to do it in one cell only without introducing any new
> data.
>
> Any idea on how I can achieve that?
>
> Again, thanks for your help.
>
> Kim
>
> On Jan 6, 4:07 pm, ashish koul  wrote:
>
>
>
>
>
> > check the attachment  see if it helps
>
> > On Thu, Jan 6, 2011 at 6:17 AM, Kim  wrote:
> > > Hi,
> > > I have a list of numbers and I need to find the highest of the most
> > > frequent occurrances.
>
> > > For example:
>
> > > List 1
> > > 1
> > > 3
> > > 3
> > > 4
> > > 4
>
> > > Should return the value 4 because its the highest of the most
> > > frequent
> > > occurrances of any number.
>
> > > List 2
> > > 1
> > > 3
> > > 3
> > > 3
> > > 4
> > > 4
>
> > > Should return 3 because it's the most frequent occurrance outright.
>
> > > I've tried using the mode command but it returns the first of the
> > > most
> > > frequent occurances but I want the highest of the most frequent
> > > occurrances.
>
> > > Any help would be greatly appreciated.
>
> > > Thanks
>
> > > Kim
>
> > > --
>
> >------
>
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > > To post to this group, send email to excel-macros@googlegroups.com
>
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > Like our page on facebook , Just follow below link
> > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...
>
> > --
> > *Regards*
> > * *
> > *Ashish Koul*
> > *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> > *akoul*.wordpress.com <http://akoul.wordpress.com/>
> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
> > P Before printing, think about the environment.
>
> >  sample datat.xls
>

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

2011-01-06 Thread hanumant shinde

thanks Ashish, really appreciated.


>
>From: ashish koul 
>To: excel-macros@googlegroups.com
>Sent: Thu, 6 January, 2011 11:50:17 AM
>Subject: Re: $$Excel-Macros$$ How do I find the highest of the most repeating 
>values in a list of numbers ie. the max of the modes
>
>
>its array formula so u have to press  ctrl +shift +enter  then {} it will come 
>automatically
> 
> for offset check  help =
>
>MAX(IF(F2:F9=MAX(F2:F9),ROW(F2:F9),""))  it will return the maximum row no 
>which 
>is having max value in range f2:f9 
>
> 
> 
> 
> 
>On Thu, Jan 6, 2011 at 11:15 AM, hanumant shinde  
>wrote:
>
>Hi Ashish,
>>
>>can you pls explain this. 
>>{=OFFSET(E1,MAX(IF(F2:F9=MAX(F2:F9),ROW(F2:F9),""))-1,0)}
>>
>>
>>Also,why have u used {}. when to use them. if do F2 i get Value error. why is 
>>it 
>>so.
>>so many que :( can you please explain.
>>
>>
>>
>>

 From: ashish koul 
>>To: excel-macros@googlegroups.com
>>Sent: Thu, 6 January, 2011 10:37:35 AM
>>Subject: Re: $$Excel-Macros$$ How do I find the highest of the most repeating 
>>values in a list of numbers ie. the max of the modes
>> 
>>
>>check the attachment  see if it helps 
>>
>>
>>On Thu, Jan 6, 2011 at 6:17 AM, Kim  wrote:
>>
>>Hi,
>>>I have a list of numbers and I need to find the highest of the most
>>>frequent occurrances.
>>>
>>>For example:
>>>
>>>List 1
>>>1
>>>3
>>>3
>>>4
>>>4
>>>
>>>Should return the value 4 because its the highest of the most
>>>frequent
>>>occurrances of any number.
>>>
>>>List 2
>>>1
>>>3
>>>3
>>>3
>>>4
>>>4
>>>
>>>Should return 3 because it's the most frequent occurrance outright.
>>>
>>>I've tried using the mode command but it returns the first of the
>>>most
>>>frequent occurances but I want the highest of the most frequent
>>>occurrances.
>>>
>>>Any help would be greatly appreciated.
>>>
>>>Thanks
>>>
>>>Kim
>>>
>>>--
>>>--
>>>
>>>Some important links for excel users:
>>>1. Follow us on TWITTER for tips tricks and links : 
>>>http://twitter.com/exceldailytip
>>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>>To post to this group, send email to excel-macros@googlegroups.com
>>>
>>><><><><><><><><><><><><><><><><><><><><><><>
>>>Like our page on facebook , Just follow below link
>>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>
>>-- 
>>
>>Regards
>> 
>>Ashish Koul
>>akoul.blogspot.com
>>akoul.wordpress.com
>>My Linkedin Profile
>> 
>> 
>>PBefore printing, think about the environment.
 
>>-- 
>>
>>--
>>
>>Some important links for excel users:
>>1. Follow us on TWITTER for tips tricks and links : 
>>http://twitter.com/exceldailytip
>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>To post to this group, send email to excel-macros@googlegroups.com
>> 
>><><><><><><><><><><><><><><><><><><><><><><>
>>Like our page on facebook , Just follow below link
>>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>>
>>-- 
>>--
>>
>>Some important links for excel users:
>>1. Follow us on TWITTER for tips tricks and links : 
>>h

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

2011-01-06 Thread Paul Schreiner

Do you care if it is done with a macro?

Option Explicit
Public Dict_Vals
Sub CheckVals()
    Dim KeyVals, R, MaxVal, MaxCnt, RowCnt
    Set Dict_Vals = CreateObject("Scripting.Dictionary")
    Dict_Vals.RemoveAll
    RowCnt = Application.WorksheetFunction.CountA(Range("A1:A65000"))
    For R = 1 To RowCnt
    If (Dict_Vals.exists(Sheets("Sheet1").Cells(R, "A").Value)) Then
    Dict_Vals.Item(Cells(R, "A").Value) = Dict_Vals.Item(Cells(R, 
"A").Value) + 1
    Else
    Dict_Vals.Add (Cells(R, "A").Value), 1
    End If
    Next R
    MaxVal = 0
    MaxCnt = 0
    KeyVals = Dict_Vals.keys
    For R = 0 To UBound(KeyVals)
    If Dict_Vals.Item(KeyVals(R)) > MaxCnt Then
    MaxVal = KeyVals(R)
    MaxCnt = Dict_Vals.Item(KeyVals(R))
    Debug.Print "VAL: " & MaxVal & " Cnt: " & MaxCnt
    ElseIf Dict_Vals.Item(KeyVals(R)) = MaxCnt Then
    If KeyVals(R) > MaxVal Then
    MaxVal = KeyVals(R)
    MaxCnt = Dict_Vals.Item(KeyVals(R))
    End If
    End If
    Next R
    MsgBox "VAL: " & MaxVal & Chr(13) & "Cnt: " & MaxCnt
End Sub

Paul



________
From: Kim 
To: MS EXCEL AND VBA MACROS 
Sent: Thu, January 6, 2011 1:16:15 AM
Subject: Re: $$Excel-Macros$$ How do I find the highest of the most repeating 
values in a list of numbers ie. the max of the modes

Thanks so much Ashish but the problem is in the temporary column.  I
really need to do it in one cell only without introducing any new
data.

Any idea on how I can achieve that?

Again, thanks for your help.

Kim

On Jan 6, 4:07 pm, ashish koul  wrote:
> check the attachment  see if it helps
>
>
>
>
>
> On Thu, Jan 6, 2011 at 6:17 AM, Kim  wrote:
> > Hi,
> > I have a list of numbers and I need to find the highest of the most
> > frequent occurrances.
>
> > For example:
>
> > List 1
> > 1
> > 3
> > 3
> > 4
> > 4
>
> > Should return the value 4 because its the highest of the most
> > frequent
> > occurrances of any number.
>
> > List 2
> > 1
> > 3
> > 3
> > 3
> > 4
> > 4
>
> > Should return 3 because it's the most frequent occurrance outright.
>
> > I've tried using the mode command but it returns the first of the
> > most
> > frequent occurances but I want the highest of the most frequent
> > occurrances.
>
> > Any help would be greatly appreciated.
>
> > Thanks
>
> > Kim
>
> > --
>
> > 
>------
>
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
> P Before printing, think about the environment.
>
>  sample datat.xls
> 24KViewDownload- Hide quoted text -
>
> - Show quoted text -

-- 
--

Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

2011-01-06 Thread Vallinayagam

Hi Kim,

If you Excel 2010, then the job would be much easier.

=Max(Mode.Mult(A1:A10))

This function is not available in Excel 2003.

Cheers
Valli

On Jan 6, 11:16 am, Kim  wrote:
> Thanks so much Ashish but the problem is in the temporary column.  I
> really need to do it in one cell only without introducing any new
> data.
>
> Any idea on how I can achieve that?
>
> Again, thanks for your help.
>
> Kim
>
> On Jan 6, 4:07 pm, ashish koul  wrote:
>
>
>
> > check the attachment  see if it helps
>
> > On Thu, Jan 6, 2011 at 6:17 AM, Kim  wrote:
> > > Hi,
> > > I have a list of numbers and I need to find the highest of the most
> > > frequent occurrances.
>
> > > For example:
>
> > > List 1
> > > 1
> > > 3
> > > 3
> > > 4
> > > 4
>
> > > Should return the value 4 because its the highest of the most
> > > frequent
> > > occurrances of any number.
>
> > > List 2
> > > 1
> > > 3
> > > 3
> > > 3
> > > 4
> > > 4
>
> > > Should return 3 because it's the most frequent occurrance outright.
>
> > > I've tried using the mode command but it returns the first of the
> > > most
> > > frequent occurances but I want the highest of the most frequent
> > > occurrances.
>
> > > Any help would be greatly appreciated.
>
> > > Thanks
>
> > > Kim
>
> > > --
>
> > > ------
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > > To post to this group, send email to excel-macros@googlegroups.com
>
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > Like our page on facebook , Just follow below link
> > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...
>
> > --
> > *Regards*
> > * *
> > *Ashish Koul*
> > *akoul*.*blogspot*.com 
> > *akoul*.wordpress.com 
> > My Linkedin Profile 
>
> > P Before printing, think about the environment.
>
> >  sample datat.xls
> > 24KViewDownload- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

2011-01-05 Thread Kim

Thanks so much Ashish but the problem is in the temporary column.  I
really need to do it in one cell only without introducing any new
data.

Any idea on how I can achieve that?

Again, thanks for your help.

Kim

On Jan 6, 4:07 pm, ashish koul  wrote:
> check the attachment  see if it helps
>
>
>
>
>
> On Thu, Jan 6, 2011 at 6:17 AM, Kim  wrote:
> > Hi,
> > I have a list of numbers and I need to find the highest of the most
> > frequent occurrances.
>
> > For example:
>
> > List 1
> > 1
> > 3
> > 3
> > 4
> > 4
>
> > Should return the value 4 because its the highest of the most
> > frequent
> > occurrances of any number.
>
> > List 2
> > 1
> > 3
> > 3
> > 3
> > 4
> > 4
>
> > Should return 3 because it's the most frequent occurrance outright.
>
> > I've tried using the mode command but it returns the first of the
> > most
> > frequent occurances but I want the highest of the most frequent
> > occurrances.
>
> > Any help would be greatly appreciated.
>
> > Thanks
>
> > Kim
>
> > --
>
> > ------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
> P Before printing, think about the environment.
>
>  sample datat.xls
> 24KViewDownload- Hide quoted text -
>
> - Show quoted text -

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

2011-01-05 Thread ashish koul

its array formula so u have to press  ctrl +shift +enter  then {} it will
come automatically

 for offset check  help =
MAX(IF(F2:F9=MAX(F2:F9),ROW(F2:F9),""))  it will return the maximum row no
which is having max value in range f2:f9




On Thu, Jan 6, 2011 at 11:15 AM, hanumant shinde
wrote:

>  Hi Ashish,
>
> can you pls explain this.
> {=OFFSET(E1,MAX(IF(F2:F9=MAX(F2:F9),ROW(F2:F9),""))-1,0)}
>
> Also,why have u used {}. when to use them. if do F2 i get Value error. why
> is it so.
> so many que :( can you please explain.
>
>  --
> *From:* ashish koul 
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, 6 January, 2011 10:37:35 AM
> *Subject:* Re: $$Excel-Macros$$ How do I find the highest of the most
> repeating values in a list of numbers ie. the max of the modes
>
> check the attachment  see if it helps
>
> On Thu, Jan 6, 2011 at 6:17 AM, Kim  wrote:
>
>> Hi,
>> I have a list of numbers and I need to find the highest of the most
>> frequent occurrances.
>>
>> For example:
>>
>> List 1
>> 1
>> 3
>> 3
>> 4
>> 4
>>
>> Should return the value 4 because its the highest of the most
>> frequent
>> occurrances of any number.
>>
>> List 2
>> 1
>> 3
>> 3
>> 3
>> 4
>> 4
>>
>> Should return 3 because it's the most frequent occurrance outright.
>>
>> I've tried using the mode command but it returns the first of the
>> most
>> frequent occurances but I want the highest of the most frequent
>> occurrances.
>>
>> Any help would be greatly appreciated.
>>
>> Thanks
>>
>> Kim
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
>   --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com <http://akoul.blogspot.com/>
*akoul*.wordpress.com <http://akoul.wordpress.com/>
My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

2011-01-05 Thread hanumant shinde

Hi Ashish,

can you pls explain this. 
{=OFFSET(E1,MAX(IF(F2:F9=MAX(F2:F9),ROW(F2:F9),""))-1,0)}


Also,why have u used {}. when to use them. if do F2 i get Value error. why is 
it 
so.
so many que :( can you please explain.





From: ashish koul 
To: excel-macros@googlegroups.com
Sent: Thu, 6 January, 2011 10:37:35 AM
Subject: Re: $$Excel-Macros$$ How do I find the highest of the most repeating 
values in a list of numbers ie. the max of the modes

check the attachment  see if it helps 


On Thu, Jan 6, 2011 at 6:17 AM, Kim  wrote:

Hi,
>I have a list of numbers and I need to find the highest of the most
>frequent occurrances.
>
>For example:
>
>List 1
>1
>3
>3
>4
>4
>
>Should return the value 4 because its the highest of the most
>frequent
>occurrances of any number.
>
>List 2
>1
>3
>3
>3
>4
>4
>
>Should return 3 because it's the most frequent occurrance outright.
>
>I've tried using the mode command but it returns the first of the
>most
>frequent occurances but I want the highest of the most frequent
>occurrances.
>
>Any help would be greatly appreciated.
>
>Thanks
>
>Kim
>
>--
>--
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>


-- 

Regards
 
Ashish Koul
akoul.blogspot.com
akoul.wordpress.com
My Linkedin Profile
 
 
PBefore printing, think about the environment.
 

-- 
--

Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

2011-01-05 Thread ashish koul

check the attachment  see if it helps

On Thu, Jan 6, 2011 at 6:17 AM, Kim  wrote:

> Hi,
> I have a list of numbers and I need to find the highest of the most
> frequent occurrances.
>
> For example:
>
> List 1
> 1
> 3
> 3
> 4
> 4
>
> Should return the value 4 because its the highest of the most
> frequent
> occurrances of any number.
>
> List 2
> 1
> 3
> 3
> 3
> 4
> 4
>
> Should return 3 because it's the most frequent occurrance outright.
>
> I've tried using the mode command but it returns the first of the
> most
> frequent occurances but I want the highest of the most frequent
> occurrances.
>
> Any help would be greatly appreciated.
>
> Thanks
>
> Kim
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


sample datat.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

2011-01-05 Thread Kim

Hi,
I have a list of numbers and I need to find the highest of the most
frequent occurrances.

For example:

List 1
1
3
3
4
4

Should return the value 4 because its the highest of the most
frequent
occurrances of any number.

List 2
1
3
3
3
4
4

Should return 3 because it's the most frequent occurrance outright.

I've tried using the mode command but it returns the first of the
most
frequent occurances but I want the highest of the most frequent
occurrances.

Any help would be greatly appreciated.

Thanks

Kim

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ How do I copy some cells(including formatting) and save as image file using VBA?

2010-09-24 Thread LunaMoon

How do I copy some cells(including formatting) and save as image file
using VBA?

Ultimately, I want to do that via COM or ActiveX server. Yet I think
VBA is the starting point.

So lets start from VBA.

How to do that in VBA?

I know how to open and close the Excel sheet.

But what's the command in VBA/COM/ACTIVEX  to copy a few cells
(rectangular shape, including formatting), and save as image?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

RE: $$Excel-Macros$$ How do i

2010-01-21 Thread Dave Bonallack


Hi Paddy,

Try this:

 

Sub MyFormula()

ActiveCell = "=Your Formula goes here"

End Sub

 

Regards - Dave
 
> Date: Thu, 21 Jan 2010 01:27:19 -0800
> Subject: $$Excel-Macros$$ How do i
> From: ryan0...@gmail.com
> To: excel-macros@googlegroups.com
> 
> create a macro that means i can select any cell and when i execute the
> macro the formula will appear in the cell selected rather than the
> cell where it was created.
> 
> Thanks
> 
> Paddy
> 
  
_
Time for a new car? Sell your old one fast!
http://clk.atdmt.com/NMN/go/157637060/direct/01/

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ How do i

2010-01-21 Thread Paddy

create a macro that means i can select any cell and when i execute the
macro the formula will appear in the cell selected rather than the
cell where it was created.

Thanks

Paddy

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,700 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ How do I create a drop down list to select which macro to run

2009-10-30 Thread CPGH


I have 3 different macros that work, and as opposed to giving them
each their own ctrl+ key combinations to run, I'd like to create a
kind of drop down msgbox or something like that that would list the
different options available to the user so that they can select the
appropriate macro to run.

I'm assuming it needs some kind of listbox or combobox, but I have no
idea how to do this.

Any help would be greatly appreciated.

Thanks,
Chris

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ How do I create this type of chart?

2009-10-15 Thread mother


I don't know what this type of chart this would be called and I was
not able to find it in the chart selections in Excel.  But I want to
create a chart with the following criteria.

1.  Percentages from 0% to 100% along the left side of the chart
2.  A bar from 25% to 75%.  This is the hit area.
3.  A horizontal line marking the actual value.

For example, the bar will remain fixed from 25% to 75%.  The
horizontal line would represent any value between 0% to 100%.

Thanks,



--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ How do I protect a module code so that user's cannot view the code or tamper with it?

2009-07-15 Thread obahor o

Thanks
Mog

-- 
**
Omoghene Obahor
www.obahor.com
Cell: 214-493-7403
Fax: 866-338-1397
"As a Man Thinks So is He"
**

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,000 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ How do I create formula to return row number of search result...

2008-12-18 Thread ShellyGirl


Hello, I am trying to create a macro.  I would like for user to be
able to type in a search criteria and hit search button.  I would like
the macro to search a range of cells for the input and return the row
number of the first search result.  Any help will be greatly
appreciated...

I think my main problem is, I don't know how to create a formula to
return a row number.

--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit & Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~--~~~~--~~--~--~---

Re: $$Excel-Macros$$ How do I arrange formula in Microsoft Excel

$$Excel-Macros$$ How do I arrange formula in Microsoft Excel

Re: $$Excel-Macros$$ HOW DO I SAVE TABLE DESIGN DATA

$$Excel-Macros$$ HOW DO I SAVE TABLE DESIGN DATA

Re: $$Excel-Macros$$ How do I decrease the size of this file.....

Re: $$Excel-Macros$$ How do i print all files [any file type (.pdf,.doc,.tiff)] in a folder using vba macros

Re: $$Excel-Macros$$ How do i print all files [any file type (.pdf,.doc,.tiff)] in a folder using vba macros

Re: $$Excel-Macros$$ How do i print all files [any file type (.pdf,.doc,.tiff)] in a folder using vba macros

$$Excel-Macros$$ How do i print all files [any file type (.pdf,.doc,.tiff)] in a folder using vba macros

Re: $$Excel-Macros$$ How do I transfer subtotal account Nr. alongwith its balance?

Re: $$Excel-Macros$$ How do I transfer subtotal account Nr. along with its balance?

$$Excel-Macros$$ How do I transfer subtotal account Nr. along with its balance?

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

Re: $$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

$$Excel-Macros$$ How do I find the highest of the most repeating values in a list of numbers ie. the max of the modes

$$Excel-Macros$$ How do I copy some cells(including formatting) and save as image file using VBA?

RE: $$Excel-Macros$$ How do i

$$Excel-Macros$$ How do i

$$Excel-Macros$$ How do I create a drop down list to select which macro to run

$$Excel-Macros$$ How do I create this type of chart?

$$Excel-Macros$$ How do I protect a module code so that user's cannot view the code or tamper with it?

$$Excel-Macros$$ How do I create formula to return row number of search result...

29 matches

Site Navigation

Mail list logo

Footer information