I am recording a simple macro that creates a data graph using two columns. When I run the macro code I keep getting the following error:

Run-time error '1004':

The formula you typed contains an error. To get assistance in entering a function, click OK,then click Function on the Insert menu. If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark (').

Here is the VB code:

Sub Macro4() ' ' Macro4 Macro ' ' Keyboard Shortcut: Option+Cmd+p ' Range("A1:B39").Select ExecuteExcel4Macro (FALSE,240,73) ActiveChart.SetSourceData Source:=Range("'5E627659 host-260'!$A$1:$B$39") End Sub 

I'm running Excel 2016 for Mac. When I try the same thing on a Windows machine, it works.