Hello,
I keep getting this error every so often and it does not stop until I
reboot.

Method 'Range' of object '_Global' failed

I'm writing to an Excel workbook from Access VBA.
I really don't know why it works sometimes and not other times.
Regards
Brian

Dim XL As Excel.Application
Dim XLW As Excel.Workbook
Dim XLS(5) As Excel.Worksheet
Dim rng As Excel.Range

Set XL = New Excel.Application
XL.ReferenceStyle = xlR1C1
Set XLW = XL.Workbooks.Add
XLW.Saved = False
Set XLS(1) = XLW.Worksheets.Add
.....
Set XLS(4) = XLW.Worksheets.Add
...
Set rng = XLS(1).Range(XLS(1).Cells(0 + 4, lngTotalCol + 1).Address)
rng.FormulaR1C1 = "=" & XLS(4).Name & "!RC"
rng.Select
rng.AutoFill Range(strColName(rng) & "4:" & strColName(rng) &
CStr(intNumIntervals + 4)), xlFillDefault
^^^^ gives the error