Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

EXCEL 2007

Helllo,
trying to find an easy way to copy and paste cells in excel.
I have 136 cells , under column "A", starting from "A7"
I need to copy "A7" 132 times under column "A", and paste them starting "A150", then copy "A8" 132 times and paste after first paste (starting "A282") and so on..

Any help is appreciated
Thanks.
sample.xlsx
0
W.E.B
Asked:
W.E.B
1 Solution
 
m4trixCommented:
It doesn't copy and paste (to make it faster) but it accomplishes the same result. The values in this version are fixed, so if your ranges are dynamic this solution will need to be adjusted

Sub fillCells()
    Dim rowA As Integer, copyRow As Integer
    
    copyRow = 150
    For rowA = 7 To 138
        Range("A" & copyRow & ":A" & copyRow + 131) = Range("A" & rowA)
        copyRow = copyRow + 132
    Next rowA
End Sub

Open in new window

0
 
W.E.BAuthor Commented:
works like a charm,
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now