Advise, please, how to get the following macros working:

L

LikBez

Advise, please, how to get the following macros working:

Sub íÁËÒÏÓ1()
For a = 1 To 1000 Step 15
Rows("a:a").Select
Application.CutCopyMode = False
Selection.Copy
Rows("a+1:a+14").Select
ActiveSheet.Paste
Next
End Sub

Mission: to select every 15-th row, to copy and paste it to the following
15 rows.
Trouble: it doesn't accept variables as numbers of rows.
What should be syntax: Rows("a:a").Select ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top