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

2017-01-23 Thread silvers.r via MS EXCEL AND VBA MACROS 


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, 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.xersat
  in tara  in lungi si complicate procese  isi
  gaseste aici o noua confirmare 
  
  -- 
  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$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

2017-01-23 Thread silvers.r via MS EXCEL AND VBA MACROS 


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, 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.xersat
 in tara  in lungi si complicate procese  isi
 gaseste aici o noua confirmare 
 
 -- 
 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

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

2017-01-23 Thread libertystringer via MS EXCEL AND VBA MACROS 


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, 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.xersat in tara  in lungi si complicate 
procese  isi gaseste aici o noua confirmare 

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

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

2017-01-23 Thread julienneschindler via MS EXCEL AND VBA MACROS 


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, 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$$ Using Microsoft Query with "group by" SQL clause

2017-01-23 Thread luciano de souza 
Hello all,
I AM trying to use the wonderful feature of Microsoft Query.
I want to use a Excel workbook as a database, so I have created the
attached workbook.
Sales.xlsx is the source, so another workbook for reports is created.
When I pointed to the Sales.xlsx, in external data settings, the
following connection string was automatically defined:

Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data
Source=C:\n\Vendas.xlsx;Mode=Share Deny Write;Extended
Properties="HDR=YES;";Jet OLEDB:System database="";Jet OLEDB:Registry
Path="";Jet OLEDB:Engine Type=37;Jet OLEDB:Database Locking Mode=0;Jet
OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk
Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create
System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't
Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica
Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False

I tried the following SQL to get data:
Select * from records;

The success was absolute. So I tried:
Select sum(receita) from records;

Having gotten na error, I set  “support complex data” to true. So I
have success again.
However, I could not understand how to use SQL with the “group by”
clause. For example:
Select Store, sum(revenue) as Revenue from records group by Store;

I have a error message:
No value is supplied to one or more parameters.

I don’t know what it means, so I ask the help from you.
I know it’s not a doubt directly linked to VBA, but as I could not
find the answer and I know, in this group, there are many Excel
experts, I decide to ask you a help.
I thank you very much for any support.


-- 
Luciano de Souza

-- 
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$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

2017-01-23 Thread GENIUS 
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.

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

2017-01-23 Thread mintaspriggs via MS EXCEL AND VBA MACROS 


On Mon, 1/23/17, Paul Schreiner  wrote:

 Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES
 To: "excel-macros@googlegroups.com" 
 Date: Monday, January 23, 2017, 2:42 PM
 
 Are
 you wanting the end result such that cell A19 contains
 "Bill" (the value of A2)A20 =
 JoeA21 =
 DaveA22 =
 Fredand
 so on, then repeating this series for 15 sets?
 For
 THAT, you could use something like:Option ExplicitSub
 Dup_Sets()
    
 Dim nRow, nRows, dRow, SetCnt, SetNo
    
 SetCnt = 15
    
 
    
 nRows =
 Application.WorksheetFunction.CountA(Range("A:A"))
    
 
    
 For SetNo = 1 To SetCnt - 1
    
 For nRow = 2 To nRows
    
 Debug.Print nRow + (SetNo * (nRows - 1))
    
 Cells(nRow + (SetNo * (nRows - 1)), "A").Value =
 Cells(nRow, "A").Value
    
 Next nRow
    
 Next SetNo
 End
 Sub
 If that's not what you
 meant, then I need further explanation.
 
 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 20, 2017 11:15 PM,
 Izhar  wrote:
   
 
  
 I need code for the above nameSCENARIOif I want to copy the above
 names below the range for about 15
 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.
 
 
  

 
 -- 
 
 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.
 lteta Regala  ceea ce a semnificat intarirea prestigiului sau  dar si  in 
special  afirmarea unui nou statut international pentru Romania. Ulterior  
guvernele europene au recunoscut noul titlu oficial. Consolidarea pozitiei 
internationale a tarii noastre dupa cucerirea independentei de stat a permis 
proclamarea Romaniei ca regat. Aceasta s-a realizat la 14 martie 1881  dupa 
votul din parlament. in urma unor festivitati  la 10 22 mai 1881 Carol'si sotia 
sa  Ehsabeta de Wfeo poeta Carmen Sylva   au fost incoronati.

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

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

2017-01-23 Thread Paul Schreiner 
Are you wanting the end result such that cell A19 contains "Bill" (the value of 
A2)A20 = JoeA21 = DaveA22 = Fredand so on, then repeating this series for 15 
sets?
For THAT, you could use something like:Option ExplicitSub Dup_Sets()
    Dim nRow, nRows, dRow, SetCnt, SetNo
    SetCnt = 15
    
    nRows = Application.WorksheetFunction.CountA(Range("A:A"))
    
    For SetNo = 1 To SetCnt - 1
    For nRow = 2 To nRows
    Debug.Print nRow + (SetNo * (nRows - 1))
    Cells(nRow + (SetNo * (nRows - 1)), "A").Value = Cells(nRow, 
"A").Value
    Next nRow
    Next SetNo
End Sub
If that's not what you meant, then I need further explanation.

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 20, 2017 11:15 PM, Izhar  wrote:
 

 
I need code for the above nameSCENARIOif I want to copy the above names below 
the range for about 15 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.


   

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