All,
I created a macro below but I received a syntax error. I created a macro to find the characters " and replace it with the " character for the active spreadsheet . Below is the macro coding.
Sub FindDataErrorMacro()
ActiveSheet.Range("a2").CurrentRegion
Cells.Replace What:=""” Replacement:=""", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
End Sub
I appreciate the help.
Haleakala 17
Bookmarks