Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Chandra Shekar
Thanks Vaibhav

On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by Bill
 Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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/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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ hi all

2014-09-18 Thread sunil lobo
hi i have a value in sheet 1 named black and another sheet named white

in Sheet named  black in cell A1 i already have a value with validation on
it

In Sheet named white  i have certain values in column  A
the values are from A1 to A10

Now i am want a vb code to check if i enter a value it has to cross check
whether it is there in sheet named white in column A
if it is there it should pop up a message

please help 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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Ganesh N
Hi Vaibhav Ji,

Can you please explain how the attachment works because I cant even see any
macro in that file.

Note: Its in the amazing excel formulas file.

Thanks  Regards,
Ganesh N

On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
chandrashekarb@gmail.com wrote:

 Thanks Vaibhav

 On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by Bill
 Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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/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 http://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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Page038_NatLang.xls
Description: MS-Excel spreadsheet


Re: $$Excel-Macros$$ hi all

2014-09-18 Thread Ashish Kumar
Hi Sunil,

PFA.!!


Regards
Ashish

-- 
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/d/optout.


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


Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Vaibhav Joshi
Hi

There is no Macro in this file, it contains formula only.

Cheers!!

+
*I did not do this for you. God is here working through me for you.*

On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N ganeshg...@gmail.com wrote:

 Hi Vaibhav Ji,

 Can you please explain how the attachment works because I cant even see
 any macro in that file.

 Note: Its in the amazing excel formulas file.

 Thanks  Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Thanks Vaibhav

 On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by Bill
 Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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/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 http://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 http://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 

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Ganesh N
Yes sir no macro but can you tell me how the formula works ?

e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more amount in
addition row/col it not working

Regards,
Ganesh N

On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 There is no Macro in this file, it contains formula only.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N ganeshg...@gmail.com wrote:

 Hi Vaibhav Ji,

 Can you please explain how the attachment works because I cant even see
 any macro in that file.

 Note: Its in the amazing excel formulas file.

 Thanks  Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Thanks Vaibhav

 On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by
 Bill Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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/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 http://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 http://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) 

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Vaibhav Joshi
ok, COGS is named range, press Ctr + G you will see all defined cells.
Select COGS you will be taken to range.

Cheers!!

+
*I did not do this for you. God is here working through me for you.*

On Thu, Sep 18, 2014 at 4:55 PM, Ganesh N ganeshg...@gmail.com wrote:

 Yes sir no macro but can you tell me how the formula works ?

 e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more amount
 in addition row/col it not working

 Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 There is no Macro in this file, it contains formula only.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N ganeshg...@gmail.com wrote:

 Hi Vaibhav Ji,

 Can you please explain how the attachment works because I cant even see
 any macro in that file.

 Note: Its in the amazing excel formulas file.

 Thanks  Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Thanks Vaibhav

 On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by
 Bill Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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/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 http://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 

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Ganesh N
Got it sir!! Thanks

One more help sir. Like formulas do you have sample files for macros ? just
to learn. im a beginner to macro.

Regards,
Ganesh N

On Thu, Sep 18, 2014 at 4:59 PM, Vaibhav Joshi v...@vabs.in wrote:

 ok, COGS is named range, press Ctr + G you will see all defined cells.
 Select COGS you will be taken to range.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 4:55 PM, Ganesh N ganeshg...@gmail.com wrote:

 Yes sir no macro but can you tell me how the formula works ?

 e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more amount
 in addition row/col it not working

 Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 There is no Macro in this file, it contains formula only.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N ganeshg...@gmail.com wrote:

 Hi Vaibhav Ji,

 Can you please explain how the attachment works because I cant even see
 any macro in that file.

 Note: Its in the amazing excel formulas file.

 Thanks  Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Thanks Vaibhav

 On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by
 Bill Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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/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 http://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 

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Prafull Jadhav
Dear Vaibhav Sir,

Thanks for the shared us a very useful file.


Regards,
Prafull Jadhav
9920553518

