Copy Data from Google Chrome vs. Internet Exployer

[mikeannetta]

Copy data from Internet Explorer vs Google Chrome



Every few days I import data from my Online Baking Account into my Excel based Budget Tracker.
When I use Google Chrome and connect to the bank, the import macro works perfectly.
However, if I use IE I get the following error?

"Rub-time error '1004':
We can't paste because the Copy area aren't the same size....."


Like I said, the only difference is Google Chrome vs IE.
FYI: I’m using Excel 2013, Windows 10, IE ver. 11.0.22 and Google Chrome ver. 45.0.2454.101m


Here is what the VB Debug Shows!

 ' STEP 2
 Sheets("Import Checking").Select

 ActiveCell.Offset(5, 11).Range("A1").Select
 Range(Selection, Selection.End(xlDown)).Select
 Range(Selection, Selection.End(xlToLeft)).Select
 Application.CutCopyMode = False
 Selection.Copy
 ActiveCell.Activate
 Selection.Copy
 Sheets("PIVOT DATA").Select
 Application.Goto Reference:="R100000C1"
 ActiveCell.Offset(0, 1).Range("A1").Select
 Selection.End(xlUp).Select
 ActiveCell.Offset(1, 0).Range("A1").Select
 Selection.PasteSpecial Paste:=xlPasteValues, Operation: =xlNone, SkipBlanks _
 :=False, Transpose:=False
 Range("A1").Select
 Sheets("Import Checking").Select
 Application.CutCopyMode = False
 Sheets("PIVOT DATA").Select

Any suggestion on what and why its not working?

 

[RoryA]

I'd guess there are merged cells in either the range you're copying, or the destination. Or else the copied range won't fit on the sheet.

 

[mikeannetta]

"RoryA, why does it work getting the data from Google Chrome and Not IE or even using Microsoft Edge? I'm baffled!

 

[RoryA]

I don't know for sure - I can only assume that Chrome renders the site slightly differently to IE/Edge.

 

[mikeannetta]

Thanks for looking at this! If I find out any other reason, I'll re-post.