Hi everyone
I have a macro that does not work when ported from a windows version of excel to a mac version of excel.
The error displayed is code 1004 - Application-defined or object-defined error
My macro is simple - looks like this:
Sub Macro12()
'
' Macro12 Macro
'
'
Sheets("Formatted").Select
Columns("A:E").Select
Selection.ClearContents
Range("A1").Select
Sheets("Time Stamps").Select
Columns("A:A").Select
Selection.Copy
Sheets("Formatted").Select
Columns("A:A").Select
ActiveSheet.Paste
Selection.Replace What:=" ", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="Endoffile.", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Application.CutCopyMode = False
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1)), TrailingMinusNumbers:=True
Range("A1").Select
Sheets("Graph").Select
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
End Sub