<method 'Cells' of Object' _worksheet 'failed>

[Smee]

Hey all


I keep getting this error

:-

<method 'Cells' of Object' _worksheet' failed>

on this line

:-

If xlSheet.Cells(DataEnd + 1, 3) = "" Then

I have several lines of code like the one above in the module and the program seems to randomly pick which one causes the error on each run.

Any help much appreciated.

Thanks

 

[Smee]

Sorry - it was my own stupid fault.

It was part of an excel opening/importing thing. I was closing the excel window, and then going back to Access to finish the program. Because I had closed down the Excel window I got the above error.

Thanks