Select cells between the active cell and another column on same row

[CreativeUsername]

I'm not finding what I need.

I have the following code.

  Range("E1").Select
    Selection.End(xlDown).Select
    ActiveCell.Offset(1, 0).Select
    ActiveCell.FormulaR1C1 = "xxxxxx"
    Selection.AutoFill Destination:=Range("E58:AC58"), Type:=xlFillDefault
[CODE]

What I need to happen is fill the range of cells between the active cell in E and column AC on the same row as E with some "X" values. 

So Range("E58:AC58") is over specified.  If the data set is only 55 Items long then it fails.  I recorded this as a macro but am having trouble with the syntax to convert it to relative cells.

thanks,



That actually is only there to block excel from running a calculation and conditional format into infinity because I use the XL down later.  In small tests it wasn't recognizing the end of the data range unless I gave it that stop.

 

[CreativeUsername]

Oh! I got it!

  Range("E" & ActiveCell.Row & ":AC" & ActiveCell.Row).FormulaR1C1 = "xxxxxx" [Code]