Hello,
I have built a workbook for a client that consists of simple formulas and a very basic Macro. I am using Excel 2011 and the Macro runs perfectly with no issues. However, when my client runs the Macro on his computer (he is using Excel 2016), the workbook crashes. We are both using Mac laptops. Here is the VBA code:
Sub Insert2()
'
' Insert2 Macro
'
'
Range("A3:O3").Select
Selection.Copy
Range("A12:O12").Select
Selection.Insert Shift:=xlDown
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats
End Sub
Any thoughts would be greatly appreciated since this problem has completely baffled me. The code is simple and causes no issues when I run it. Thanks!
Bookmarks