Usar Macro de windows en Mac
Hola compañeros, tengo éste código en mi excel windows.
Necesito usarlo EN MAC pero no sé la manera. Solicito su ayuda por favor.
Gracias
Sub AddClient() Set h1 = Sheets(“Clientes”) Set h2 = Sheets(“Clientes”) j=h2.Range(“A” & Rows.Count).End(xlUp).Row For i = 10 To 10 If h1.Cells(i, "B") > 0 Then h2.Cells(j, “A”) = h1.Cells(i, “B”) h2.Cells(j, “B”) = h1.Cells(i, “C”) h2.Cells(j, “E”) = h1.Cells(i, “E”) h2.Cells(j, “F”) = h1.Cells(i, “F”) h2.Cells(j, “G”) = h1.Cells(i, “G”) h2.Cells(j, “H”) = h1.Cells(i, “H”) h2.Cells(j, “K”) = h1.Cells(i, “K”) h2.Cells(j, “L”) = h1.Cells(i, “L”) h2.Cells(j, “M”) = h1.Cells(i, “M”) h2.Cells(j, "N") = h1.Cells(i, “N”) h2.Cells(j, “O”) = h1.Cells(i, “O”) h2.Cells(j, “P”) = h1.Cells(i, “P”) j = j + 1 End If Next MsgBox “Cliente Agregado“ End Sub