Macro not working on other PCs

[Alualy92]

Hello,

My Macro is a very simple paste tool, including the unlocking of a sheet, content clearing, pasting data saved to the clipboard and then re-locking it. This works very well on my PC but it won't work on anyone elses when I send it to them to test. My code is:

Sub Paste3()
Application.ScreenUpdating = False
Sheets("Paste").Select
ActiveSheet.Unprotect Password:="XXXX"
Range("B3:G100000").ClearContents
Range("B3").PasteSpecial
ActiveSheet.Protect Password:="XXXX"
Application.ScreenUpdating = True
Sheets("Results").Select

End Sub

On other PCs, it usually gets to the paste part which is where it doesn't like it.

Thanks in advance.

 

[Norie]

What are you actually copying/pasting?

 

[Foz1980]

What version of excel are you using and what version are they using?

 

[Joe4]

Note that older version of Excel (and any "xls") files only allow up to 65536 rows. So you row references of 100000 are too big for that.

 

[Alualy92]

Hi,

I'm pasting in data taken from a system we use at work. This is in an Excel format and manually pasting in the data works perfectly. The macro isn't a necessity but it would be nice to have and would make things fool proof.

 

[Alualy92]

We are all using Excel 2010

 

[Alualy92]

Okay thanks for this information. 100,000 was used to cover the range but this was set to too many rows anyway.

 

[combs435]

https://support.office.com/en-gb/ar...ce-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6