Macros from PC to edit to work in Mac

[Kazdima]

Hello all,
i have a Macro prepared in Excel 2013 for PC and need help to edit it to work in Mac.
I would appreciate anyone's help.
i made Bold the part which does not work.

Thank you.
====================================================================================
Sub Edit_New_Data()
Dim lastRow As Long

Application.ScreenUpdating = False
Application.CutCopyMode = False

With Sheets("Edit File")
.Columns("F:F").Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove

'Copy over data
Sheets("M_1").Range("B1:L1").Copy .Range("A1")
'Fill in formula
lastRow = .Cells(.Rows.Count, "E").End(xlUp).Row
.Range("F2:F" & lastRow).FormulaR1C1 = "=RC[-2]&RC[-1]"

.Columns("G:G").Replace What:=".", Replacement:="/", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

'Adjust formatting
With .Cells.Font
.Name = "Arial"
.Size = 8
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
.TintAndShade = 0
.ThemeFont = xlThemeFontNone
End With
Application.Goto .Range("A1")
End With
Application.ScreenUpdating = True
End Sub

 

[mikerickson]

The SearchFormat and ReplaceFormat arguments are not supported in Excel 2011 for Mac.

Removing those arguments should make it run.

 

[Kazdima]

I want to reformat dates (text format) like this

2010.11.08

<tbody>
</tbody>

in Column G:G which I run from a data base. How can I reformat them By Macro into 08/11/2010?
Or you are suggesting that I have to do it only manually and delete that Bold part?
Thank you.

 

[mikerickson]

Replace that line with

.Columns("G:G").Replace What:=".", Replacement:="/", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False

removing the two unsupported arguments.

Note, this is not a Mac/Windows issue per se, the SearchFormat argument was absent from Windows Excel VBA before 2013, its more an issue of age rather than platform.

 

[Kazdima]

Thank you very much, mikerickson. I tried in PC, it is working. It did not notice a missing part- Now I have to try in Mac-)