Roz Clarke
roz.clarke at donnslaw.co.uk
Tue Aug 12 10:11:56 CDT 2003
Any Excel gurus out there who can tell me why this:
oApp.Goto Reference:=shtCurr.Range("qryF1")
would return an 'Application-defined or object-defined error'??
TIA
Roz
(PS the full code is
Set oBook = GetObject("I:\IT\Systems Dev\Jobs\821GFGMIS\BBS Format UKI
Donns.xls")
Set oApp = oBook.Parent
Set shtCurr = oBook.Sheets(Format(Forms!frmGreenFlag!txtBeginningDate,
"mmmm"))
oApp.Goto Reference:=shtCurr.Range("qryF1")
with qryF1 being a single-cell range which exists on all the sheets in the
workbook.)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030812/d30ff9b2/attachment.html>