error while selecting last cell from access vba

[allenjasonbrown@gmail.com]

Does anyone see anything wrong with this?



xlWB.worksheets(1).Range("A1").End(xlToRight).Sele ct

I am receiving an error:
Application-Defined or object-defined error


If I use this it works fine:
xlWB.worksheets(1).Range("A1:H1").Select

[boblarson]

If using LATE BINDING then you need to provide the value for xlToRight either as the value or set up a constant

Const xlToRight As Integer = -4161