March 15, 2008 at 2:39 AM #1 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)
March 15, 2008 at 2:58 AM #2 Re: Copy Data To Range Identified By A Cell ValuePlease use code tags! Code Dim i As Long i = Range("X1") Range("J4:J" & i).Copy
March 15, 2008 at 3:33 AM #3 Re: Copy Data To Range Identified By A Cell ValueorJust Code Range("J4:J" & Range("X1")).Copy
March 15, 2008 at 5:23 AM #4 Re: Copy Data To Range Identified By A Cell ValueJohnDrew, please code tags on ALL code.