Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Advise, please, how to get the following macros working:

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 ?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007/macros not working hughesdm Excel Worksheet Functions 1 April 23rd 09 03:28 PM
Macros not working when file run on a Mac Darby Excel Discussion (Misc queries) 4 November 5th 07 02:49 PM
Macros written in UK not working in US Teresa Excel Discussion (Misc queries) 1 April 19th 07 06:59 PM
Working with Macros - Help needed!!! The Greek Excel Discussion (Misc queries) 2 November 19th 06 05:39 PM
Shift key to disable macros not working David P. Excel Discussion (Misc queries) 5 November 14th 05 07:52 PM


All times are GMT +1. The time now is 06:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ╘2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"