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>