On 18 September 2014 17:32, Ganesh N ganeshg...@gmail.com wrote:

 Got it sir!! Thanks

 One more help sir. Like formulas do you have sample files for macros ?
 just to learn. im a beginner to macro.

 Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 4:59 PM, Vaibhav Joshi v...@vabs.in wrote:

 ok, COGS is named range, press Ctr + G you will see all defined cells.
 Select COGS you will be taken to range.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 4:55 PM, Ganesh N ganeshg...@gmail.com wrote:

 Yes sir no macro but can you tell me how the formula works ?

 e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more amount
 in addition row/col it not working

 Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 There is no Macro in this file, it contains formula only.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N ganeshg...@gmail.com wrote:

 Hi Vaibhav Ji,

 Can you please explain how the attachment works because I cant even
 see any macro in that file.

 Note: Its in the amazing excel formulas file.

 Thanks  Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Thanks Vaibhav

 On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by
 Bill Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for you.*

 --
 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/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 http://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 

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Govardhan Bhatia
On 9/18/14, Prafull Jadhav prafulltjad...@gmail.com wrote:
 Dear Vaibhav Sir,

 Thanks for the shared us a very useful file.


 Regards,
 Prafull Jadhav
 9920553518

 On 18 September 2014 17:32, Ganesh N ganeshg...@gmail.com wrote:

 Got it sir!! Thanks

 One more help sir. Like formulas do you have sample files for macros ?
 just to learn. im a beginner to macro.

 Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 4:59 PM, Vaibhav Joshi v...@vabs.in wrote:

 ok, COGS is named range, press Ctr + G you will see all defined cells.
 Select COGS you will be taken to range.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 4:55 PM, Ganesh N ganeshg...@gmail.com wrote:

 Yes sir no macro but can you tell me how the formula works ?

 e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more
 amount
 in addition row/col it not working

 Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi

 There is no Macro in this file, it contains formula only.

 Cheers!!

 +
 *I did not do this for you. God is here working through me for you.*

 On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N ganeshg...@gmail.com
 wrote:

 Hi Vaibhav Ji,

 Can you please explain how the attachment works because I cant even
 see any macro in that file.

 Note: Its in the amazing excel formulas file.

 Thanks  Regards,
 Ganesh N

 On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Thanks Vaibhav

 On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 Hi,

 No posts since morning thought of sharing amazing excel formulas by
 Bill Jelen aka Mr. Excel.

 Cheers!!
 +
 *I did not do this for you. God is here working through me for
 you.*

 --
 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/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 http://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 : 

Re: $$Excel-Macros$$ Amazing Excel formulas...

2014-09-18 Thread Waseem Saifi
It is really an amazing collection vaibhav.
thank you so much vaibhav.

On Thu, Sep 18, 2014 at 8:06 AM, Govardhan Bhatia bkrishkr...@gmail.com
wrote:

 On 9/18/14, Prafull Jadhav prafulltjad...@gmail.com wrote:
  Dear Vaibhav Sir,
 
  Thanks for the shared us a very useful file.
 
 
  Regards,
  Prafull Jadhav
  9920553518
 
  On 18 September 2014 17:32, Ganesh N ganeshg...@gmail.com wrote:
 
  Got it sir!! Thanks
 
  One more help sir. Like formulas do you have sample files for macros ?
  just to learn. im a beginner to macro.
 
  Regards,
  Ganesh N
 
  On Thu, Sep 18, 2014 at 4:59 PM, Vaibhav Joshi v...@vabs.in wrote:
 
  ok, COGS is named range, press Ctr + G you will see all defined cells.
  Select COGS you will be taken to range.
 
  Cheers!!
 
  +
  *I did not do this for you. God is here working through me for you.*
 
  On Thu, Sep 18, 2014 at 4:55 PM, Ganesh N ganeshg...@gmail.com
 wrote:
 
  Yes sir no macro but can you tell me how the formula works ?
 
  e.g =SUM(COGS) how is sum the cogs ? Note: if I add some more
  amount
  in addition row/col it not working
 
  Regards,
  Ganesh N
 
  On Thu, Sep 18, 2014 at 4:25 PM, Vaibhav Joshi v...@vabs.in wrote:
 
  Hi
 
  There is no Macro in this file, it contains formula only.
 
  Cheers!!
 
  +
  *I did not do this for you. God is here working through me for you.*
 
  On Thu, Sep 18, 2014 at 3:36 PM, Ganesh N ganeshg...@gmail.com
  wrote:
 
  Hi Vaibhav Ji,
 
  Can you please explain how the attachment works because I cant even
  see any macro in that file.
 
  Note: Its in the amazing excel formulas file.
 
  Thanks  Regards,
  Ganesh N
 
  On Thu, Sep 18, 2014 at 12:39 PM, Chandra Shekar 
  chandrashekarb@gmail.com wrote:
 
  Thanks Vaibhav
 
  On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi v...@vabs.in
 wrote:
 
  Hi,
 
  No posts since morning thought of sharing amazing excel formulas
 by
  Bill Jelen aka Mr. Excel.
 
  Cheers!!
  +
  *I did not do this for you. God is here working through me for
  you.*
 
  --
  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/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 http://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 

