Range(ActiveCell.offset always fails second time run

Row 505 - hard code in offset value and the code works just fine over and over.
Row 510 or 511 using variable - It works the first time through, but always fails the second time through Error 91 Object Variable

Please Login or Register  to view this content.

Instead of ActiveCell use objXL.ActiveCell

Wow, I tried and it works Access 2007 calling Excel 2007.
But of course... how could I have missed that?
Thanks so much!

510 ObjXL.Workbooks(1).Worksheets(1).Range(ObjXL.ActiveCell.Offset(0, 0), ObjXL.ActiveCell.Offset(0, intMaxheaderColCount)).Select

Click the Edit button in the first post in this thread, then click Go Advanced. Next to the thread title there is a Prefix drop-down box. Select 'Solved' and then submit.