Hi ,
if you always want to select A4 to R4 just use
Range("A4:R4").Select

"merry_fay" wrote:

Hiya,

When I run the macro using this code:

Range("A4:R4").Select
Selection.End(xlDown).Activate
Selection.Copy

Only the bottom left cell is being selected. I need the whole range to be
selected.
Can anyone help please?

Thanks
merry_fay