Run-time error '1004' in Win10 not Win7

[MichaelRSnow]

Hi

I get the following error on the below code (Run-time error '1004' Application-defined or object-defined error), which is very strange as when I run this on my windows 7 machine it runs fine but when I run it from my Windows 10 machine it falls over. Also if it step through the code manually with F8 on the Windows 10 machine it also works fine?

Any ideas? I'm stumped ?

'paste output in destination format
ThisWorkbook.Worksheets(sheetName).PasteSpecial Format:="HTML", Link:=False, DisplayAsIcon:= _
False, NoHTMLFormatting:=True

 

[Zot]

Do both PCs have same Excel version?

 

[MARK858]

Can you post the 2 lines above the one you posted please. I suspect that you are coming out of copy mode before the paste.

 

[MichaelRSnow]

Hey Mark858, yeah I think you are right as when I placed a MsgBox above the code to confirm the Scenario being pasted it stopped the error, this was the previous code below, what is the best solution to overcoming this? My MsgBox solution isn't the best idea

'results page
ie.ExecWB 17, 0 '// SelectAll
ie.ExecWB 12, 2 '// Copy selection

'creates sheet and names it 'scenario x'
scenarioNumber = shtMacro.Range("B2").Value
sheetName = "Scenario" & scenarioNumber
Worksheets.Add().Name = sheetName

 

[MARK858]

Try moving the Select/Copy below the Worksheets.Add

 

[MichaelRSnow]

So simple, works perfectly, never see the obvious answer

 

[MARK858]

You're welcome.