$$Excel-Macros$$ Loop in cell in different sheet in a workbook

2014-09-18 Thread josua sitinjak
Good morning MS EXCEL AND VBA MACROS member.
I'm newbie in macros.
I would like to ask something.

Please help me,

I want to loop in a value in different sheet in a workbook at macro excel.
ex : 
I want to compute x value in sheet 2, but to compute the x value, i need y 
value in sheet 1. I have tried some method, but the macros said, subs out 
of range.
Anyone can help me?
Every x value always related to every y value. I mean x1 to y1, x2 to y2, 
etc...

This is the code i type in sheet 2.


Sub Hitung_Sound_Pressure_Level ()

Dim i, j, A, c, Pe0 As Double

A = 0.0705
Pe0 = 0.2
c = 2 ^ 0.5

For j = 0 To 10
For i = 0 To 10
Cells(32 + j, 3 + i).Value = 10 * Log((A / 
((Worksheets(Sheet1).Cells(32 + j, 3 + i).Value) * c)) ^ 2 / (Pe0 ^ 2))
  Next i
Next j
End Sub

-- 
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/d/optout.


Re: $$Excel-Macros$$ Loop in cell in different sheet in a workbook

2014-09-18 Thread Paul Schreiner
What is the actual name of your worksheets?
Is one actually called Sheet1 or have you renamed it something else?

For instance, if the first sheet in your workbook is called Data,
in the VBA explorer window, it will be called:
 Sheet1 (Data)

If you want to refer to the value of Cells(32 + j, 3 + i) in the Data sheet,
you would either use:
Worksheets(Data).Cells(32 + j, 3 + i).Value
or
Sheet1.Cells(32 + j, 3 + i).Value


Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-

 From: josua sitinjak josuasitinja...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Thursday, September 18, 2014 9:41 PM
Subject: $$Excel-Macros$$ Loop in cell in different sheet in a  workbook
  


Good morning MS EXCEL AND VBA MACROS member.
I'm newbie in macros.
I would like to ask something.

Please help me,

I want to loop in a value in different sheet in a workbook at macro excel.
ex : 
I want to compute x value in sheet 2, but to compute the x value, i need y 
value in sheet 1. I have tried some method, but the macros said, subs out of 
range.
Anyone can help me?
Every x value always related to every y value. I mean x1 to y1, x2 to y2, 
etc...

This is the code i type in sheet 2.


Sub Hitung_Sound_Pressure_Level ()

Dim i, j, A, c, Pe0 As Double

A = 0.0705
Pe0 = 0.2
c = 2 ^ 0.5

For j = 0 To 10
For i = 0 To 10
Cells(32 + j, 3 + i).Value = 10 * Log((A / 
 ((Worksheets(Sheet1).Cells(32 + j, 3 + i).Value) * c)) ^ 2 / (Pe0 ^ 2))
  Next i
Next j
End Sub


-- 
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/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 http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Track the system Lock

2014-09-18 Thread Ganesh N
i need VBA code for below task 
I want to do disable and the (windows lock) *window+L* or (lock 
workstation) or *Crtl+alt+Del*.
can every one give the code for that...?

-- 
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/d/optout.