date:20170209

Re: $$Excel-Macros$$ How to pick one webpage each from a collection of web page list!!!

2017-02-09 Thread derrickandrew994 via MS EXCEL AND VBA MACROS

On Fri, 2/10/17, RamiZ Majid  wrote:

 Subject: Re: $$Excel-Macros$$ How to pick one webpage each from a collection 
of web page list!!!
 To: "Kishore P V K" 
 Cc: excel-macros@googlegroups.com
 Date: Friday, February 10, 2017, 7:47 AM

 Thanks
 bro!!!
 It
 worked.
 On Fri, Feb 10, 2017 at
 2:09 AM, Kishore P V K 
 wrote:
 Here is the simple solution for your
 requirement:
 Insert a new
 column before the URL column:

 Enter
 the formula as showed in A2 column below

 after
 enter the formula in A2 drag the column till the URL values.
 Then you will find the all domain names in the column A as
 per the below screen shot

 Then
 select the required columns and go to DATA ribbon and select
 "Remove duplicates" option when option comes just
 select the newly created column A (Domain)

 Then
 click OK.  There you go:

 Hope
 this helps you !!!
 Cheers

 On Thu, Feb 9, 2017 at 3:34 AM, Ramiz
 Majid 
 wrote:
 I
 have a list of webpages contacting different domain
 pages!!!

 I want to pick a single webpage
 of each domains
 Please help !
 This is an example
 list: 

 And I need this as
 .

 Thanks!

 -- 

 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/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.
 83617 febr. - CraGovia  Polonia  este ocupata de trupele ruse  austriece si 
prusace. - Independenta Texasului  care se rupe de Mexic. 29 30   oct.   -   
incercarealuiLudovic Napoleon de a prelua puterea in Franta.

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

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

2017-02-09 Thread spainy via MS EXCEL AND VBA MACROS



On Thu, 2/9/17, libertystringer via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ keep active in memory variables, array variables
 To: excel-macros@googlegroups.com
 Date: Thursday, February 9, 2017, 9:09 PM
 
 
 
 On Thu, 2/9/17, martinez.david533 via MS EXCEL AND VBA
 MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ keep active in memory
 variables, array variables
  To: excel-macros@googlegroups.com
  Date: Thursday, February 9, 2017, 9:05 PM
  
  
  
  On Thu, 2/9/17, keisha.fry via MS EXCEL AND VBA MACROS
  
  wrote:
  
   Subject: Re: $$Excel-Macros$$ keep active in memory
  variables, array variables
   To: excel-macros@googlegroups.com
   Date: Thursday, February 9, 2017, 7:02 PM
   
   
   
   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

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

2017-02-09 Thread storeythomas725 via MS EXCEL AND VBA MACROS



On Thu, 2/9/17, libertystringer via MS EXCEL AND VBA MACROS 
 wrote:

 Subject: Re: $$Excel-Macros$$ keep active in memory variables, array variables
 To: excel-macros@googlegroups.com
 Date: Thursday, February 9, 2017, 9:09 PM
 
 
 
 On Thu, 2/9/17, martinez.david533 via MS EXCEL AND VBA
 MACROS 
 wrote:
 
  Subject: Re: $$Excel-Macros$$ keep active in memory
 variables, array variables
  To: excel-macros@googlegroups.com
  Date: Thursday, February 9, 2017, 9:05 PM
  
  
  
  On Thu, 2/9/17, keisha.fry via MS EXCEL AND VBA MACROS
  
  wrote:
  
   Subject: Re: $$Excel-Macros$$ keep active in memory
  variables, array variables
   To: excel-macros@googlegroups.com
   Date: Thursday, February 9, 2017, 7:02 PM
   
   
   
   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

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

2017-02-09 Thread libertystringer via MS EXCEL AND VBA MACROS

On Thu, 2/9/17, martinez.david533 via MS EXCEL AND VBA MACROS 
 wrote:

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

 On Thu, 2/9/17, keisha.fry via MS EXCEL AND VBA MACROS

 wrote:

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

  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.

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

2017-02-09 Thread martinez.david533 via MS EXCEL AND VBA MACROS

On Thu, 2/9/17, keisha.fry via MS EXCEL AND VBA MACROS 
 wrote:

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

 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

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$$ keep active in memory variables, array variables

2017-02-09 Thread Paul Schreiner

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

$$Excel-Macros$$ Senior .Net Developer @ Santa Clara, CA

2017-02-09 Thread govind ramanujam

Hello,



Hope you are doing great.

We have an urgent below *"Senior .Net Developer”* position with one of our
client for c2c position at *Santa Clara, CA.*

If you are interested please share your updated resume along with contact
details to  govind_ramanu...@visionisys.com



*Job Title  :  Senior .Net Developer*

*Location  :  Santa Clara, CA*

*Duration  :  6 months*



*Job Description : *



.Net developers with WPF knowledge, This developer must be proactive and
able to work independently asking questions when required.

It's not the right fit if this developer needs a full spec to work and is
used to the traditional waterfall approach.

C#, .Net, WPF, LinQ, Multi-threading

PRISM – Microsoft frame work

MVVM – model-view-view-model

Nice to have: monitoring applications





*Govind Ramanujam*
Visionisys Inc
Direct: 9724531361

Email: govind_ramanu...@visionisys.com  || www.visionisys.com

*Note* : If you have received this mail in error or prefer not to receive
such emails in the future, please reply with "REMOVE" in the subject line
and the email id(s) to be removed. All removal requests will be honored ASAP.
We sincerely apologize for any inconvenience caused

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

FORUM RULES

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

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

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

2017-02-09 Thread wltrpscl



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.

$$Excel-Macros$$ change in the attach macro

2017-02-09 Thread Izhar

A little changes is required in the attach macro, I tried it to change it
myself but failed

REQUIREMENT:
The colored range i.e A2:I18 to be copied below the range fifteen times

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


copy 1 to 15,  fifteen times.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ How to pick one webpage each from a collection of web page list!!!

2017-02-09 Thread Ramiz Majid

I have a list of webpages contacting different domain pages!!!

I want to pick a single webpage of each domains

Please help !

*This is an example list: *



*And I need this as .*



Thanks!

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ How to pick one webpage each from a collection of web page list!!!

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

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

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

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

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

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

$$Excel-Macros$$ Senior .Net Developer @ Santa Clara, CA

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

$$Excel-Macros$$ change in the attach macro

$$Excel-Macros$$ How to pick one webpage each from a collection of web page list!!!

11 matches

Site Navigation

Mail list logo

Footer information