Thread: getting error message 3704 when running excel vba
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
m00n[_2_] m00n[_2_] is offline
external usenet poster
  
Posts: 3
Default getting error message 3704 when running excel vba
"TG" schreef in bericht
...
Hi!

I am getting runtime error 3704 application defined or object defined
error
when hitting the following line:

'Dump the records into the worksheet.
Sheet1.Range("A9").CopyFromRecordset Rs


Any help will be greatly appreciated.

Thanks!

JT

What if you activate the sheet first?
Like:

Sheet1.Activate
Sheet1.Range("A9").CopyFromRecordset Rs


Reply With QuoteReply With Quote