Copy Range Where Last Row Number Is In a Cell

JohnDrew · Mar 15th 2008

I have this statement

Code

Range("J4:J367").Select
    Selection.Copy

In X1, I have 400 and wish to use this cell value as a varible in the copy range statement.

This would make the new

Code

Range("J4:J400)

AAE · Mar 15th 2008

Re: Copy Data To Range Identified By A Cell Value

Please use code tags!

Code

Dim i As Long


    i = Range("X1")


    Range("J4:J" & i).Copy

Bill Rockenbach · Mar 15th 2008

Re: Copy Data To Range Identified By A Cell Value

or

Just

Code

Range("J4:J" & Range("X1")).Copy

Dave Hawley · Mar 15th 2008

Re: Copy Data To Range Identified By A Cell Value

JohnDrew, please code tags on ALL code.

Participate now!