I think the problem lies with the xldown and xltoright parameters.

I moved the code around, accessing sheet two prior to sheet one and still get the same error. It does not seem to let me use the xldown, xltoright parameters unless the form was launched from that particular sheet.

And since this is a form, I can't use code like sheet(1).select since my focus is no longer on the workbook, but rather in the form itself.

Any other suggestions/?