Copying range from one worksheet to another

Question

I'm trying to copy everything from column A in sheet1 to sheet2. The issue is that it won't be a static range, i.e the numbers of rows in column A isn't constant. Below is what I'm using that works for 100 rows, how would I change it to work for x rows? Thanks very much in advance.

Sheets("Sheet2").Range("A2:A102").Value = Sheets("Sheet1").Range("A5:A105").Value

score 0 · Accepted Answer · edited May 23 '17 at 11:49

0

Try this one:

x = 100
Sheets("Sheet2").Range("A2").Resize(x).Value = _
            Sheets("Sheet1").Range("A5").Resize(x).Value

if you want to use last used row instead x, look into this answer: How to determine last used row/column

edited May 23 '17 at 11:49

Community

1
1

answered Mar 24 '14 at 18:47

Dmitry Pavliv

35,333
13
79
80

1

thanks! the last used row was exactly what i needed! – user3456223 Mar 24 '14 at 19:56

Copying range from one worksheet to another

1 Answers1