How to highlight a range in a macro without replacing it with a range name such as C1:L15

Good Morning,

I am using record to write this macro and I am coping F4 to AU4 to changing range. When using the record it assigns a range to it. I have a X at the bottom of the column so when I go end down it will stop at the X and than I go up one, I than want to highlight to the right 41 spaces and paste. The macro below is what I am using below however it is not working. The columns to right are consistant however the colums down are not. I would appreciate any help i can get. Thanks.


Range("F4").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy
Range("F5").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveCell.Offset(0, 40).Select
ActiveSheet.Paste
End Sub