from:"keisha.fry via MS EXCEL AND VBA MACROS"

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

2017-03-14 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial 
numbers
 To: excel-macros@googlegroups.com
 Date: Tuesday, March 14, 2017, 10:49 AM

 On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS

 wrote:

  Subject: Re: $$Excel-Macros$$ How to pick numbers which are
 missing in serial numbers
  To: excel-macros@googlegroups.com
  Date: Tuesday, March 14, 2017, 9:48 AM

  On Tue, 3/14/17, Sunil Kumar Yadav 
  wrote:

   Subject: Re: $$Excel-Macros$$ How to pick numbers
 which are
  missing in serial numbers
   To: excel-macros@googlegroups.com
   Date: Tuesday, March 14, 2017, 9:22 AM

   Thank you so much
   it's working perfectly:)
   On Mar 13, 2017 6:34 PM,
   "Paul Schreiner" 
   wrote:
   What
   I would do is first load your "Roll No." values
   into a Dictionary object.Then, loop through your
   "S.No." values and look to see if they are in the
   Dictionary.Report the missing
   values.Like:
   Sub
   Find_Missing()

   Dim Dict_SN, SN

   Dim nRows, nRow, drow

   Set Dict_SN = CreateObject("Scripting.
   Dictionary")

   Dict_SN.RemoveAll

   nRows = Range("A1").SpecialCells(
   xlLastCell).Row

   '
   Load Dictionary

   For nRow = 2 To nRows

   SN = Trim(ActiveSheet.Cells(nRow, "B").Value)

   If (SN & "X" <> "X") Then

   If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN,
 nRow

   End If

   Next nRow

   ActiveSheet.Range("C2:C65000") .ClearContents

   drow = 1

   For nRow = 2 To nRows

   SN = Trim(ActiveSheet.Cells(nRow, "A").Value)

   If (SN & "X" <> "X") Then

   If (Not Dict_SN.exists(SN)) Then

   drow = drow + 1

   ActiveSheet.Cells(drow, "C").Value = SN

   End If

   End If

   Next nRow
   End
   SubPaul--
   ---
   “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 Sunday, March 12, 2017 1:23 AM,
   Sunil Kumar Yadav 
   wrote:

    Dear Paul,
   I have need your help for this
   query. Please guide me.
   --

   Sky

   "Good, Better,
   Best!Always listen to your
   heart, because there lives your
   parents.

   -- 

   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+unsubscribe@
   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)

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

2017-03-09 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Thu, 3/9/17, Mohd Sadiq  wrote:

 Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
 To: "Pankaj Sharma" 
 Cc: excel-macros@googlegroups.com
 Date: Thursday, March 9, 2017, 4:54 PM

 Hello
 Pankaj ,
 Pls response
 as I need to closed it asap.
 Regards,Sadiq979223

 On Wed,
 Mar 8, 2017 at 6:50 PM, Mohd Sadiq 
 wrote:
 Pls response ?
 On Tue, Mar 7, 2017 at 7:00
 PM, Mohd Sadiq 
 wrote:
 Dear Pankaj ,
 Sorry for delayed response as I was
 on leave.
 Here is
 attached one more resolution for the same but when I am
 trying to put same formula in another sheet then it does not
 working Specially when I'm putting in Night
 Shift.
 Pls look into
 this and let me know what should I do now.

 PN-
 Column highlighted in Yellow/Orange color.
 Thanks

 On Thu, Mar 2, 2017 at 7:46
 AM, Pankaj Sharma 
 wrote:
 resolved
 PJ            

   MIS
 Analyst
     Greater Kailash-1, New
 Delhi.
 Instagram  pj_sharma_Tweeter 
  dude_sharma_pj
 Facebook   www.facebook.com/pankajesica1
 43pankajesica143
   We meet
 for a reason, either you're a blessing or a
 lesson...

 On
 Tue, Feb 28, 2017 at 11:43 PM, Mohd Sadiq 
 wrote:
 Here is the attached Sample Sheet,  Hope u can
 understand when u will see it :)
 On Tue, Feb 28, 2017 at
 11:37 PM, Mohd Sadiq 
 wrote:
 Firstly Unhide the sheet , and  I need Shift
 wise Staffing / Present basis of business shift which is
 mentioned in "A" column 
 I had made Normal some / Split shift
 details in shared shift however I m getting error in Night
 Shift when I m trying to used same formula .
 Regards,Sadiq979223
 On Tue,
 Feb 28, 2017 at 9:52 PM, Pankaj Sharma 
 wrote:
 Didn't get your query, what you want to do in
 this sheet, pls mention example with result.
 PJ            

   MIS
 Analyst
     Greater Kailash-1, New
 Delhi.
 Instagram  pj_sharma_Tweeter 
  dude_sharma_pj
 Facebook   www.facebook.com/dude.pj  We meet
 for a reason, either you're a blessing or a
 lesson...

 On
 Tue, Feb 28, 2017 at 9:22 PM, Mohd Sadiq 
 wrote:
 Hello Team ,

 Hope you are doing
 well,

 Here is attached a file
 where I need Interval / Day wise
 staffing which is mentioned in “H” Column, I am trying
 it multiple times to fixed
 Night Shift issue but unfortunately I’m not getting
 resolution L

 Request you to Pls help on the same
 on priority.

 Regards
 Mohd Sadiq

 -- 

 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/discu
 ssexcel

 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+unsubscribe@googl
 egroups.com.

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

 Visit this group at https://groups.google.com/grou
 p/excel-macros.

 For more options, visit https://groups.google.com/d/op
 tout.

 -- 

 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/discu
 ssexcel

 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

Re: $$Excel-Macros$$ changing required in the attach macro

2017-03-08 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Thu, 1/26/17, spainy via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ changing required in the attach macro
 To: excel-macros@googlegroups.com
 Date: Thursday, January 26, 2017, 10:40 AM

 On Thu, 1/26/17, storeythomas725 via MS EXCEL AND VBA MACROS

 wrote:

  Subject: Re: $$Excel-Macros$$ changing required in the
 attach macro
  To: excel-macros@googlegroups.com
  Date: Thursday, January 26, 2017, 12:48 AM

  On Wed, 1/25/17, julienneschindler via MS EXCEL AND VBA
  MACROS 
  wrote:

   Subject: Re: $$Excel-Macros$$ changing required in
 the
  attach macro
   To: excel-macros@googlegroups.com
   Date: Wednesday, January 25, 2017, 7:15 PM

   On Wed, 1/25/17, GENIUS 
   wrote:

    Subject: Re: $$Excel-Macros$$ changing required in
  the
   attach macro
    To: "MS EXCEL AND VBA MACROS" 
    Cc: schreiner_p...@att.net
    Date: Wednesday, January 25, 2017, 4:38 PM

    First
    Thank you very much for your suggestion,
    I'll try my best to describe the title as accurate
  as
    possible, since I'm new in macro so there are chances
  to
    not define the title as accurate as possible but
  I'll
    try my best

    Second Thank
    you for your help in the question

    -- 

    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.
    Palatul Sturdza din Bucuresti    sediu al
   Ministerului de Externe in perioada interbelica

   -- 
   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.cuparea
  Ruhrului  11 ian. 1923-31 iulie 1925  parea a
  da castig de cauza Frantei  in dificila chestiune a
  reparatiilor germane  iar P anul
  Dawes   adoptat la 16 august 1924 
  sublinia puternicul cerc de interese anglo-american in
  refacerea economica a principalei puteri invinse in primul
  razboi mondial. Pactul de garantii renan  semnat la
  Locarno  la 1 decembrie 1925  si ansambW
  acordurilor economice si politice sovieto-germane din
  primavara

Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month

