Well, I am back again. Excel is not recongizing the Application.GOTO method. The error highlights the .GOTO and states "Compile Error, Data Member or Method Not Found." I can connect to Excel through VB and I have already gotten a lot of information from Excel to Access VIA VB. I just keeping getting this error. HELP?

Even after I activate the sheet, I can't pull values out of the current selected sheet. Any help would be appreciated.

~ Jason