MichaelRSnow
Active Member
- Joined
- Aug 3, 2010
- Messages
- 409
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 ?
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 ?
VBA Code:
'paste output in destination format
ThisWorkbook.Worksheets(sheetName).PasteSpecial Format:="HTML", Link:=False, DisplayAsIcon:= _
False, NoHTMLFormatting:=True