2017-03-04 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Sat, 3/4/17, silvers.r via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ How to make dynamic formula for value change on 
fix date every month
 To: excel-macros@googlegroups.com
 Date: Saturday, March 4, 2017, 2:48 PM

 On Sat, 3/4/17, mintaspriggs via MS EXCEL AND VBA MACROS

 wrote:

  Subject: Re: $$Excel-Macros$$ How to make dynamic formula
 for value change on fix date every month
  To: excel-macros@googlegroups.com
  Date: Saturday, March 4, 2017, 8:02 AM

  On Sat, 3/4/17, Sunil Kumar Yadav 
  wrote:

   Subject: Re: $$Excel-Macros$$ How to make dynamic
 formula
  for value change on fix date every month
   To: excel-macros@googlegroups.com
   Date: Saturday, March 4, 2017, 7:10 AM

   Dear Paul,
   Thank you so much for your support
   but I don't have need formula calculation start from
   today. It should be start from my provided
 date...pls
   recheck that time my file i am sure you will be got
 my
   query.
   On Mar 4, 2017 1:58 AM,
   "Paul Schreiner" 
   wrote:
   First of all, your IF() statement:A nested if
 statement
  will evaluate each section
   until it finds a true() option.So, in
   the first case:IF(TODAY()<=42750evaluates
   false, that means today is > 42750So
   the second part: IF(AND(TODAY()>=42751  HAS to be
 true,
  so
   there's no reason to test it!Your
   IF statement could be simplified
  to:IF(TODAY()<=42750,0,
   IF(TODAY()<=42781,1.5,
   IF(TODAY()<=42809,3,
   IF(TODAY()<=42840,4.5,
   IF(TODAY()<=42870,6,
   IF(TODAY()<=42901,7.5,
   IF(TODAY()<=42931,9,
   IF(TODAY()<=42962,10.5,
   IF(TODAY()<=42993,12,
   IF(TODAY()<=43023,13.5,
   IF(TODAY()<=43054,15,
   IF(TODAY()<=43084,16.5,
   IF(TODAY()>=43085,18,0
   )
   But,
   you can simplify it even more.You're
   using the 15th of the month as the "break
   point".So,
   if you were to subtract 15 days, you'd be in the
   "same" month if the day is > 15, and the
   PREVIOUS month if it is before the 15th.Basically,
   by subtracting 15, you're setting the "break
   point" as the first of the month.So,
   if you determine the month number: (MONTH(A5-15))
 you
  could
   say you want 1.5 for each month, or:MONTH(A6-15)
   * 15Now,
   the issue is with the first half of
 January.subtracting
   15 makes it December of the PREVIOUS year, and
 therefore
   should be 0 instead of 18.
   so,
   you need to check to see if the offset year is the
 same as
   the current year:=IF(YEAR(A5-15)
   <> YEAR(TODAY()),0, MONTH(A5-15)* 1.5)
   This
   seems match the same as your sample values for rows
   5-9,but
   I'm not sure what you were doing with rows
   12-16Why
   does 16-Mar in row 8 result in 4.5, but 16-Mar in row
 13
  is
   supposed to be 1.5 ???I'm
   not sure what the rules you're using here.
   as
   for your second query:
   You're
   basically wanting to round off your number to the
 nearest
   1/2.You
   can accomplish this by first doubling the number and
   removing the decimal portion(extract
   just the integer portion)then
   divide it by 2:=INT(A23*2)/2
   this
   works for your samples.
   hope
   this helps.

    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 Friday, March 3, 2017 12:08 PM,
   Sunil Kumar Yadav 
   wrote:

    Dear All,
   I have two query
   for automatically update value on one fixed date,
 have
   created formula but need dynamic formula.

   Formula:IF(TODAY()<=42750,0,IF(AND(
   TODAY()>=42751,TODAY()<=42781)
   ,1.5,IF(AND(TODAY()>=42782,
  TODAY()<=42809),3,IF(AND(
   TODAY()>=42810,TODAY()<=42840)
   ,4.5,IF(AND(TODAY()>=42841,
  TODAY()<=42870),6,IF(AND(
   TODAY()>=42871,TODAY()<=42901)
   ,7.5,IF(AND(TODAY()>=42902,
  TODAY()<=42931),9,IF(AND(
   TODAY()>=42932,TODAY()<=42962)
   ,10.5,IF(AND(TODAY()>=42963,
   TODAY()<=42993),12,IF(AND(
   TODAY()>=42994,TODAY()<=43023)
   ,13.5,IF(AND(TODAY()>=43024,
   TODAY()<=43054),15,IF(AND(
   TODAY()>=43055,TODAY()<=43084)
   ,16.5,IF(AND(TODAY()>=43085,
   TODAY()>=43085),18,0)) )))

   Please check excel
   sheet...Thanks in advance for help!
   -- 
   Sky

   "Good, Better, Best!Always listen to your
   heart, because there lives your
   parents.

   -- 

   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

Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month

2017-03-03 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Fri, 3/3/17, Paul Schreiner  wrote:

 Subject: Re: $$Excel-Macros$$ How to make dynamic formula for value change on 
fix date every month
 To: "excel-macros@googlegroups.com" 
 Date: Friday, March 3, 2017, 10:27 PM

 First of all, your IF() statement:A nested if statement will evaluate each 
section
 until it finds a true() option.So, in
 the first case:IF(TODAY()<=42750evaluates
 false, that means today is > 42750So
 the second part: IF(AND(TODAY()>=42751  HAS to be true, so
 there's no reason to test it!Your
 IF statement could be simplified to:IF(TODAY()<=42750,0,
 IF(TODAY()<=42781,1.5,
 IF(TODAY()<=42809,3,
 IF(TODAY()<=42840,4.5,
 IF(TODAY()<=42870,6,
 IF(TODAY()<=42901,7.5,
 IF(TODAY()<=42931,9,
 IF(TODAY()<=42962,10.5,
 IF(TODAY()<=42993,12,
 IF(TODAY()<=43023,13.5,
 IF(TODAY()<=43054,15,
 IF(TODAY()<=43084,16.5,
 IF(TODAY()>=43085,18,0)
 But,
 you can simplify it even more.You're
 using the 15th of the month as the "break
 point".So,
 if you were to subtract 15 days, you'd be in the
 "same" month if the day is > 15, and the
 PREVIOUS month if it is before the 15th.Basically,
 by subtracting 15, you're setting the "break
 point" as the first of the month.So,
 if you determine the month number: (MONTH(A5-15)) you could
 say you want 1.5 for each month, or:MONTH(A6-15)
 * 15Now,
 the issue is with the first half of January.subtracting
 15 makes it December of the PREVIOUS year, and therefore
 should be 0 instead of 18.
 so,
 you need to check to see if the offset year is the same as
 the current year:=IF(YEAR(A5-15)
 <> YEAR(TODAY()),0, MONTH(A5-15)*1.5)
 This
 seems match the same as your sample values for rows
 5-9,but
 I'm not sure what you were doing with rows
 12-16Why
 does 16-Mar in row 8 result in 4.5, but 16-Mar in row 13 is
 supposed to be 1.5 ???I'm
 not sure what the rules you're using here.
 as
 for your second query:
 You're
 basically wanting to round off your number to the nearest
 1/2.You
 can accomplish this by first doubling the number and
 removing the decimal portion(extract
 just the integer portion)then
 divide it by 2:=INT(A23*2)/2
 this
 works for your samples.
 hope
 this helps.

  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 Friday, March 3,
 2017 12:08 PM, Sunil Kumar Yadav
  wrote:

  Dear
 All,
 I have two query for automatically
 update value on one fixed date, have created formula but
 need dynamic formula.

Formula:IF(TODAY()<=42750,0,IF(AND(TODAY()>=42751,TODAY()<=42781),1.5,IF(AND(TODAY()>=42782,TODAY()<=42809),3,IF(AND(TODAY()>=42810,TODAY()<=42840),4.5,IF(AND(TODAY()>=42841,TODAY()<=42870),6,IF(AND(TODAY()>=42871,TODAY()<=42901),7.5,IF(AND(TODAY()>=42902,TODAY()<=42931),9,IF(AND(TODAY()>=42932,TODAY()<=42962),10.5,IF(AND(TODAY()>=42963,TODAY()<=42993),12,IF(AND(TODAY()>=42994,TODAY()<=43023),13.5,IF(AND(TODAY()>=43024,TODAY()<=43054),15,IF(AND(TODAY()>=43055,TODAY()<=43084),16.5,IF(AND(TODAY()>=43085,TODAY()>=43085),18,0)

 Please check excel sheet...Thanks
 in advance for help!
 -- 
 Sky

 "Good, Better, Best!Always
 listen to your heart,
 because there lives your parents.

 -- 

 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 @

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

2017-03-03 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Fri, 3/3/17, Maatangi M. Karthik  wrote:

 Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 
2010 with Datavalidation & VBA
 To: "MS EXCEL AND VBA MACROS" 
 Cc: schreiner_p...@att.net
 Date: Friday, March 3, 2017, 7:16 AM

 Hi there are a few more things I want from the
 excel.

 1. There are some
 formulae in my excel sheet, I would like to convert them 
 to the backend so that the users cannot change them at any
 cost
 2. There are some fields that affect
 these formulae in succession, that is,
  two or three cell values together will make up the formula
 for another 
 cell. I want to be able to capture the input event and the
 formula 
 creation based on this input.
 For example,
 there is a field where a due date gets calculated. And this
 column is dependent on 2 other columns' values. so I
 want to capture those 2 columns' input events and invoke
 the formula once they are filled.
 3. In the
 excel there are 3 fields, Tax,sales price with tax and sales

 price without tax. At present I have given the option of
 entering / 
 choosing the Tax % and entering the without tax price.
 However, there 
 may be cases where the user will know only the with tax
 price and the 
 tax %. this creates double work for them as they have to
 compute the 
 without tax price and then paste it in this excel. I want to
 avoid this 
 double work and give the option for the users to enter price
 in either 
 of the columns and then be able to compute based on which
 one is input.
 4.  Last query for now,

 I tried Locking / hiding the formulae for certain fields;
 however, they 
 don't take effect unless the excel sheet is protected
 and if I protect 
 the sheet, then users are unable to edit / input their
 values where 
 necessary. Is there a VBA workaround for this? Most of the
 date fields have to be locked as well and should not be
 allowed to be changed by users.

 On Friday, 3 March 2017 01:02:22 UTC+5:30, Paul
 Schreiner  wrote:I deleted a
 row and received the "Type Mismatch"
 error.If you select "Debug", you'll
 see that the offending line of code is:   If Target.Value = "OrderStatus"
 ThenPutting a  "watch" on the Target
 variable, you'll see that it isn't a single cell,
 but an array of cells!
 When you change multiple cells (even
 by deleting, or inserting, or copying), then the Change
 event is passed an range ARRAY rather than a single
 range.
 In your case,
 you have a choice.You can add an if() statement
 like:if (Target.count > 1)
 then exit sub
 Or, you can process each
 cell in the target array like:
 dim Targ as
 rangefor each Targ in Target... (replace each occurrence of "Target"
 with "Targ") ...Next
 Targ

 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, March 2,
 2017 12:33 PM, Maatangi M. Karthik  wrote:

  I am absolutely new to
 excel VBA.

 I have a requirement to create an excel to maintain status
 of orders 
 (there are about 6 / 7 order statuses (2 of which are
 OrderStatus(no 
 status), Enquiry and taken as samples here ) and based on
 each status, a
  specific set of actions have to be performed. I have
 created the excel 
 in which there are multiple columns & rows, some of the
 columns have
  data validations either from a reference sheet or entered
 as list in 
 the Data validation part and some have formula
 references.

 What little coding I could understand, I have done that
 based on my 
 teeny weeny bit of knowledge + the ideas that I got from
 checking on 
 various websites. As a result, I am not sure if I have a
 robust code, 
 although, I have some piece of coding to perform certain
 actions based 
 on values change in certain columns.

 Following are the issues that I want help with:

 When inserting / deleting row / rows, get error
 "Type Mismatch error 13"

 The same error appears while certain columns are
 extended down to the cells.

 Same error while cut copy pasting a row

 Although the run time error occurs, the action is
 partially completed

 Earliest response would be much appreciated.

 My sample excel is attached

 -- 

 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

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

2017-03-01 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Thu, 3/2/17, hopkinsruben865 via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
 To: excel-macros@googlegroups.com
 Date: Thursday, March 2, 2017, 6:12 AM

 On Thu, 3/2/17, margaretatolliver via MS EXCEL AND VBA
 MACROS 
 wrote:

  Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on
 Priority
  To: excel-macros@googlegroups.com
  Date: Thursday, March 2, 2017, 6:08 AM

  On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS

  wrote:

   Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on
  Priority
   To: excel-macros@googlegroups.com
   Date: Thursday, March 2, 2017, 5:17 AM

   On Thu, 3/2/17, Pankaj Sharma 
   wrote:

    Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on
   Priority
    To: excel-macros@googlegroups.com
    Date: Thursday, March 2, 2017, 4:16 AM

    resolved
    PJ        

      MIS
    Analyst
        Greater
    Kailash-1, New Delhi.
    Instagram  pj_sharma_Tweeter 
     dude_sharma_pj
    Facebook 
   www.facebook.com/pankajesica143pankajesica143
      We meet
    for a reason, either you're a blessing or a
    lesson...

    On Tue, Feb 28, 2017 at
    11:43 PM, Mohd Sadiq 
    wrote:
    Here is the attached Sample Sheet,  Hope u can
    understand when u will see it :)
    On Tue, Feb 28, 2017 at
    11:37 PM, Mohd Sadiq 
    wrote:
    Firstly Unhide the sheet , and  I need Shift
    wise Staffing / Present basis of business shift which
  is
    mentioned in "A" column 
    I had made Normal some / Split shift
    details in shared shift however I m getting error in
  Night
    Shift when I m trying to used same formula .
    Regards,Sadiq979223
    On Tue,
    Feb 28, 2017 at 9:52 PM, Pankaj Sharma 
    wrote:
    Didn't get your query, what you want to do in
    this sheet, pls mention example with result.
    PJ            

      MIS
    Analyst
        Greater Kailash-1, New
    Delhi.
    Instagram  pj_sharma_Tweeter 
     dude_sharma_pj
    Facebook   www.facebook.com/dude.pj  We meet
    for a reason, either you're a blessing or a
    lesson...

    On
    Tue, Feb 28, 2017 at 9:22 PM, Mohd Sadiq 
    wrote:
    Hello Team ,

    Hope you are doing
    well,

    Here is attached a file
    where I need Interval / Day wise
    staffing which is mentioned in “H” Column, I am
  trying
    it multiple times to fixed
    Night Shift issue but unfortunately I’m not
  getting
    resolution L

    Request you to Pls help on the same
    on priority.

    Regards
    Mohd Sadiq

    -- 

    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/discu
    ssexcel

    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+unsubscribe@googl
    egroups.com.

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

    Visit this group at https://groups.google.com/grou
    p/excel-macros.

    For more options, visit https://groups.google.com/d/op
    tout.

    -- 

    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/discu
    ssexcel

    FORUM RULES

    1) Use

Re: $$Excel-Macros$$ Re: Once IF is met it is not looping

2017-02-23 Thread keisha.fry via MS EXCEL AND VBA MACROS



On Fri, 2/24/17, mintaspriggs via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
 To: excel-macros@googlegroups.com
 Date: Friday, February 24, 2017, 3:56 AM
 
 
 
 On Fri, 2/24/17, silvers.r via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not
 looping
  To: excel-macros@googlegroups.com
  Date: Friday, February 24, 2017, 12:59 AM
  
  
  
  On Thu, 2/23/17, storeythomas725 via MS EXCEL AND VBA
 MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Re: Once IF is met it
 is not
  looping
   To: excel-macros@googlegroups.com
   Date: Thursday, February 23, 2017, 8:50 PM
   
   
   
   On Thu, 2/23/17, martinez.david533 via MS EXCEL AND
 VBA
   MACROS <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Re: Once IF is met it
  is not
   looping
    To: excel-macros@googlegroups.com
    Date: Thursday, February 23, 2017, 2:56 PM
    
    
    
    On Thu, 2/23/17, silvers.r via MS EXCEL AND VBA
  MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ Re: Once IF is met
 it
   is not
    looping
     To: excel-macros@googlegroups.com
     Date: Thursday, February 23, 2017, 7:11 AM
     
     
     ----
     On Wed, 2/22/17, keisha.fry via MS EXCEL AND VBA
   MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ Re: Once IF is met
  it
    is not
     looping
      To: excel-macros@googlegroups.com
      Date: Wednesday, February 22, 2017, 6:21 PM
      
      
      
      On Wed, 2/22/17, georgemartin812 via MS EXCEL AND
    VBA
     MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ Re: Once IF is
 met
   it
     is not
      looping
       To: excel-macros@googlegroups.com
       Date: Wednesday, February 22, 2017, 11:52 AM
       
       
       
       On Wed, 2/22/17, hopkinsruben865 via MS EXCEL
 AND
     VBA
      MACROS
       <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ Re: Once IF is
  met
    it
      is not
       looping
        To: excel-macros@googlegroups.com
        Date: Wednesday, February 22, 2017, 10:38 AM
        
        
        
        On Wed, 2/22/17, spainy via MS EXCEL AND VBA
    MACROS
      <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ Re: Once IF
 is
   met
     it
       is not
        looping
         To: excel-macros@googlegroups.com
         Date: Wednesday, February 22, 2017, 9:46 AM
         
         
        
 
         On Wed, 2/22/17, silvers.r via MS EXCEL AND
   VBA
       MACROS
         <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ Re: Once IF
  is
    met
      it
        is not
         looping
          To: excel-macros@googlegroups.com
          Date: Wednesday, February 22, 2017, 7:40 AM
          
          
         
  
          On Wed, 2/22/17, julienneschindler via MS
    EXCEL
      AND
        VBA
          MACROS <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ Re: Once
 IF
   is
     met
       it
         is not
          looping
           To: excel-macros@googlegroups.com
           Date: Wednesday, February 22, 2017,
 12:07
   AM
           
           
          
   
           On Tue, 2/21/17, libertystringer via MS
   EXCEL
     AND
         VBA
          MACROS
           <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ Re: Once
  IF
    is
      met
        it
          is not
           looping
            To: excel-macros@googlegroups.com
            Date: Tuesday, February 21, 2017, 4:01
  PM
            
            
           
    
            On Tue, 2/21/17, Emamuddin Shah <emt...@gmail.com>
            wrote:
            
             Subject: Re: $$Excel-Macros$$ Re:
 Once
   IF
     is
       met
         it
           is not
            looping
             To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com>
             Cc: schreiner_p...@att.net
             D

Re: $$Excel-Macros$$ Re: Once IF is met it is not looping

2017-02-22 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Wed, 2/22/17, georgemartin812 via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
 To: excel-macros@googlegroups.com
 Date: Wednesday, February 22, 2017, 11:52 AM

 On Wed, 2/22/17, hopkinsruben865 via MS EXCEL AND VBA MACROS

 wrote:

  Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not
 looping
  To: excel-macros@googlegroups.com
  Date: Wednesday, February 22, 2017, 10:38 AM

  On Wed, 2/22/17, spainy via MS EXCEL AND VBA MACROS 

  wrote:

   Subject: Re: $$Excel-Macros$$ Re: Once IF is met it
 is not
  looping
   To: excel-macros@googlegroups.com
   Date: Wednesday, February 22, 2017, 9:46 AM

   On Wed, 2/22/17, silvers.r via MS EXCEL AND VBA
 MACROS

   wrote:

    Subject: Re: $$Excel-Macros$$ Re: Once IF is met it
  is not
   looping
    To: excel-macros@googlegroups.com
    Date: Wednesday, February 22, 2017, 7:40 AM

    On Wed, 2/22/17, julienneschindler via MS EXCEL AND
  VBA
    MACROS 
    wrote:

     Subject: Re: $$Excel-Macros$$ Re: Once IF is met
 it
   is not
    looping
     To: excel-macros@googlegroups.com
     Date: Wednesday, February 22, 2017, 12:07 AM

     On Tue, 2/21/17, libertystringer via MS EXCEL AND
   VBA
    MACROS

     wrote:

      Subject: Re: $$Excel-Macros$$ Re: Once IF is met
  it
    is not
     looping
      To: excel-macros@googlegroups.com
      Date: Tuesday, February 21, 2017, 4:01 PM

      On Tue, 2/21/17, Emamuddin Shah 
      wrote:

       Subject: Re: $$Excel-Macros$$ Re: Once IF is
 met
   it
     is not
      looping
       To: "MS EXCEL AND VBA MACROS" 
       Cc: schreiner_p...@att.net
       Date: Tuesday, February 21, 2017, 3:11 PM

       Dear
       Paul,

       hope you have got
       change to go through the attached files.

       ---Emam

       On Monday,
       February 6, 2017 at 10:01:43 AM UTC+5:30,
   Emamuddin
     Shah
       wrote:Hi Paul,

       Hope you have received my
       email.

       Regards
       Emam

       On
       Wednesday, February 1, 2017 at 12:52:28 PM
   UTC+5:30,
       Emamuddin Shah wrote:Dear Paul,

       i will share my both excel
       sheets, so that you can check where iam wrong
 and
     correct
       it, since the document is confidential i cant
   share
     here,
       plz provide your email id.

       regards
       Emam

       On Thursday, October 20, 2016
       at 7:04:17 PM UTC+5:30, Paul Schreiner
 wrote:Mr.
       Emamuddin,
       I'm
       looking through your code and have encountered
   some
       issues.
       First, your
       sample file is only one sheet,with a Header in
       row 1 and 2 rows of data in 24 columns (A:X)
       In your code, you use:
       sc =
       Sheets.CountWhich, of course sets the
       variable "sc" equal to the total number of
       sheets.
       but, when you use:    For
       c = 1 To 27
        cold(c) =
       Sheets(sc).Cells(c, 3).Value
           Next
       c
       You're loading data from the LAST sheet of the
       workbook.Using your sample file, having
       only 1 sheet, this will use this
 sheet.However,
   your
      variables "c" and
       "cold" IMPLY "column" and
       "Column-Old"
       but your in your loop: the
       Cells() function syntax is
   "Cells(row,column)which
     means
      that your loop is loading ROWS 1 to
       27, column 3 (C) into the cold() array.
       Your next
       loop:For b = lr - (size - 1) To
       lr
       will fail with your sample file, since:lr =
 4size
   =
     100
       so your loop
       is:For b = -95 to 4
       In the first
       iteration, it will fail for row -95 of the
   cells()
       function.
       Of course, I cannot test the code: 
   Workbooks.Open
      Filename:=Sheets(sc).Cells(1,
       8), Password:=Sheets(sc).Cells(10, 8).Value
       because the
       sample file does not have a filename in row 1,
     column
       "H"
       I suggest you utilize the
       "breakpoint" functionality of the VBEditor and
       step through your program one line at a time
 and
     monitor
      the
       variables.
       also, to help you with reading the code, try
   using
       the column LETTER in the cells() function when
   you
       can.
       That is: Cells(1,"C") for

Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM)

2017-02-16 Thread keisha.fry via MS EXCEL AND VBA MACROS



On Thu, 2/16/17, Chandra Shekar  wrote:

 Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding 
weekends with Business hours 9 AM to 8 PM)
 To: excel-macros@googlegroups.com
 Date: Thursday, February 16, 2017, 3:46 PM
 
 Hello
 Paul,
 Thanks a lot.
 Its working fine.
 
 Regards,
 Chandru
 On Wed, Feb 15, 2017 at
 8:21 PM, Paul Schreiner 
 wrote:
 There
 are several ways to approach this.Here's
 the logic I used:first:
 Excel
 date is stored as a number. (the number of days since
 1/1/1900)Excel
 TIME is stored as the decimal part of a day.so, the
 date/time: 19/11/2016 12:10 PM  is actually
 42693.50694Excel
 allows you to DISPLAY this value in a variety of ways, but
 it doesn't change the value.
 That
 means that to determine the time of day without regard to
 the date, you must subtract the "integer" portion
 of the value.
 Now,
 if you worked from Monday, 2-Feb to Friday, 10-Feb, you
 expect the result to show you worked 5 days.However,
 simply subtracting day #42772 from day #42776 gives you a
 DIFFERENCE of 4 instead of 5!So,
 you have to be careful with date arithmetic...
 Excel
 provides two functions:NetworkdaysNetworkdays.intl
 Networkdays.intl
 provides a means to define which days are your
 "weekend".(some
 people may work Thu-Fri-Sat-Sun-Mon and have Tuesday and
 Wednesday off for their "weekend")This
 also provides a means to say ALL days are workdays!
 (thereby, "including weekends").
 In
 the file attached, I created a sheet with Named Ranges for
 Start_Time, End_Time and HolidayListYou
 can add/remove dates to this HolidayList as appropriate to
 your needs.
 The
 logic is to first calculate the number of workdays between
 the Start date and End data.=NETWORKDAYS.INTL($A2,$B2,"
 011",HolidayList)Now,
 the End_Time - Start_Time gives you the fractional part of a
 day that represents a "full" workday.Multiplying
 this times the number of workdays results in the number of
 hours if full days are worked.
 This
 number needs to be adjusted based on the actual start/end
 time.If
 the start or end day is on a weekend, then the actual
 start/end time is disregarded.IF(WEEKDAY($A2,2)>5,0
 Otherwise,
 for the start time, subtract the actual start time (A2 -
 int(A2)) from the scheduled
 "Start_Time".Now,
 if the person started BEFORE the scheduled start time, this
 value will be negative and should be disregarded. (unless
 you wish to calculate "overtime", or allow for a
 person to come in 30 minutes early and leave 30 minutes
 early?)
 so,
 to use only positive numbers, you can use:
 MAX(($A2-INT($A2))-Start_Time, 0)
 For
 End time, the arithmetic is reversed:
 MAX(End_Time-($B2-INT($B2)),0)
 So,
 calculating the full working days, and removing the
 adjustments for start/end time, you get:=NETWORKDAYS.INTL($A2,$B2,"
 011",HolidayList)*(End_ Time-Start_Time)
 -(IF(WEEKDAY($A2,2)>5,0,MAX($
 A2-INT($A2)-Start_Time,0)))
 -(IF(WEEKDAY($B2,2)>5,0,MAX(
 End_Time-($B2-INT($B2)),0)))
 But
 if you wish to use it as a number of hours, you'll need
 to multiply it by 24.
 To
 calculate these values and INCLUDE weekends, simply change
 the Networkdays.Intl formula to include "000"
 and remove the IF(WEEKDAY( test:=NETWORKDAYS.INTL($A2,$B2,"
 000",HolidayList)*(End_ Time-Start_Time)
 -(MAX($A2-INT($A2)-Start_Time,
 0))
 -(MAX(End_Time-($B2-INT($B2)),
 0))
 Note:
 What
 this technique does NOT do is check to see if the Start or
 End date is one of the listed holidays.Nor
 does it account for any time outside of the core
 "Business Hours".
 Hope
 this helps.
 
 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 Wednesday,
 February 15, 2017 7:17 AM, Chandra Shekar 
 wrote:
   
 
  Hello,
 Needed difference between
 times(Including and excluding weekends with Business hours
 from 9AM to 8PM)
 Could
 you help me on this attachment.
 
 Regards,
 Chandru
 
 
 
 
 
 -- 
 
 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$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM)

2017-02-15 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Wed, 2/15/17, georgemartin812 via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding 
weekends with Business hours 9 AM to 8 PM)
 To: excel-macros@googlegroups.com
 Date: Wednesday, February 15, 2017, 9:04 PM

 On Wed, 2/15/17, keisha.fry via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:

  Subject: Re: $$Excel-Macros$$ Difference between
 times(Including and excluding weekends with Business hours 9
 AM to 8 PM)
  To: excel-macros@googlegroups.com
  Date: Wednesday, February 15, 2017, 5:11 PM

  On Wed, 2/15/17, Paul Schreiner <schreiner_p...@att.net>
  wrote:

   Subject: Re: $$Excel-Macros$$ Difference between
  times(Including and excluding weekends with Business hours
 9
  AM to 8 PM)
   To: "excel-macros@googlegroups.com"
  <excel-macros@googlegroups.com>
   Date: Wednesday, February 15, 2017, 4:51 PM

   There are several ways to approach this.Here's the
 logic I
  used:first: Excel date is stored as a number. (the number
 of
  days
   since 1/1/1900)Excel TIME is stored as the decimal
 part of
  a
   day.so, the date/time: 19/11/2016 12:10 PM  is
 actually
   42693.50694Excel allows you to DISPLAY this value in
 a
  variety
   of ways, but it doesn't change the value.
   That means that to determine the time of day without
   regard to the date, you must subtract the
   "integer" portion of the value.
   Now, if you worked from Monday, 2-Feb to Friday,
   10-Feb, you expect the result to show you worked 5
   days.However, simply subtracting day #42772 from day
   #42776 gives you a DIFFERENCE of 4 instead of 5!So,
 you
  have to be careful with date
   arithmetic...
   Excel provides two
 functions:NetworkdaysNetworkdays.intl
   Networkdays.intl provides a means to define which
   days are your "weekend".(some people may work
  Thu-Fri-Sat-Sun-Mon and have
   Tuesday and Wednesday off for their
   "weekend")This also provides a means to say ALL days
 are
   workdays! (thereby, "including
   weekends").
   In the file attached, I created a sheet with Named
   Ranges for Start_Time, End_Time and HolidayListYou
 can
  add/remove dates to this HolidayList as
   appropriate to your needs.
   The logic is to first calculate the number of
   workdays between the Start date and End
  data.=NETWORKDAYS.INTL($A2,$B2,"011",HolidayList)Now,
  the End_Time - Start_Time gives you the
   fractional part of a day that represents a "full"
   workday.Multiplying this times the number of
 workdays
  results
   in the number of hours if full days are worked.
   This number needs to be adjusted based on the actual
   start/end time.If the start or end day is on a
 weekend,
  then the
   actual start/end time is
  disregarded.IF(WEEKDAY($A2,2)>5,0
   Otherwise, for the start time, subtract the actual
   start time (A2 - int(A2)) from the scheduled
   "Start_Time".Now, if the person started BEFORE the
  scheduled start
   time, this value will be negative and should be
  disregarded.
   (unless you wish to calculate "overtime", or allow
   for a person to come in 30 minutes early and leave
 30
   minutes early?)
   so, to use only positive numbers, you can use:
   MAX(($A2-INT($A2))-Start_Time,0)
   For End time, the arithmetic is reversed:
   MAX(End_Time-($B2-INT($B2)),0)
   So, calculating the full working days, and removing
   the adjustments for start/end time, you
  get:=NETWORKDAYS.INTL($A2,$B2,"011",HolidayList)*(End_Time-Start_Time)

 -(IF(WEEKDAY($A2,2)>5,0,MAX($A2-INT($A2)-Start_Time,0)))

 -(IF(WEEKDAY($B2,2)>5,0,MAX(End_Time-($B2-INT($B2)),0)))
   But if you wish to use it as a number of hours,
   you'll need to multiply it by 24.
   To calculate these values and INCLUDE weekends,
   simply change the Networkdays.Intl formula to
 include
   "000" and remove the IF(WEEKDAY(

 test:=NETWORKDAYS.INTL($A2,$B2,"000",HolidayList)*(End_Time-Start_Time)
   -(MAX($A2-INT($A2)-Start_Time,0))
   -(MAX(End_Time-($B2-INT($B2)),0))
   Note:
   What this technique does NOT do is check to see if
   the Start or End date is one of the listed
   holidays.Nor does it account for any time outside of
 the
  core
   "Business Hours".
   Hope this helps.

   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 Wednesday,
   February 15, 2017 7:17 AM, Chandra Shekar
   <chandrashekarb@gmail.c

Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM)

2017-02-15 Thread keisha.fry via MS EXCEL AND VBA MACROS



On Wed, 2/15/17, Paul Schreiner  wrote:

 Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding 
weekends with Business hours 9 AM to 8 PM)
 To: "excel-macros@googlegroups.com" 
 Date: Wednesday, February 15, 2017, 4:51 PM
 
 There are several ways to approach this.Here's the logic I used:first: Excel 
date is stored as a number. (the number of days
 since 1/1/1900)Excel TIME is stored as the decimal part of a
 day.so, the date/time: 19/11/2016 12:10 PM  is actually
 42693.50694Excel allows you to DISPLAY this value in a variety
 of ways, but it doesn't change the value.
 That means that to determine the time of day without
 regard to the date, you must subtract the
 "integer" portion of the value.
 Now, if you worked from Monday, 2-Feb to Friday,
 10-Feb, you expect the result to show you worked 5
 days.However, simply subtracting day #42772 from day
 #42776 gives you a DIFFERENCE of 4 instead of 5!So, you have to be careful 
with date
 arithmetic...
 Excel provides two functions:NetworkdaysNetworkdays.intl
 Networkdays.intl provides a means to define which
 days are your "weekend".(some people may work Thu-Fri-Sat-Sun-Mon and have
 Tuesday and Wednesday off for their
 "weekend")This also provides a means to say ALL days are
 workdays! (thereby, "including
 weekends").
 In the file attached, I created a sheet with Named
 Ranges for Start_Time, End_Time and HolidayListYou can add/remove dates to 
this HolidayList as
 appropriate to your needs.
 The logic is to first calculate the number of
 workdays between the Start date and End 
data.=NETWORKDAYS.INTL($A2,$B2,"011",HolidayList)Now, the End_Time - 
Start_Time gives you the
 fractional part of a day that represents a "full"
 workday.Multiplying this times the number of workdays results
 in the number of hours if full days are worked.
 This number needs to be adjusted based on the actual
 start/end time.If the start or end day is on a weekend, then the
 actual start/end time is disregarded.IF(WEEKDAY($A2,2)>5,0
 Otherwise, for the start time, subtract the actual
 start time (A2 - int(A2)) from the scheduled
 "Start_Time".Now, if the person started BEFORE the scheduled start
 time, this value will be negative and should be disregarded.
 (unless you wish to calculate "overtime", or allow
 for a person to come in 30 minutes early and leave 30
 minutes early?)
 so, to use only positive numbers, you can use:
 MAX(($A2-INT($A2))-Start_Time,0)
 For End time, the arithmetic is reversed:
 MAX(End_Time-($B2-INT($B2)),0)
 So, calculating the full working days, and removing
 the adjustments for start/end time, you 
get:=NETWORKDAYS.INTL($A2,$B2,"011",HolidayList)*(End_Time-Start_Time)
 -(IF(WEEKDAY($A2,2)>5,0,MAX($A2-INT($A2)-Start_Time,0)))
 -(IF(WEEKDAY($B2,2)>5,0,MAX(End_Time-($B2-INT($B2)),0)))
 But if you wish to use it as a number of hours,
 you'll need to multiply it by 24.
 To calculate these values and INCLUDE weekends,
 simply change the Networkdays.Intl formula to include
 "000" and remove the IF(WEEKDAY(
 test:=NETWORKDAYS.INTL($A2,$B2,"000",HolidayList)*(End_Time-Start_Time)
 -(MAX($A2-INT($A2)-Start_Time,0))
 -(MAX(End_Time-($B2-INT($B2)),0))
 Note:
 What this technique does NOT do is check to see if
 the Start or End date is one of the listed
 holidays.Nor does it account for any time outside of the core
 "Business Hours".
 Hope this helps.
 
 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 Wednesday,
 February 15, 2017 7:17 AM, Chandra Shekar
  wrote:
   
 
  Hello,
 Needed difference between
 times(Including and excluding weekends with Business hours
 from 9AM to 8PM)
 Could
 you help me on this attachment.
 
 Regards,
 Chandru
 
 
 
 
 
 -- 
 
 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

Re: $$Excel-Macros$$ keep active in memory variables, array variables

2017-02-09 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Thu, 2/9/17, Paul Schreiner  wrote:

 Subject: Re: $$Excel-Macros$$ keep active in memory variables, array variables
 To: "excel-macros@googlegroups.com" 
 Date: Thursday, February 9, 2017, 6:56 PM

 The
 answer is:Yes.
 The
 long version of the answer involves describing the
 "scope" of variables.
 First
 of all,in
 each VBA module, I recommend using 
 Option
 Explicit
 as
 the first line of the module.This
 forces the compiler to check that all variables are
 EXPLICITLY declared.without
 it, the first time you use a variable, the compiler will
 define it as type "variant".although
 I've had it auto-define a variable as an
 integer.
 As
 for declaring variables: placement is important!You declare a variable with 
the Dimstatement.
 Dim nrow as
 integer
 declares
 the variable "nrow" as an integer.
 If
 you put this WITHIN a subroutine, like

 Sub
 Count_Rows()  
 Dim nRow as Integer...End
 Sub
 then
 the variable is ONLY recognized for use WITHIN the
 subroutine.That
 means that if you have a second sub and you want to use the
 value that you got from the Count_Rows sub, you
 cannot.
 If
 you declare the variable OUTSIDE of a subroutine, it is
 available for all subroutines in the module.
 -Option
 ExplicitDim
 nRowSub
 Count_Rows()  
 For nRow = 1 to 100
 ...   Next
 nRowEnd
 Sub
 sub
 Work_Backwards() 
 Dim inx 
 Count_Rows 
 for inx = nrow to 1 step -1...  next
 inxend
 sub
 ---
 But,
 if you have multiple modules, or write your code within the
 sheet module, then those variables are only available to
 that module, not others.
 variables
 defined with the Dim function are not
 "persistent".That
 is: they are cleared when the macro stops running.
 to
 make a variable "persistent", you need to use the
 "Global" (or "Public") declaration
 keyword.
 Option
 ExplicitPublic
 nRowSub
 Count_Rows...End
 Sub
 This MUST be done outside of a macro, and in a
 "Standard" module (not a Sheet module)
 It is
 perfectly legal to declare a variable as a
 "Public" variable and also within a subroutine as
 a "local" variable.
 When the macros run, they
 will treat these as two separate variables.
 As for array
 variables:There are many ways of
 declaring them, depending on how you plan to use
 them.
 If, for instance, you don't know what size
 they will be until run-time,you can
 declare the variable like:
 Dim sArray
 then, once
 you decide on a size, you can re-dimension it:
 ReDim
 sArray(nRow) Preserve
 Use
 the VBA help to read up on declaring arrays.
 hope this
 helps.

 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, February
 9, 2017 10:01 AM, "wltrp...@gmail.com"
  wrote:

  Is it possible in an Excel
 workbook as long as it is open,
 to keep active in memory variables, array variables? And
 those, when running a
 program / script vba or macro is finished. 

 How to declare
 variables, array variables? 

 -- 

 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

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

2017-01-28 Thread keisha.fry via MS EXCEL AND VBA MACROS



On Sat, 1/28/17, kenyattafreed via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
 To: excel-macros@googlegroups.com
 Date: Saturday, January 28, 2017, 10:24 AM
 
 
 
 On Sat, 1/28/17, mintaspriggs via MS EXCEL AND VBA MACROS
 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re: Simple function but it
 returns #VALUE
  To: excel-macros@googlegroups.com
  Date: Saturday, January 28, 2017, 9:50 AM
  
  
  
  On Sat, 1/28/17, mintaspriggs via MS EXCEL AND VBA MACROS
  
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Re: Simple function but
 it
  returns #VALUE
   To: excel-macros@googlegroups.com
   Date: Saturday, January 28, 2017, 5:22 AM
   
   
   
   On Fri, 1/27/17, Greg Della-Croce 
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Re: Simple function but
  it
   returns #VALUE
    To: excel-macros@googlegroups.com
    Date: Friday, January 27, 2017, 4:00 PM
    
    You all caught the
    problem with this solution (which I still like).  I
  need
   to
    find a String within a String, not an exact String
  match.
    
    But I think I found where I went wrong.  The InStr
   command
    is very picky about what parms you use.   Thus when
  I
    changed this to InStr(1, Cell.Value, ChkFor,
   vbTextCompare)
    the function worked.  
    
    Greg
    Della-CroceSkype:
    gdellacroce55Cell: 407-408-2572greg_della-cr...@sil.org"If
   you assume you know the
    answer, you will miss having a breakthrough. It’s
  okay
   to
    do what you did yesterday, but it will never be
  amazing
    again.". - Rod Favarod, CEO of
    Spredfast
    
    
    
    
    
    On Fri, Jan 27, 2017
    at 4:43 AM, martinez.david533 via MS EXCEL AND VBA
  MACROS
    
    wrote:
    
    
    -- --
    
    On Fri, 1/27/17, georgemartin812
    via MS EXCEL AND VBA MACROS  wrote:
    
    
    
     Subject: Re: $$Excel-Macros$$ Re: Simple function
  but it
    returns #VALUE
    
     To: excel-macros@googlegroups.com
    
     Date: Friday, January 27, 2017, 9:50 AM
    
    
    
    
    
     -- --
    
     On Thu, 1/26/17, libertystringer via MS EXCEL AND
  VBA
    MACROS
    
     
    
     wrote:
    
    
    
      Subject: Re: $$Excel-Macros$$ Re: Simple function
  but
   it
    
     returns #VALUE
    
      To: excel-macros@googlegroups.com
    
      Date: Thursday, January 26, 2017, 10:47 PM
    
    
    
    
    
      -- --
    
      On Thu, 1/26/17, julienneschindler via MS EXCEL
  AND VBA
    
      MACROS 
    
      wrote:
    
    
    
       Subject: Re: $$Excel-Macros$$ Re: Simple
  function but
    
     it
    
      returns #VALUE
    
       To: excel-macros@googlegroups.com
    
       Date: Thursday, January 26, 2017, 9:29 PM
    
      
    
      
    
       -- --
    
       On Thu, 1/26/17, Vicky 
    
       wrote:
    
      
    
        Subject: Re: $$Excel-Macros$$ Re: Simple
  function
   but
    
      it
    
       returns #VALUE
    
        To: excel-macros@googlegroups.com
    
        Date: Thursday, January 26, 2017, 6:53 PM
    
       
    
        Hi Greg,
    
        The given code only works when you are
  comparing
    
        the contents of the entire cell from one in
  the
    
      range. It
    
        won't work if your chkFor cell is matching
    partially
    
        with one of the cells from range.
    
        Regards,Vicky
    
        On 26-Jan-2017 9:47
    
        PM, "Greg Della-Croce" 
    
        wrote:
    
        Vicky, thanks for the idea.   I will see how
  it
    
        works for me.  I appreciate the time/effort
  you put
    
      in to
    
        help me!
    
        Greg
    
       
    
        Greg
    
        Della-CroceSkype:
    
        gdellacroce55Cell:
  407-408-2572Greg_Della-Croce@
    sil.org"If
    
       you assume you know the
    
        answer, you will miss having a breakthrough.
  It’s
    
      okay
    
       to
    
        do what you did yesterday, but it will never
  be
    
      amazing
    
        again.". - Rod Favarod, CEO of
    
        Spredfast
    
       
    
       
    
       
    
       
    
       
    
        On Thu, Jan 26, 2017
    
        at 11:13 AM, Vicky 
    
        wrote:
    
        Hi Greg,
    
        I have found a solution. Hope this

Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

2017-01-24 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Tue, 1/24/17, storeythomas725 via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES
 To: excel-macros@googlegroups.com
 Date: Tuesday, January 24, 2017, 11:29 AM

 On Tue, 1/24/17, silvers.r via MS EXCEL AND VBA MACROS

 wrote:

  Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR
 MULTIPLE TIMES
  To: excel-macros@googlegroups.com
  Date: Tuesday, January 24, 2017, 8:37 AM

  On Tue, 1/24/17, silvers.r via MS EXCEL AND VBA MACROS

  wrote:

   Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A
 RANGE FOR
  MULTIPLE TIMES
   To: excel-macros@googlegroups.com
   Date: Tuesday, January 24, 2017, 6:22 AM

   On Tue, 1/24/17, libertystringer via MS EXCEL AND
 VBA
  MACROS

   wrote:

    Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A
  RANGE FOR
   MULTIPLE TIMES
    To: excel-macros@googlegroups.com
    Date: Tuesday, January 24, 2017, 1:27 AM

    On Mon, 1/23/17, julienneschindler via MS EXCEL AND
  VBA
    MACROS 
    wrote:

     Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A
   RANGE FOR
    MULTIPLE TIMES
     To: excel-macros@googlegroups.com
     Date: Monday, January 23, 2017, 10:58 PM

     On Mon, 1/23/17, GENIUS 
     wrote:

      Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A
    RANGE FOR
     MULTIPLE TIMES
      To: "MS EXCEL AND VBA MACROS" 
      Cc: schreiner_p...@att.net
      Date: Monday, January 23, 2017, 5:13 PM

      That's
      great, Thank you very much for your help

      -- 

      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.
      n anii '50  relatiile romano-sovietice au
  evoluat
    de
     la o stransa cooperare la o distantare 
   ajungandu-se
     chiar la o autonomie a Partidului Comunist din
   Romania si
    la
     o relativa independenta  a statului roman.
   Elementele
     noi in relatiile dintre cele doua state au fost
    determinate
     de neincrederea personala dintre Gheorghiu-Dej si
    Hrusciov.
     O astfel de orientare politica era menita  in
   conceptia
     liderilor comunisti de la Bucuresti  sa afirme 
 cu
     si mai multa putere  rolul partidului comunist
 in
   ochii
     maselor populare.

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

Re: $$Excel-Macros$$ something wrong with the attach macro

2017-01-20 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Fri, 1/20/17, julienneschindler via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ something wrong with the attach macro
 To: excel-macros@googlegroups.com
 Date: Friday, January 20, 2017, 10:15 AM

 On Thu, 1/19/17, storeythomas725 via MS EXCEL AND VBA MACROS

 wrote:

  Subject: Re: $$Excel-Macros$$ something wrong with the
 attach macro
  To: excel-macros@googlegroups.com
  Date: Thursday, January 19, 2017, 3:56 PM

  On Thu, 1/19/17, GENIUS 
  wrote:

   Subject: Re: $$Excel-Macros$$ something wrong with
 the
  attach macro
   To: "MS EXCEL AND VBA MACROS" 
   Cc: schreiner_p...@att.net
   Date: Thursday, January 19, 2017, 9:06 AM

   That's
   working for me as well, thank 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
  https://groups.google.com/group/excel-macros.

   For more options, visit
  https://groups.google.com/d/optout.
   erspectiva celor aproape 140 de ani  care au trecut
 de
  la evenimentele din 1859  confirma  in egala
  masura  patriotismul  dar si remarcabila abilitate
  a oamenilor politici ai timpului  care au stiut 
  printr-o actiune indrazneata  sa puna Marile Puteri in
  fata faptului implinit  si sa depaseasca obstacolele pe
  care interesele contradictorii ale acestora le asezau in
  cale i Unirii. De asemenea  ca in atatea randuri in
  istoria ulterioara a tarii  deci?ia finala s-a datorat
  exceptionalei abnegatii pe care natiunea romana a aratat-o
  acestei cauze. Presiunea populara de la Bucuresti  din
  istoricele zile de 22-24 ianuarie 1859  legitima o mare
  aspiratie si-i dadea trainicia eternitatii.

  -- 
  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.egulament
 clar  s-a lucrat prin circulare redactate  de
 regula  de primul

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

Re: $$Excel-Macros$$ How to use Index Match for two different files

2017-01-15 Thread keisha.fry via MS EXCEL AND VBA MACROS



On Sun, 1/15/17, mintaspriggs via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files
 To: excel-macros@googlegroups.com
 Date: Sunday, January 15, 2017, 10:49 AM
 
 
 
 On Sun, 1/15/17, libertystringer via MS EXCEL AND VBA MACROS
 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ How to use Index Match for
 two different files
  To: excel-macros@googlegroups.com
  Date: Sunday, January 15, 2017, 10:03 AM
  
  
  
  On Sun, 1/15/17, julienneschindler via MS EXCEL AND VBA
  MACROS 
  wrote:
  
   Subject: Re: $$Excel-Macros$$ How to use Index Match
 for
  two different files
   To: excel-macros@googlegroups.com
   Date: Sunday, January 15, 2017, 6:21 AM
   
   
   
   On Sun, 1/15/17, martinez.david533 via MS EXCEL AND
 VBA
   MACROS 
   wrote:
   
    Subject: Re: $$Excel-Macros$$ How to use Index Match
  for
   two different files
    To: excel-macros@googlegroups.com
    Date: Sunday, January 15, 2017, 4:39 AM
    
    
    
    On Sun, 1/15/17, silvers.r via MS EXCEL AND VBA
  MACROS
    
    wrote:
    
     Subject: Re: $$Excel-Macros$$ How to use Index
 Match
   for
    two different files
     To: excel-macros@googlegroups.com
     Date: Sunday, January 15, 2017, 4:25 AM
     
     
     
     On Sat, 1/14/17, Devendra Sahay 
     wrote:
     
      Subject: Re: $$Excel-Macros$$ How to use Index
  Match
    for
     two different files
      To: excel-macros@googlegroups.com
      Date: Saturday, January 14, 2017, 7:37 AM
      
      Hi Paul,
      Yes both columns have only one column, I just
      wanted to check howmany values ar availble in the
    dump
     using
      vlookup. 
      I just changed the column referrence in the code
      but its not running properly. 
      Thanks,Devendra
      On Fri, Jan 13, 2017
      at 5:57 PM, Paul Schreiner 
      wrote:
      I'm
      sorry.I'm
      not sure what you're trying to do!
      Your
      two attachments have a single column of data.They
      have (7) values in common, but I'm not sure what
  you
      want to do with them.What
      macro did you modify?
      
       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 Friday,
      January 13, 2017 2:29 AM, Devendra Sahay  wrote:
        
      
       Hi Paul
      I tried to modify the code according
      to attached data set, but its not going
      through. Would you, please look into
      this. 
      Both details
      are extracted from ERP, So need to convert them
  as
    number
      before running the macro.
      On Tue, Jan 10, 2017 at 6:56 PM, Paul
      Schreiner 
     wrote:
      Yes,
      Excel/VBA has nearly unlimited flexibility.But
      I have no way of knowing what YOU think the
     possibilities
      are and what the columns potentially can be.
      I have applications in
      which I define variables for the
     different heading/column
      combinations.then write to these
      column numbers.That way, I can rearrange
  the output
     columns in
      any order and the report automatically writes to
    the
      appropriate column.
      but I have no way of determining what you
      want unless you can describe it in a way I can
      understand. 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
      Tuesday, January 10, 2017 4:07 AM, Devendra Sahay
    
      wrote:
        
      
       Hi Paul,
      Code is
      working fine, but can we make this code more
  flexible
    like
      It can identify the header name itself because
  right
    now
     its
      configured to first column as Order ID. Column
      header of "A" can be anything. If you can do so,
      would be really good because then we can use the
  same
    file
      for multiple data

Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula

2017-01-13 Thread keisha.fry via MS EXCEL AND VBA MACROS



On Fri, 1/13/17, spainy via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
 To: excel-macros@googlegroups.com
 Date: Friday, January 13, 2017, 11:42 AM
 
 
 
 On Fri, 1/13/17, karleenbiggs via MS EXCEL AND VBA MACROS
 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address
 formula
  To: excel-macros@googlegroups.com
  Date: Friday, January 13, 2017, 9:47 AM
  
  
  
  On Fri, 1/13/17, kenyattafreed via MS EXCEL AND VBA MACROS
  
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Index+Match+Indirect+Address
  formula
   To: excel-macros@googlegroups.com
   Date: Friday, January 13, 2017, 9:05 AM
   
   
   
   On Fri, 1/13/17, hopkinsruben865 via MS EXCEL AND
 VBA
  MACROS
   
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  Index+Match+Indirect+Address
   formula
    To: excel-macros@googlegroups.com
    Date: Friday, January 13, 2017, 6:48 AM
    
    
    
    On Fri, 1/13/17, amar takale 
    wrote:
    
     Subject: Re: $$Excel-Macros$$
   Index+Match+Indirect+Address
    formula
     To: excel-macros@googlegroups.com
     Date: Friday, January 13, 2017, 6:20 AM
     
     
     
     Dear Paul Sir
     Good Morning
     Sorry for Late reply.
     
     
      
     
     Actually Index match is as
     per my thinking formula it not
     fix for this situation , you can also give
 another
   formula
     or option. I am
     thinking index match formula match criteria field
   like
    year
     & net sales
     & address find sheet name. So I ask for that.
   which I
     attached index
     formula file for only your reference sheet where
   index
     match+indirect formula
     extract data but internal sheet only & I want
   extract
    it
     external workbooks
     in folder.
     
      
     
     Step
     
     1)  Extract
     All sheet from software in folder & next time
   only
     overwrite on it if any
     updation.
     
     2)  Create
     One output sheet in folder where more than 100
 sheets
   data
     extract
     fieldwise,yearwise & worksheets wise through
   formula
    OR
     VBA.
     
     3)  Suggest
     formula or VBA
     
      
     
      
     
     Regards
     
     Amar
     
      
     
     
     On Thu, Jan 12, 2017 at
     2:35 PM, mintaspriggs via MS EXCEL AND VBA MACROS
   
     wrote:
     
     
     -- --
     
     On Thu, 1/12/17, storeythomas725
     via MS EXCEL AND VBA MACROS  wrote:
     
     
     
      Subject: Re: $$Excel-Macros$$
    Index+Match+Indirect+Address
     formula
     
      To: excel-macros@googlegroups.com
     
      Date: Thursday, January 12, 2017, 3:26 AM
     
     
     
     
     
      -- --
     
      On Wed, 1/11/17, Paul Schreiner 
     
      wrote:
     
     
     
       Subject: Re: $$Excel-Macros$$
     Index+Match+Indirect+Address
     
      formula
     
       To: "excel-macros@googlegroups.com
     "
     
      
     
       Date: Wednesday, January 11, 2017, 3:56 PM
     
     
     
       OK.
     
       It
     
       sounds like you're saying that you have some
     
       reporting software that generates a report
     
       file.But
     
       evidently I don't understand what it is you're
     
       trying to do.
     
       Can
     
       you describe it step-by-step with
 examples?What
     
       does the file generated by your software look
     
       like?what do you do with it?
     
       I have the two files you sent originally, but
 I
     
       don't see what information is common between
 the
     two
     
       files,so I don't know how you get from the
     
       "Index-Match" file to the "output"
     
       file. 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 Tuesday, January 10, 2017 11:48
     
       PM, amar takale 
     
      wrote:
     
     
     
     
     
        Dear Paul
     
     
     
       Good Morning.
     
     
     
       Exact explanation by

Re: $$Excel-Macros$$ move sheets to a workbook

2017-01-07 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Sun, 1/8/17, spainy via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ move sheets to a workbook
 To: excel-macros@googlegroups.com
 Date: Sunday, January 8, 2017, 6:45 AM

 On Sun, 1/8/17, libertystringer via MS EXCEL AND VBA MACROS

 wrote:

  Subject: Re: $$Excel-Macros$$ move sheets to a workbook
  To: excel-macros@googlegroups.com
  Date: Sunday, January 8, 2017, 6:18 AM

  On Sun, 1/8/17, martinez.david533 via MS EXCEL AND VBA
  MACROS 
  wrote:

   Subject: Re: $$Excel-Macros$$ move sheets to a
 workbook
   To: excel-macros@googlegroups.com
   Date: Sunday, January 8, 2017, 5:35 AM

   On Sat, 1/7/17, georgemartin812 via MS EXCEL AND VBA
  MACROS

   wrote:

    Subject: Re: $$Excel-Macros$$ move sheets to a
  workbook
    To: excel-macros@googlegroups.com
    Date: Saturday, January 7, 2017, 11:41 PM

    On Sat, 1/7/17, julienneschindler via MS EXCEL AND
  VBA
    MACROS 
    wrote:

     Subject: Re: $$Excel-Macros$$ move sheets to a
   workbook
     To: excel-macros@googlegroups.com
     Date: Saturday, January 7, 2017, 11:12 PM

     On Fri, 1/6/17, Paul Schreiner 
     wrote:

      Subject: Re: $$Excel-Macros$$ move sheets to a
    workbook
      To: "excel-macros@googlegroups.com"

      Date: Friday, January 6, 2017, 8:06 PM

      How do
      you envision this working?Say:You
      have folders:January
      2016February
      2016March
      2016April
      2016May
      2016June
      2016in
      each folder you have 30 files (presumably Excel
      files)In
      your sample file, you said you "want to move all
    thirty
      sheets".Does
      that mean that there is only one sheet in each of
  the
    30
      workbooks,or
      that you only want to move one of the sheets in
  each
      workbook?Also:
      If
      you move the sheets, that means that the original
    workbook
      no longer has the sheetbut
      your new workbook now has 30 sheets.Is
      that what you want? or do you want to COPY the
  data
    from
      each of the 30 sheetsinto
      a single sheet of the new workbook?
      Do
      you want a macro to do all the folders in the
      "parent" folder or do you want to select which
      folder to process?

      Attached
      are two files.Detach
      them and place them in the folder containing the
    monthly
      sub-folders.
      The
      "Template.xlsx" file is used as the basic
  template
      for the report for a given month.The
      macro copies this file to a file called "PETTY
  CASH
    FOR
      " and the name of the folder.
      I
      created two buttons in the Composite_Macro.xlsb
      file.The
      first button creates a list of the sub-folders
      "beneath" the folder where this file
      resides.
      once
      you have the list of folders, put an "X" in
      column B for those you wish to process.
      then
      hit the "Gen Selected" button.
      The
      report files will be in the same folder as the
      "Composite Macro" file.
      To
      test, I created (6) folders, named "January 2016"
      through "June 2016".In
      each folder, I copied your sample file 30 times
  (so I
    had
      180 copies)
      I
      then made reports for all 6 folders.
      It
      took about 90 seconds.

      hope
      this gives you enough to work with.
      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 Friday, January 6,
      2017 11:45 AM, Izhar 
     wrote:

      Hi everyone

      I need help in the attach file, the
      question has defined in the attach workbook and I
    hope
     there
      will be someone look into the matter.
      Thanks in advance.

      -- 

      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

Re: $$Excel-Macros$$ Help with Conditionally Formatting

2017-01-04 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Wed, 1/4/17, martinez.david533 via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Help with Conditionally Formatting
 To: excel-macros@googlegroups.com
 Date: Wednesday, January 4, 2017, 7:27 AM

 On Wed, 1/4/17, spainy via MS EXCEL AND VBA MACROS 

 wrote:

  Subject: Re: $$Excel-Macros$$ Help with Conditionally
 Formatting
  To: excel-macros@googlegroups.com
  Date: Wednesday, January 4, 2017, 6:42 AM

  On Wed, 1/4/17, ileanakeating via MS EXCEL AND VBA MACROS

  wrote:

   Subject: Re: $$Excel-Macros$$ Help with
 Conditionally
  Formatting
   To: excel-macros@googlegroups.com
   Date: Wednesday, January 4, 2017, 5:52 AM

   On Wed, 1/4/17, storeythomas725 via MS EXCEL AND VBA
  MACROS

   wrote:

    Subject: Re: $$Excel-Macros$$ Help with
  Conditionally
   Formatting
    To: excel-macros@googlegroups.com
    Date: Wednesday, January 4, 2017, 3:03 AM

    On Wed, 1/4/17, mahergeorge503 via MS EXCEL AND VBA
  MACROS

    wrote:

     Subject: Re: $$Excel-Macros$$ Help with
   Conditionally
    Formatting
     To: excel-macros@googlegroups.com
     Date: Wednesday, January 4, 2017, 12:43 AM

     On Tue, 1/3/17, storeythomas725 via MS EXCEL AND
 VBA
    MACROS

     wrote:

      Subject: Re: $$Excel-Macros$$ Help with
    Conditionally
     Formatting
      To: excel-macros@googlegroups.com
      Date: Tuesday, January 3, 2017, 5:18 PM

      On Tue, 1/3/17, Mack Mans 
      wrote:

       Subject: Re: $$Excel-Macros$$ Help with
     Conditionally
      Formatting
       To: "MS EXCEL AND VBA MACROS" 
       Cc: ahprad...@gmail.com
       Date: Tuesday, January 3, 2017, 8:52 AM

       http://tutorialway.com/conditional-cell-format-in-excel/
       check this site 

       -- 

       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.
        infiintarea manufacturii de ceramica de la
    Targu-Jiu.
      - la fiinta in  Principate militia nationala 
      nucleu al armatei moderne  -isi incepe
  activitatea
      societatea secreta Constitutia   de la Lugoj.
      29 mart.-8 oct. - isi desfasoara lucrarile
  Comisia
    de
      delimitare a granitei Dunarii. -

  Fostele   raiale   otomane   revin   Principatelor.
      30 mart. - incheierea lucrarilor de elaborare a
      Regulamentelor Organice  apr. - Divanurile de la
    lasi
      si Bucuresti

  aproba   proiectul   de   lege   privind   organizarea
      armatei.1830iul. - Expeditie franceza in
  Algeria 
    care
      este ocupata militar. 25    iul.   
      -    Publicarea     in 
        Franta     a Ordonantelor privind
      dizolvarea Camerelor  modificarea     
         sistemului     
         electoral  suprimarea

Re: $$Excel-Macros$$ Create a Pivot based on Another Pivot

2017-01-01 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Sun, 1/1/17, libertystringer via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Create a Pivot based on Another Pivot
 To: excel-macros@googlegroups.com
 Date: Sunday, January 1, 2017, 4:04 PM

 On Sun, 1/1/17, mahergeorge503 via MS EXCEL AND VBA MACROS

 wrote:

  Subject: Re: $$Excel-Macros$$ Create a Pivot based on
 Another Pivot
  To: excel-macros@googlegroups.com
  Date: Sunday, January 1, 2017, 1:36 PM

  On Sun, 1/1/17, ileanakeating via MS EXCEL AND VBA MACROS

  wrote:

   Subject: Re: $$Excel-Macros$$ Create a Pivot based
 on
  Another Pivot
   To: excel-macros@googlegroups.com
   Date: Sunday, January 1, 2017, 1:26 PM

   On Sun, 1/1/17, julienneschindler via MS EXCEL AND
 VBA
   MACROS 
   wrote:

    Subject: Re: $$Excel-Macros$$ Create a Pivot based
  on
   Another Pivot
    To: excel-macros@googlegroups.com
    Date: Sunday, January 1, 2017, 6:47 AM

    On Sun, 1/1/17, derrickandrew994 via MS EXCEL AND
  VBA
   MACROS

    wrote:

     Subject: Re: $$Excel-Macros$$ Create a Pivot
 based
   on
    Another Pivot
     To: excel-macros@googlegroups.com
     Date: Sunday, January 1, 2017, 12:51 AM

     On Sat, 12/31/16, Jorge Marques 
     wrote:

      Subject: Re: $$Excel-Macros$$ Create a Pivot
  based
    on
     Another Pivot
      To: excel-macros@googlegroups.com
      Date: Saturday, December 31, 2016, 8:10 PM

      Hi,I create
      pivot based on another pivot by using source
  range
    A:Z for
      example, the thing is that in the filter I get
  then
      "blanks" but make sure I cover all data when the
      pivot source gets updated with new data and
  grows.I
    just
      then remove the blanks with filter.
      Best,JM
      On 15 December 2016 at
      00:59, Soumyendu Paul 
      wrote:
      Hi Experts,
      Can we create a pivot based on another
      pivot?(Interview Question)

      Regards,Soumyendu

      -- 

      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+unsubscribe@
      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.

      -- 
      Best
      Regards,Jorge Marques

      -- 

      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.

Re: $$Excel-Macros$$ Help in IF Function

2016-12-29 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Thu, 12/29/16, libertystringer via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Help in IF Function
 To: excel-macros@googlegroups.com
 Date: Thursday, December 29, 2016, 5:45 PM

 On Thu, 12/29/16, martinez.david533 via MS EXCEL AND VBA
 MACROS 
 wrote:

  Subject: Re: $$Excel-Macros$$ Help in IF Function
  To: excel-macros@googlegroups.com
  Date: Thursday, December 29, 2016, 3:34 PM

  On Thu, 12/29/16, silvers.r via MS EXCEL AND VBA MACROS

  wrote:

   Subject: Re: $$Excel-Macros$$ Help in IF Function
   To: excel-macros@googlegroups.com
   Date: Thursday, December 29, 2016, 12:17 PM

   On Thu, 12/29/16, Mack Mans 
   wrote:

    Subject: Re: $$Excel-Macros$$ Help in IF Function
    To: "MS EXCEL AND VBA MACROS" 
    Cc: lupins...@yahoo.com
    Date: Thursday, December 29, 2016, 11:55 AM

    On Wednesday, September 7, 2011 at 12:11:20 AM
  UTC+5,
    lupinskip wrote:result by
    IF function
    regards,Pawel
    From: anu gomathi

    To: excel-...@googlegroups.com
    Sent: Tuesday,
    September 6, 2011 9:00 PM
    Subject:
    $$Excel-Macros$$ Help in IF Function

    Hi All,

    Please help me to put the IF function for the below
    table. If the table value is 0 the product should not
  be
    there

    Attached the file for u r reference

    Tech

    OFM
    Apps
    Systems
    Result should
    be

    1
    2
    0
    1
    Tech;OFM;Systems

    1
    2
    0
    1
    Tech;OFM;Systems

    1
    2
    1
    0
    Tech;OFM;Apps

    1
    0
    0
    1
    Tech Systems

    1
    0
    0
    0
    Tech

    0
    1
    0
    0
    OFM

    0
    0
    1
    0
    Apps

    0
    0
    0
    1
    Systems
    Regards

    Anu

    -- 

    --
    --
  --

    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-...@googlegroups.com

  <><><><><><><><><><><><><><><>

  <><><><><><><>

    Like our page on facebook , Just follow below link

    http://www.facebook.com/
    discussexcel

    -- 

    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.
    INSTITUtIILE DE CULTURa. SOCIETatI SI ASOCIAtII
  CULTURALE.

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

Re: $$Excel-Macros$$ sap fico Training in Hyderabad

2016-12-27 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Tue, 12/27/16, silvers.r via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ sap fico Training in Hyderabad
 To: excel-macros@googlegroups.com
 Date: Tuesday, December 27, 2016, 7:40 PM

 On Tue, 12/27/16, Sanjay Kumar Maurya 
 wrote:

  Subject: Re: $$Excel-Macros$$ sap fico Training in
 Hyderabad
  To: excel-macros@googlegroups.com
  Date: Tuesday, December 27, 2016, 1:53 PM

  What's basic
  qualification required to participate in SAP fico
 training.
  My younger brother is BSC student. Is he eligible?
  On 27-Dec-2016 12:36
  PM, "kumar pmpTraining" 
  wrote:
  SAP FICO
  Training in Hyderabad with working IT Consultants. sap
 fico
  Training  in Hyderabad We
  are the Best SAP
  Training Institute in Hyderabad,Ameerpet with advanced
  course syllabus, Corporate
  Trainings with 12+ Years MNC Real time Faculty Live
  Projects, Placements, Free
  DEMO in Hyderabad,

  -- 

  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+unsubscribe@
  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.
  omania in relatiile internationale  in perioada aniior
 1930-1936. icolae Titulescu si politica securitatii
 colective. Anii de la inceputul sceniului patru au adus
 importante si semnificative mutatii in planul vietii
 xinomice si politice pe continentul european. S-a
 dezvoltat  cu toate teribilele ale consecinte  cea
 mai puternica criza economica din cate cunoscuse pana unei
 istoria si  in contextul ei  a sporit numarul
 regimurilor politice dictatoriale si rtremiste. Preluarea
 puterii in Germania de catre partidul nazist condus de Adolf
 itier a fost imediat insotita de afirmarea revizionismului
 ca politica oficiala de stat  >ea ce a determinat o
 puternica neliniste in tarile Europei centrale si
 sud-estice.

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

Re: $$Excel-Macros$$ REminder: Mail Charts via Vba Macro!

2016-12-26 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Mon, 12/26/16, Mohd Sadiq  wrote:

 Subject: Re: $$Excel-Macros$$ REminder: Mail Charts via Vba Macro!
 To: excel-macros@googlegroups.com
 Date: Monday, December 26, 2016, 2:41 PM

 hey , Did u get the
 file ?
 On Tue, Dec 6, 2016 at
 9:38 AM, Chand, Satish 
 wrote:

 Thank you so
 much for your reply..
 Please share a
 file in which you have use this
 coding..!

 From: excel-macros@googlegroups.com
 [mailto:excel-macros@
 googlegroups.com]
 On Behalf Of Soumyendu Paul

 Sent: Tuesday, December 06, 2016 7:09 AM

 To: excel-macros@googlegroups.com

 Subject: Re: $$Excel-Macros$$ REminder: Mail Charts
 via Vba Macro!

 Save the chart as an image
 and insert the image in mail body

 On Mon, Dec 5, 2016 at
 12:28 PM, sourav devrani 
 wrote:

 let me try
 sir

 On Thu, Dec 1, 2016 at
 12:06 PM, Chand, Satish 
 wrote:

 Yet Not Recvd any
 response…
 Please help on this
 matter

 From: Chand, Satish

 Sent: Friday, November 25, 2016 9:07 PM

 To: 'excel-macros@googlegroups.com
 ' 

 Subject: Mail Charts via Vba Macro!

 Hello
 Friend,

 I have a sheet in which
 multiple 3 charts as below screen shot.
 I want a macro for mail in
 which only copy all charts in mail body and
 send.

 Regards

 Satish
 Chand

 -- 

 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+unsubscribe@
 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+unsubscribe@
 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

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

2016-12-16 Thread keisha.fry via MS EXCEL AND VBA MACROS



On Sat, 12/17/16, spainy via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
 To: excel-macros@googlegroups.com
 Date: Saturday, December 17, 2016, 8:14 AM
 
 
 
 On Sat, 12/17/16, julienneschindler via MS EXCEL AND VBA
 MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
  To: excel-macros@googlegroups.com
  Date: Saturday, December 17, 2016, 7:17 AM
  
  
  
  On Sat, 12/17/16, julienneschindler via MS EXCEL AND VBA
  MACROS 
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
 Unhide
   To: excel-macros@googlegroups.com
   Date: Saturday, December 17, 2016, 6:32 AM
   
   
   
   On Sat, 12/17/16, mintaspriggs via MS EXCEL AND VBA
 MACROS
   
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
  Unhide
    To: excel-macros@googlegroups.com
    Date: Saturday, December 17, 2016, 5:18 AM
    
    
    
    On Sat, 12/17/16, margaretatolliver via MS EXCEL AND
  VBA
    MACROS 
    wrote:
    
     Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
 and
   Unhide
     To: excel-macros@googlegroups.com
     Date: Saturday, December 17, 2016, 1:04 AM
     
     
     
     On Fri, 12/16/16, spainy via MS EXCEL AND VBA
 MACROS
   
     wrote:
     
      Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
  and
    Unhide
      To: excel-macros@googlegroups.com
      Date: Friday, December 16, 2016, 6:08 PM
      
      
      
      On Fri, 12/16/16, cronincarmelita via MS EXCEL
  AND
    VBA
      MACROS 
      wrote:
      
       Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
   and
     Unhide
       To: excel-macros@googlegroups.com
       Date: Friday, December 16, 2016, 5:34 PM
       
       
       
       On Fri, 12/16/16, libertystringer via MS EXCEL
   AND
     VBA
       MACROS 
       wrote:
       
        Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
    and
      Unhide
        To: excel-macros@googlegroups.com
        Date: Friday, December 16, 2016, 4:56 PM
        
        
        
        On Fri, 12/16/16, ashleypartridge via MS EXCEL
    AND
      VBA
        MACROS 
        wrote:
        
         Subject: Re: $$Excel-Macros$$ Excel Sheet
 Hide
     and
       Unhide
         To: excel-macros@googlegroups.com
         Date: Friday, December 16, 2016, 2:42 PM
         
         
        
 
         On Fri, 12/16/16, mintaspriggs via MS EXCEL
   AND
     VBA
       MACROS
         
         wrote:
         
          Subject: Re: $$Excel-Macros$$ Excel Sheet
  Hide
      and
        Unhide
          To: excel-macros@googlegroups.com
          Date: Friday, December 16, 2016, 2:14 PM
          
          
         
  
          On Fri, 12/16/16, silvers.r via MS EXCEL
  AND
    VBA
        MACROS
          
          wrote:
          
           Subject: Re: $$Excel-Macros$$ Excel
 Sheet
   Hide
       and
         Unhide
           To: excel-macros@googlegroups.com
           Date: Friday, December 16, 2016, 12:26
 PM
           
           
          
   
           On Fri, 12/16/16, cronincarmelita via MS
   EXCEL
       AND
         VBA
           MACROS 
           wrote:
           
            Subject: Re: $$Excel-Macros$$ Excel
  Sheet
    Hide
        and
          Unhide
            To: excel-macros@googlegroups.com
            Date: Friday, December 16, 2016, 6:03 AM
            
            
           
    
            On Fri, 12/16/16, silvers.r via MS EXCEL
    AND
      VBA
          MACROS
            
            wrote:
            
             Subject: Re: $$Excel-Macros$$ Excel
   Sheet
     Hide
         and
           Unhide
             To: excel-macros@googlegroups.com
             Date: Friday, December 16, 2016, 3:28
 AM
             
             
            
     
             On Fri, 12/16/16, mintaspriggs via MS
   EXCEL
       AND
         VBA
           MACROS
             
             wrote:
             
              Subject:

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

2016-12-16 Thread keisha.fry via MS EXCEL AND VBA MACROS



On Sat, 12/17/16, margaretatolliver via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
 To: excel-macros@googlegroups.com
 Date: Saturday, December 17, 2016, 1:04 AM
 
 
 
 On Fri, 12/16/16, spainy via MS EXCEL AND VBA MACROS 

 wrote:
 
  Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
  To: excel-macros@googlegroups.com
  Date: Friday, December 16, 2016, 6:08 PM
  
  
  
  On Fri, 12/16/16, cronincarmelita via MS EXCEL AND VBA
  MACROS 
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
 Unhide
   To: excel-macros@googlegroups.com
   Date: Friday, December 16, 2016, 5:34 PM
   
   
   
   On Fri, 12/16/16, libertystringer via MS EXCEL AND
 VBA
   MACROS 
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
  Unhide
    To: excel-macros@googlegroups.com
    Date: Friday, December 16, 2016, 4:56 PM
    
    
    
    On Fri, 12/16/16, ashleypartridge via MS EXCEL AND
  VBA
    MACROS 
    wrote:
    
     Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
 and
   Unhide
     To: excel-macros@googlegroups.com
     Date: Friday, December 16, 2016, 2:42 PM
     
     
     
     On Fri, 12/16/16, mintaspriggs via MS EXCEL AND
 VBA
   MACROS
     
     wrote:
     
      Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
  and
    Unhide
      To: excel-macros@googlegroups.com
      Date: Friday, December 16, 2016, 2:14 PM
      
      
      
      On Fri, 12/16/16, silvers.r via MS EXCEL AND VBA
    MACROS
      
      wrote:
      
       Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
   and
     Unhide
       To: excel-macros@googlegroups.com
       Date: Friday, December 16, 2016, 12:26 PM
       
       
       
       On Fri, 12/16/16, cronincarmelita via MS EXCEL
   AND
     VBA
       MACROS 
       wrote:
       
        Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
    and
      Unhide
        To: excel-macros@googlegroups.com
        Date: Friday, December 16, 2016, 6:03 AM
        
        
        
        On Fri, 12/16/16, silvers.r via MS EXCEL AND
  VBA
      MACROS
        
        wrote:
        
         Subject: Re: $$Excel-Macros$$ Excel Sheet
 Hide
     and
       Unhide
         To: excel-macros@googlegroups.com
         Date: Friday, December 16, 2016, 3:28 AM
         
         
        
 
         On Fri, 12/16/16, mintaspriggs via MS EXCEL
   AND
     VBA
       MACROS
         
         wrote:
         
          Subject: Re: $$Excel-Macros$$ Excel Sheet
  Hide
      and
        Unhide
          To: excel-macros@googlegroups.com
          Date: Friday, December 16, 2016, 1:40 AM
          
          
         
  
          On Thu, 12/15/16, Vijayendra Rao 
          wrote:
          
           Subject: Re: $$Excel-Macros$$ Excel
 Sheet
   Hide
       and
         Unhide
           To: excel-macros@googlegroups.com
           Date: Thursday, December 15, 2016, 5:12
 PM
           
           Hi
           Paul,
           Thank you very much
           for your time, I tried both the option
 and
     both
       are
          working
           very fine. You have fulfilled my all
     requirement.
         Thank
          you
           once again for your timely help.
           Regards,Vijayendra
           
           2016-12-15 20:17 GMT+05:30
           Paul Schreiner :
           Look
           at the "Thisworkbook" module in the VB
           Editor.
           Notice
           that in the Hide...xlsm workbook, this
   module
     has
         the
           Workbook_Open event macro?
           Your
           testing.xlsm workbook doesn't have this.
           I noticed that you've added an
           Auto_Open macro.this is also an
           option.You
           could simply add  a call to
 HideAllSheets
   to
       this
         macro
           before the Msgbox
          line. 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

Re: $$Excel-Macros$$ Combine two macros in to one

2016-12-15 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Thu, 12/15/16, julienneschindler via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Combine two macros in to one
 To: excel-macros@googlegroups.com
 Date: Thursday, December 15, 2016, 12:52 PM

 On Thu, 12/15/16, silvers.r via MS EXCEL AND VBA MACROS

 wrote:

  Subject: Re: $$Excel-Macros$$ Combine two macros in to one
  To: excel-macros@googlegroups.com
  Date: Thursday, December 15, 2016, 1:35 AM

  On Wed, 12/14/16, cronincarmelita via MS EXCEL AND VBA
  MACROS 
  wrote:

   Subject: Re: $$Excel-Macros$$ Combine two macros in
 to one
   To: excel-macros@googlegroups.com
   Date: Wednesday, December 14, 2016, 11:22 PM

   On Wed, 12/14/16, julienneschindler via MS EXCEL AND
 VBA
   MACROS 
   wrote:

    Subject: Re: $$Excel-Macros$$ Combine two macros in
  to one
    To: excel-macros@googlegroups.com
    Date: Wednesday, December 14, 2016, 8:15 PM

    On Wed, 12/14/16, kenyattafreed via MS EXCEL AND VBA
   MACROS

    wrote:

     Subject: Re: $$Excel-Macros$$ Combine two macros
 in
   to one
     To: excel-macros@googlegroups.com
     Date: Wednesday, December 14, 2016, 8:09 PM

     On Wed, 12/14/16, Paul Schreiner 
     wrote:

      Subject: Re: $$Excel-Macros$$ Combine two macros
  in
    to one
      To: "excel-macros@googlegroups.com"

      Date: Wednesday, December 14, 2016, 3:57 PM

      Your
      buttons call two separate
     macros.Print_OptionandSUPPRESS_ROWS
      to
      combine the two, simply have the Print_Option
  macro
      "call" the SUPPRESS_ROWS macro, like:
      Sub
      Print_option()

      SUPRESS_ROWS

      Application.Dialogs(xlDialogPrint).Show
      End
      Sub
      Paul-
      “Do all the
      good you can,
      By all the means you can,
      In all the ways you can,
      In all
      the places you can,
      At all the times you
      can,
      To all the people you can,
      As long as ever you can.” - John Wesley
      -

         On Wednesday,
      December 14, 2016 2:40 AM, Vijayendra Rao

     wrote:

       Dear Experts,
      I have created two macros, one is
      for suppress zero rows and another print option.
    Currently
     I
      need to run first suppress zero rows and  later
    print
      macros. Is it possible to combine both the
  macros.
    By
      running print option, rows should be suppress and
    later
     need
      to show print dialogue option.
      Attached is the file which is I have
      created the macros. Request you to help on the
      same. 
      Regards,
      Vijayendra
      94491 67631

      -- 

      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$$ Excel Sheet Hide and Unhide

2016-12-14 Thread keisha.fry via MS EXCEL AND VBA MACROS



On Wed, 12/14/16, karleenbiggs via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
 To: excel-macros@googlegroups.com
 Date: Wednesday, December 14, 2016, 3:37 AM
 
 
 
 On Wed, 12/14/16, cronincarmelita via MS EXCEL AND VBA
 MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
  To: excel-macros@googlegroups.com
  Date: Wednesday, December 14, 2016, 3:14 AM
  
  
  
  On Wed, 12/14/16, julienneschindler via MS EXCEL AND VBA
  MACROS 
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
 Unhide
   To: excel-macros@googlegroups.com
   Date: Wednesday, December 14, 2016, 2:51 AM
   
   
   
   On Wed, 12/14/16, ileanakeating via MS EXCEL AND VBA
  MACROS
   
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
  Unhide
    To: excel-macros@googlegroups.com
    Date: Wednesday, December 14, 2016, 12:37 AM
    
    
    
    On Tue, 12/13/16, Paul Schreiner 
    wrote:
    
     Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
 and
   Unhide
     To: "excel-macros@googlegroups.com"
    
     Date: Tuesday, December 13, 2016, 2:11 PM
     
     I'd
     suggest changing the HideAllSheets macro to
 first
     display the "read" sheet (what you
     called "guidelines"?)then hide everything EXCEPT
   the
    "read"
     sheet.
     Like:
     Sub HideAllSheets()
        
     Dim wsSheet As Worksheet
        
     Sheets("read").Visible = True
        
     For Each wsSheet In ActiveWorkbook.Worksheets
        
     If wsSheet.Name <> "read" Then
        
     wsSheet.Visible = xlSheetHidden
        
     End If
        
     Next wsSheet
     End
     Sub
      Paul-
     “Do
     all the good you can,
     By all the means you can,
     In all the ways you can,
     In all the places you can,
     At all the times you can,
     To all the people you can,
     As long as ever you can.” - John Wesley
     -
     
     
      
       On Tuesday, December 13, 2016 1:45
     AM, karleenbiggs via MS EXCEL AND VBA MACROS
     
    wrote:
       
     
      
     
     On Tue, 12/13/16, ileanakeating via MS EXCEL AND
 VBA
    MACROS
     
     wrote:
     
      Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
  and
    Unhide
      To: excel-macros@googlegroups.com
      Date: Tuesday, December 13, 2016, 8:27 AM
      
      
      
      On Tue, 12/13/16, Vijayendra Rao 
      wrote:
      
       Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
   and
     Unhide
       To: excel-macros@googlegroups.com
       Date: Tuesday, December 13, 2016, 3:50 AM
       
       Thanks Paul for quick
       help, it fulfilled my most of the requirement.
   One
     last
       favor, Now while opening last saved sheet only
     visible and
       guidelines sheet is hide , is it possible to
 view
     only
      first
       sheet (sheet name read) of the file.
       Regards,Vijayendra
       2016-12-12 18:52
       GMT+05:30 Paul Schreiner :
       There's
       nothing that is "automatic".
       Attached
       uses a Workbook_open event macro to hide
     the sheets when
       you OPEN the document.
       That way, it doesn't matter whether the
       sheets are visible or not when the file is
 saved,
     but
       it will hide the sheets when it's opened.
       
       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 Monday, December 12, 2016 7:50 AM,
       karleenbiggs via MS EXCEL AND VBA MACROS  wrote:
         
       
        
       -- --
       On Mon, 12/12/16, Vijayendra Rao 
       wrote:
       
        Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
    and
      Unhide
        To: excel-macros@googlegroups.com
        Date: Monday, December 12, 2016, 2:43 PM
        
        Thanks Paul for quick
        guidance.
        This file is used by many people and they are

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

2016-12-13 Thread keisha.fry via MS EXCEL AND VBA MACROS



On Tue, 12/13/16, Vijayendra Rao  wrote:

 Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
 To: excel-macros@googlegroups.com
 Date: Tuesday, December 13, 2016, 2:54 PM
 
 Thanks Paul for your
 help, it is working fine. You saved my lot of time.
 Thank you again.
 Regards,Vijayendra
 2016-12-13 17:41
 GMT+05:30 Paul Schreiner :
 I'd
 suggest changing the HideAllSheets macro to first display
 the "read" sheet (what you
 called "guidelines"?)then
 hide everything EXCEPT the "read" sheet.
 Like:
 Sub HideAllSheets()
    
 Dim wsSheet As Worksheet
    
 Sheets("read").Visible = True
    
 For Each wsSheet In ActiveWorkbook.Worksheets
    
 If wsSheet.Name <> "read" Then
    
 wsSheet.Visible = xlSheetHidden
    
 End If
    
 Next wsSheet
 End
 Sub
  Paul--
 ---
 “Do
 all the good you can,
 By all the means you can,
 In all the ways you can,
 In all the places you can,
 At all the times you can,
 To all the people you can,
 As long as ever you can.” - John Wesley
 --
 ---
 
 
  
   On Tuesday, December 13, 2016 1:45
 AM, karleenbiggs via MS EXCEL AND VBA MACROS  wrote:
   
 
  
 -- --
 On Tue, 12/13/16, ileanakeating via MS EXCEL AND VBA MACROS
  wrote:
 
  Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
  To: excel-macros@googlegroups.com
  Date: Tuesday, December 13, 2016, 8:27 AM
  
  
  -- --
  On Tue, 12/13/16, Vijayendra Rao 
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
 Unhide
   To: excel-macros@googlegroups.com
   Date: Tuesday, December 13, 2016, 3:50 AM
   
   Thanks Paul for quick
   help, it fulfilled my most of the requirement. One last
   favor, Now while opening last saved sheet only visible
 and
   guidelines sheet is hide , is it possible to view only
  first
   sheet (sheet name read) of the file.
   Regards,Vijayendra
   2016-12-12 18:52
   GMT+05:30 Paul Schreiner :
   There's
   nothing that is "automatic".
   Attached
   uses a Workbook_open event macro to hide the sheets
 when
   you OPEN the document.
   That way, it doesn't matter whether the
   sheets are visible or not when the file is saved, but
   it will hide the sheets when it's opened.
   
   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 Monday, December 12, 2016 7:50 AM,
   karleenbiggs via MS EXCEL AND VBA MACROS  wrote:
     
   
    
   -- --
   On Mon, 12/12/16, Vijayendra Rao 
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
  Unhide
    To: excel-macros@googlegroups.com
    Date: Monday, December 12, 2016, 2:43 PM
    
    Thanks Paul for quick
    guidance.
    This file is used by many people and they are
    working without reading few guidelines from first
  sheet.
    There may be chances of not using the sheet_hide
  macro
    option by other user. Is there any macros which
    automatically hide those sheets when close the file.
    Attached is the my workbook.
    Regards,Vijayendra
    2016-12-12 17:46
    GMT+05:30 Paul Schreiner :
    Just
    as you created a macro to "unhide" the
 sheets,
   you
    need to create a macro to hide them.
    Additionally,
    you can create a BeforeSave event to check to see if
  the
    sheets are displayed.Then
    execute your "Sheets_Hide" macro to hide the
    sheets before saving (that
    way the sheets are always hidden before saving the
    file)
    Note:
    Using a macro, you can use .Visible =
  xlVeryHiddenwhich
   will hide the sheets and they will not show
    up when trying to manually unhide the sheets!
    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 Monday, December 12, 2016 7:04 AM, Vijayendra
    Rao 
    wrote:
      
    
     Hi Experts,
    I have created one excel file and except one
    sheet all sheets are hided. I have added shape button
  in
    first sheet to unhide all the sheets with the help
  of
   macro.
    When i worked and saved all sheets will be visible
  when I

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

2016-12-12 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Tue, 12/13/16, Vijayendra Rao  wrote:

 Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
 To: excel-macros@googlegroups.com
 Date: Tuesday, December 13, 2016, 3:50 AM

 Thanks
 Paul for quick help, it fulfilled my most of the
 requirement. One last favor, Now while opening last saved
 sheet only visible and guidelines sheet is hide , is it
 possible to view only first sheet (sheet name read) of the
 file.
 Regards,Vijayendra
 2016-12-12 18:52 GMT+05:30
 Paul Schreiner :
 There's
 nothing that is "automatic".
 Attached
 uses a Workbook_open event macro to hide the sheets when
 you OPEN the document.
 That way, it doesn't matter
 whether the sheets are visible or not when the file is
 saved, but
 it will hide the sheets when it's opened.

 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 Monday, December 12, 2016 7:50 AM,
 karleenbiggs via MS EXCEL AND VBA MACROS  wrote:

 --
 --
 On Mon, 12/12/16, Vijayendra
 Rao 
 wrote:

  Subject: Re:
 $$Excel-Macros$$ Excel Sheet Hide and Unhide
  To: excel-macros@googlegroups.com
  Date: Monday, December 12, 2016, 2:43 PM

  Thanks Paul for quick
  guidance.
  This file is used
 by many people and they are
  working without
 reading few guidelines from first sheet.

 There may be chances of not using the sheet_hide macro
  option by other user. Is there any macros
 which
  automatically hide those sheets when
 close the file.
  Attached is the my
 workbook.
  Regards,Vijayendra
  2016-12-12 17:46
  GMT+05:30
 Paul Schreiner :
  Just
  as you created a macro
 to "unhide" the sheets, you
  need
 to create a macro to hide them.

 Additionally,
  you can create a
 BeforeSave event to check to see if the

 sheets are displayed.Then
  execute your
 "Sheets_Hide" macro to hide the

 sheets before saving (that
  way the sheets
 are always hidden before saving the

 file)
  Note:
  Using a macro,
 you can use .Visible = xlVeryHiddenwhich will hide the
 sheets and they will not show
  up when
 trying to manually unhide the sheets!

 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 Monday, December 12,
 2016 7:04 AM, Vijayendra
  Rao 
  wrote:

   Hi Experts,
  I have
 created one excel file and except one
  sheet
 all sheets are hided. I have added shape button in
  first sheet to unhide all the sheets with the
 help of macro.
  When i worked and saved all
 sheets will be visible when I
  opened again.
 Is it possible to remain hide those sheets

 after saving the file.
  Request you to help
 on the same.-- 

  Regards,
  Vijayendra
  94491 67631

  -- 

  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+unsubscribe@

 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

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

2016-12-12 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Mon, 12/12/16, derrickandrew994 via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
 To: excel-macros@googlegroups.com
 Date: Monday, December 12, 2016, 11:05 PM

 On Mon, 12/12/16, ashleypartridge via MS EXCEL AND VBA
 MACROS 
 wrote:

  Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
  To: excel-macros@googlegroups.com
  Date: Monday, December 12, 2016, 8:53 PM

  On Mon, 12/12/16, julienneschindler via MS EXCEL AND VBA
  MACROS 
  wrote:

   Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
 Unhide
   To: excel-macros@googlegroups.com
   Date: Monday, December 12, 2016, 4:53 PM

   On Mon, 12/12/16, Paul Schreiner 
   wrote:

    Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
  Unhide
    To: "excel-macros@googlegroups.com"

    Date: Monday, December 12, 2016, 3:22 PM

    There's
    nothing that is "automatic".
    Attached
    uses a Workbook_open event macro to hide the sheets
  when
    you OPEN the document.
    That way, it doesn't matter
    whether the sheets are visible or not when the file
  is
    saved, but
    it will hide the sheets when it's opened.

    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 Monday, December
    12, 2016 7:50 AM, karleenbiggs via MS EXCEL AND VBA
  MACROS

   wrote:

    On Mon, 12/12/16, Vijayendra Rao 
    wrote:

     Subject: Re:
    $$Excel-Macros$$ Excel Sheet Hide and Unhide
     To: excel-macros@googlegroups.com
     Date: Monday, December 12, 2016, 2:43 PM

     Thanks Paul for quick
     guidance.
     This file is used
    by many people and they are
     working without
    reading few guidelines from first sheet.

    There may be chances of not using the sheet_hide
  macro
     option by other user. Is there any macros
    which
     automatically hide those sheets when
    close the file.
     Attached is the my
    workbook.
     Regards,Vijayendra
     2016-12-12 17:46
     GMT+05:30
    Paul Schreiner :
     Just
     as you created a macro
    to "unhide" the sheets, you
     need
    to create a macro to hide them.

    Additionally,
     you can create a
    BeforeSave event to check to see if the

    sheets are displayed.Then
     execute your
    "Sheets_Hide" macro to hide the

    sheets before saving (that
     way the sheets
    are always hidden before saving the

    file)
     Note:
     Using a macro,
    you can use .Visible = xlVeryHiddenwhich will hide
  the
    sheets and they will not show
     up when
    trying to manually unhide the sheets!

    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 Monday, December 12,
    2016 7:04 AM, Vijayendra
     Rao 
     wrote:

      Hi Experts,
     I have
    created one excel file and except one
     sheet
    all sheets are hided. I have added shape button in
     first sheet to unhide all the sheets with the
    help of macro.
     When i worked and saved all
    sheets will be visible when I
     opened again.
    Is it possible to remain hide those sheets

    after saving the file.
     Request you to help
    on the same.-- 

     Regards,
     Vijayendra
     94491 67631

     -- 

     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

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

2016-12-12 Thread keisha.fry via MS EXCEL AND VBA MACROS

On Mon, 12/12/16, Paul Schreiner  wrote:

 Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
 To: "excel-macros@googlegroups.com" 
 Date: Monday, December 12, 2016, 3:22 PM

 There's
 nothing that is "automatic".
 Attached
 uses a Workbook_open event macro to hide the sheets when
 you OPEN the document.
 That way, it doesn't matter
 whether the sheets are visible or not when the file is
 saved, but
 it will hide the sheets when it's opened.

 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 Monday, December
 12, 2016 7:50 AM, karleenbiggs via MS EXCEL AND VBA MACROS
  wrote:

 On Mon, 12/12/16, Vijayendra Rao 
 wrote:

  Subject: Re:
 $$Excel-Macros$$ Excel Sheet Hide and Unhide
  To: excel-macros@googlegroups.com
  Date: Monday, December 12, 2016, 2:43 PM

  Thanks Paul for quick
  guidance.
  This file is used
 by many people and they are
  working without
 reading few guidelines from first sheet.

 There may be chances of not using the sheet_hide macro
  option by other user. Is there any macros
 which
  automatically hide those sheets when
 close the file.
  Attached is the my
 workbook.
  Regards,Vijayendra
  2016-12-12 17:46
  GMT+05:30
 Paul Schreiner :
  Just
  as you created a macro
 to "unhide" the sheets, you
  need
 to create a macro to hide them.

 Additionally,
  you can create a
 BeforeSave event to check to see if the

 sheets are displayed.Then
  execute your
 "Sheets_Hide" macro to hide the

 sheets before saving (that
  way the sheets
 are always hidden before saving the

 file)
  Note:
  Using a macro,
 you can use .Visible = xlVeryHiddenwhich will hide the
 sheets and they will not show
  up when
 trying to manually unhide the sheets!

 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 Monday, December 12,
 2016 7:04 AM, Vijayendra
  Rao 
  wrote:

   Hi Experts,
  I have
 created one excel file and except one
  sheet
 all sheets are hided. I have added shape button in
  first sheet to unhide all the sheets with the
 help of macro.
  When i worked and saved all
 sheets will be visible when I
  opened again.
 Is it possible to remain hide those sheets

 after saving the file.
  Request you to help
 on the same.-- 

  Regards,
  Vijayendra
  94491 67631

  -- 

  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+unsubscribe@

 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

Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

2016-12-11 Thread keisha.fry via MS EXCEL AND VBA MACROS



On Sun, 12/11/16, taher bootwala  wrote:

 Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
 To: "MS EXCEL AND VBA MACROS" 
 Cc: julienneschind...@yahoo.com
 Date: Sunday, December 11, 2016, 8:12 PM
 
 PLEASE ADD
 8819978652
 
 On Saturday, 10 December 2016 03:55:25 UTC+5:30,
 julienne...@yahoo.com  wrote:
 
 -- --
 
 On Fri, 12/9/16, XLS time  wrote:
 
 
 
  Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp
 Group
 
  To: excel-...@googlegroups.com
 
  Date: Friday, December 9, 2016, 8:38 AM
 
  
 
  8860067995
 
  --
 
  
 
  On Fri, Dec 9, 2016 at 9:36
 
  AM, N.MADHAN 
 
  wrote:
 
  Could you
 
  please add my number +91 9442944095
 
  
 
  
 
  
 
  On 12/9/16, Amit Kumar 
 
  wrote:
 
  
 
  > Please add my number 9618644088
 
  
 
  >
 
  
 
  >
 
  
 
  > On Mon, Sep 12, 2016 at 1:21 PM, V. Kiran Kumar
 
 
  
 
  > wrote:
 
  
 
  >
 
  
 
  >> Pls add my number +265999336673
 
  
 
  >>
 
  
 
  >> On Sunday, 11 September 2016 08:01:31 UTC+2,
 Prabhu
 
  Pinky wrote:
 
  
 
  >>>
 
  
 
  >>> Hi Friends,
 
  
 
  >>>
 
  
 
  >>> Since i have created Whatsapp group for VBA
 
  Macro learners/experts.
 
  
 
  >>>
 
  
 
  >>> And i have added many peoples in this group.
 
  Please Msg me to 9500087194
 
  
 
  >>> in whatsapp to get added in this group. if
 
  anyone missed or not yet
 
  
 
  >>> added
 
  
 
  >>> even you requested earlier.
 
  
 
  >>>
 
  
 
  >>> Thanks & Regards,
 
  
 
  >>> Prabhu R
 
  
 
  >>>
 
  
 
  >> --
 
  
 
  >> 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+unsubscribe@
 
  googlegroups.com.
 
  
 
  >> To post to this group, send email to excel-...@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+unsubscribe@
 
  googlegroups.com.
 
  
 
  > To post to this group, send email to excel-...@googlegroups.com.
 
  
 
  > Visit this group at https://groups.google.com/
 
  group/excel-macros.
 
  
 
  > For more options, visit https://groups.google.com/d/
 
  optout.
 
  
 
  >
 
  
 
  
 
  
 
  
 
  
 
  --
 
  
 
  Thanks

Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

2016-12-11 Thread keisha.fry via MS EXCEL AND VBA MACROS



On Sun, 12/11/16, ashleypartridge via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
 To: excel-macros@googlegroups.com
 Date: Sunday, December 11, 2016, 10:41 AM
 
 
 
 On Sun, 12/11/16, karleenbiggs via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp
 Group
  To: excel-macros@googlegroups.com
  Date: Sunday, December 11, 2016, 10:08 AM
  
  
  
  On Sun, 12/11/16, margaretatolliver via MS EXCEL AND VBA
  MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
 Whatsapp
  Group
   To: excel-macros@googlegroups.com
   Date: Sunday, December 11, 2016, 9:36 AM
   
   
   
   On Sun, 12/11/16, kenyattafreed via MS EXCEL AND VBA
  MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
  Whatsapp
   Group
    To: excel-macros@googlegroups.com
    Date: Sunday, December 11, 2016, 3:48 AM
    
    
    
    On Sun, 12/11/16, mintaspriggs via MS EXCEL AND VBA
  MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
   Whatsapp
    Group
     To: excel-macros@googlegroups.com
     Date: Sunday, December 11, 2016, 3:14 AM
     
     
     ----
     On Sun, 12/11/16, keisha.fry via MS EXCEL AND VBA
   MACROS
     <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
    Whatsapp
     Group
      To: excel-macros@googlegroups.com
      Date: Sunday, December 11, 2016, 12:56 AM
      
      
      
      On Sat, 12/10/16, silvers.r via MS EXCEL AND VBA
    MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
     Whatsapp
      Group
       To: excel-macros@googlegroups.com
       Date: Saturday, December 10, 2016, 11:55 PM
       
       
       
       On Sat, 12/10/16, margaretatolliver via MS
 EXCEL
   AND
     VBA
       MACROS <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
      Whatsapp
       Group
        To: excel-macros@googlegroups.com
        Date: Saturday, December 10, 2016, 4:49 PM
        
        
        
        On Sat, 12/10/16, kenyattafreed via MS EXCEL
  AND
    VBA
       MACROS
        <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ Re: VBA Macro
 -
       Whatsapp
        Group
         To: excel-macros@googlegroups.com
         Date: Saturday, December 10, 2016, 4:45 PM
         
         
        
 
         On Sat, 12/10/16, karleenbiggs via MS EXCEL
   AND
     VBA
       MACROS
         <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ Re: VBA Macro
  -
        Whatsapp
         Group
          To: excel-macros@googlegroups.com
          Date: Saturday, December 10, 2016, 4:06 PM
          
          
         
  
          On Sat, 12/10/16, ashleypartridge via MS
  EXCEL
      AND
        VBA
          MACROS <excel-macros@googlegroups.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ Re: VBA
 Macro
   -
         Whatsapp
          Group
           To: excel-macros@googlegroups.com
           Date: Saturday, December 10, 2016, 12:03
 PM
           
           
          
   
           On Sat, 12/10/16, spainy via MS EXCEL
 AND
   VBA
       MACROS
         <excel-macros@googlegroups.com>
           wrote:
           
            Subject: Re: $$Excel-Macros$$ Re: VBA
  Macro
    -
          Whatsapp
           Group
            To: excel-macros@googlegroups.com
            Date: Saturday, December 10, 2016, 11:37
  AM
            
            
           
    
            On Sat, 12/10/16, LEARNING EXCEL <excellea...@gmail.com>
            wrote:
            
             Subject: Re: $$Excel-Macros$$ Re: VBA
   Macro
     -
           Whatsapp
            Group
             To: excel-macros@googlegroups.com
             Date: Saturday, December 10, 2016,
 11:35
   AM
             
             Please add my Number
             9600160150
             On 10 December 2016 at
             13:01, sugat misra <suga...@gmail.com>
             wrote:

Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

2016-12-10 Thread keisha.fry via MS EXCEL AND VBA MACROS



On Sun, 12/11/16, ashleypartridge via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
 To: excel-macros@googlegroups.com
 Date: Sunday, December 11, 2016, 3:54 AM
 
 
 
 On Sun, 12/11/16, kenyattafreed via MS EXCEL AND VBA MACROS
 <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp
 Group
  To: excel-macros@googlegroups.com
  Date: Sunday, December 11, 2016, 3:48 AM
  
  
  
  On Sun, 12/11/16, mintaspriggs via MS EXCEL AND VBA MACROS
  <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
 Whatsapp
  Group
   To: excel-macros@googlegroups.com
   Date: Sunday, December 11, 2016, 3:14 AM
   
   
   
   On Sun, 12/11/16, keisha.fry via MS EXCEL AND VBA
 MACROS
   <excel-macros@googlegroups.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
  Whatsapp
   Group
    To: excel-macros@googlegroups.com
    Date: Sunday, December 11, 2016, 12:56 AM
    
    
    
    On Sat, 12/10/16, silvers.r via MS EXCEL AND VBA
  MACROS
    <excel-macros@googlegroups.com>
    wrote:
    
     Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
   Whatsapp
    Group
     To: excel-macros@googlegroups.com
     Date: Saturday, December 10, 2016, 11:55 PM
     
     
     
     On Sat, 12/10/16, margaretatolliver via MS EXCEL
 AND
   VBA
     MACROS <excel-macros@googlegroups.com>
     wrote:
     
      Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
    Whatsapp
     Group
      To: excel-macros@googlegroups.com
      Date: Saturday, December 10, 2016, 4:49 PM
      
      
      
      On Sat, 12/10/16, kenyattafreed via MS EXCEL AND
  VBA
     MACROS
      <excel-macros@googlegroups.com>
      wrote:
      
       Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
     Whatsapp
      Group
       To: excel-macros@googlegroups.com
       Date: Saturday, December 10, 2016, 4:45 PM
       
       
       
       On Sat, 12/10/16, karleenbiggs via MS EXCEL
 AND
   VBA
     MACROS
       <excel-macros@googlegroups.com>
       wrote:
       
        Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
      Whatsapp
       Group
        To: excel-macros@googlegroups.com
        Date: Saturday, December 10, 2016, 4:06 PM
        
        
        
        On Sat, 12/10/16, ashleypartridge via MS EXCEL
    AND
      VBA
        MACROS <excel-macros@googlegroups.com>
        wrote:
        
         Subject: Re: $$Excel-Macros$$ Re: VBA Macro
 -
       Whatsapp
        Group
         To: excel-macros@googlegroups.com
         Date: Saturday, December 10, 2016, 12:03 PM
         
         
        
 
         On Sat, 12/10/16, spainy via MS EXCEL AND
 VBA
     MACROS
       <excel-macros@googlegroups.com>
         wrote:
         
          Subject: Re: $$Excel-Macros$$ Re: VBA Macro
  -
        Whatsapp
         Group
          To: excel-macros@googlegroups.com
          Date: Saturday, December 10, 2016, 11:37 AM
          
          
         
  
          On Sat, 12/10/16, LEARNING EXCEL <excellea...@gmail.com>
          wrote:
          
           Subject: Re: $$Excel-Macros$$ Re: VBA
 Macro
   -
         Whatsapp
          Group
           To: excel-macros@googlegroups.com
           Date: Saturday, December 10, 2016, 11:35
 AM
           
           Please add my Number
           9600160150
           On 10 December 2016 at
           13:01, sugat misra <suga...@gmail.com>
           wrote:
           Please adde me as well 8880740879
           
           On Saturday, 10 December 2016 03:55:25
     UTC+5:30,
       julienne...@yahoo.com
            wrote:
           
           --
   --
           
           On Fri, 12/9/16, XLS time <xls...@gmail.com>
          wrote:
           
           
           
            Subject: Re: $$Excel-Macros$$ Re: VBA
   Macro
     -
         Whatsapp
           Group
           
            To: excel-...@googlegroups.com
           
            Date: Friday, December 9,
           2016, 8:38 AM
           
            
           
            8860067995
           
            --
           
            
           
            On Fri, Dec 9, 2016 at 9:36
           
            AM, N.MADHAN <madh...@gmail.com>
           
            wrote:

Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

2016-12-10 Thread keisha.fry via MS EXCEL AND VBA MACROS



On Sat, 12/10/16, silvers.r via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
 To: excel-macros@googlegroups.com
 Date: Saturday, December 10, 2016, 11:55 PM
 
 
 
 On Sat, 12/10/16, margaretatolliver via MS EXCEL AND VBA
 MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp
 Group
  To: excel-macros@googlegroups.com
  Date: Saturday, December 10, 2016, 4:49 PM
  
  
  
  On Sat, 12/10/16, kenyattafreed via MS EXCEL AND VBA
 MACROS
  
  wrote:
  
   Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
 Whatsapp
  Group
   To: excel-macros@googlegroups.com
   Date: Saturday, December 10, 2016, 4:45 PM
   
   
   
   On Sat, 12/10/16, karleenbiggs via MS EXCEL AND VBA
 MACROS
   
   wrote:
   
    Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
  Whatsapp
   Group
    To: excel-macros@googlegroups.com
    Date: Saturday, December 10, 2016, 4:06 PM
    
    
    
    On Sat, 12/10/16, ashleypartridge via MS EXCEL AND
  VBA
    MACROS 
    wrote:
    
     Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
   Whatsapp
    Group
     To: excel-macros@googlegroups.com
     Date: Saturday, December 10, 2016, 12:03 PM
     
     
     
     On Sat, 12/10/16, spainy via MS EXCEL AND VBA
 MACROS
   
     wrote:
     
      Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
    Whatsapp
     Group
      To: excel-macros@googlegroups.com
      Date: Saturday, December 10, 2016, 11:37 AM
      
      
      
      On Sat, 12/10/16, LEARNING EXCEL 
      wrote:
      
       Subject: Re: $$Excel-Macros$$ Re: VBA Macro -
     Whatsapp
      Group
       To: excel-macros@googlegroups.com
       Date: Saturday, December 10, 2016, 11:35 AM
       
       Please add my Number
       9600160150
       On 10 December 2016 at
       13:01, sugat misra 
       wrote:
       Please adde me as well 8880740879
       
       On Saturday, 10 December 2016 03:55:25
 UTC+5:30,
   julienne...@yahoo.com
        wrote:
       
       -- --
       
       On Fri, 12/9/16, XLS time 
      wrote:
       
       
       
        Subject: Re: $$Excel-Macros$$ Re: VBA Macro
 -
     Whatsapp
       Group
       
        To: excel-...@googlegroups.com
       
        Date: Friday, December 9,
       2016, 8:38 AM
       
        
       
        8860067995
       
        --
       
        
       
        On Fri, Dec 9, 2016 at 9:36
       
        AM, N.MADHAN 
       
        wrote:
       
        Could you
       
        please add my number +91 9442944095
       
        
       
        
       
        
       
        On 12/9/16, Amit Kumar 
       
        wrote:
       
        
       
        > Please add my number 9618644088
       
        
       
        >
       
        
       
        >
       
        
       
        > On Mon, Sep 12, 2016 at 1:21 PM, V.
 Kiran
       Kumar 
       
        
       
        > wrote:
       
        
       
        >
       
        
       
        >> Pls add my number +265999336673
       
        
       
        >>
       
        
       
        >> On Sunday, 11 September 2016
 08:01:31
     UTC+2,
       Prabhu
       
        Pinky wrote:
       
        
       
        >>>
       
        
       
        >>> Hi Friends,
       
        
       
        >>>
       
        
       
        >>> Since i have created Whatsapp
   group
     for VBA
       
        Macro learners/experts.
       
        
       
        >>>
       
        
       
        >>> And i have added many peoples
 in
   this
      group.
       
        Please Msg me to 9500087194
       
        
       
        >>> in whatsapp to get added in
 this
     group. if
       
        anyone missed or not yet
       
        
       
        >>> added
       
        
       
        >>> even you requested earlier.
       
        
       
        >>>
       
        
       
        >>> Thanks & Regards,
       
        
       
        >>> Prabhu R
       
        
       
        >>>
       
        
       
        >> --
       
        
       
        >> 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 @

Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

Re: $$Excel-Macros$$ changing required in the attach macro

Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month

Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

Re: $$Excel-Macros$$ Re: Once IF is met it is not looping

Re: $$Excel-Macros$$ Re: Once IF is met it is not looping

Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM)

Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM)

Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM)

Re: $$Excel-Macros$$ keep active in memory variables, array variables

Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE

Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

Re: $$Excel-Macros$$ something wrong with the attach macro

Re: $$Excel-Macros$$ How to use Index Match for two different files

Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula

Re: $$Excel-Macros$$ move sheets to a workbook

Re: $$Excel-Macros$$ Help with Conditionally Formatting

Re: $$Excel-Macros$$ Create a Pivot based on Another Pivot

Re: $$Excel-Macros$$ Help in IF Function

Re: $$Excel-Macros$$ sap fico Training in Hyderabad

Re: $$Excel-Macros$$ REminder: Mail Charts via Vba Macro!

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

Re: $$Excel-Macros$$ Combine two macros in to one

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group

36 matches

Site Navigation

Mail list logo

Footer information