VBA increment row number by using a variable

Question

I have got this statement of code

Range("A"&Number :"W" & Number).Copy

Where Number is a digit representing the row. But this particular range doesn't seem to work well. I get a compile error and i don't know how to fix the Range to include a variable that increments the row number

Any help on that would be appreciated.

Pankaj Jaju · Accepted Answer · 2014-02-17 16:59:47Z

3

Try this

Range("A" & Number & ":W" & Number).Copy

answered Feb 17, 2014 at 16:59

Pankaj Jaju

5,5112 gold badges29 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dick Kusleika · Accepted Answer · 2014-02-17 23:40:54Z

0

Here's another way

Const COLW As Long = 23

Cells(Number,1).Resize(1,COLW).Copy

answered Feb 17, 2014 at 23:40

Dick Kusleika

33.3k4 gold badges56 silver badges81 bronze badges

Collectives™ on Stack Overflow

VBA increment row number by using a variable

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related