Copy in VBA problem

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

I'm trying to automatically insert some data copied from an Access table
into an Excel spreadsheet into another Excel spreadsheet.

Both sheets are open and referred to as objExcel & objExcel1.

I get "Copy method of Range class failed" with the following line.

objExcel1.range("A1:H1").copy objExcel.range("A5")

Any ideas?

Ian
 
I'm not an Excel MVP, but offhand it appears as if your 2 ranges do not
match in size. You may want to ask this in an Excel newsgroup as well.
 
I'll try adjusting the destination size later on, but in Excel, unless there
are merged cells, you only need to state the top. left cell.

Thanks for the suggestion.

Ian
 
Hi Arvin

I'm afraid it din't work, but I've found another method that works.

Ian
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alt codes 4
Macro to copy value in field and insert it into filter 2
Excel VBA - Problem with Closing Print Preview 0
Access VBA creating an Excel spreadsheet with a total line 5
Export to Excel 3
Range as cell numbers 11
How to copy curtain data fields from excel to access table via VBA 2
Excel Macro to use cells as a autofilter 0

Back
Top