Application 'GoTo' Error With VB/Excel

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

I don't know what your problem is, but there is a full VB/Excel tutorial project at:

http://www.hobbithouseinc.com/VB

that may help solve the problem since it shows how to do what you want to do.

... but NOT the "goto" problem. I don't know about that. The project will show how to select a sheet and get values from it.