VBA: code check to auto copy and paste into new column

With Worksheets(“Imminent”)
.Range("AT1:AT45").Copy
.Range(“AU1:AU45").PasteSpecial xlPasteValues
End With

Hi everybody. I am using Excel 2011 (macro enable workbook) on my Mac and can't seem to get this code to run (in 2013, it would show up as a macro, but it isn't here). I just wanted to check if the VBA is correct before I send this off to a colleague. If not, could you let me know why it is wrong? Thanks.


Screen Shot 2014-10-08 at 11.45.24 PM.jpg