Hi there,

If anyone has any ideas on this I would like a macro which looks through a range of data and if " " is found (a space) then it is replaced with "" (nothing)

I have the following code however this doesn't work if there are no " " to begin with as an error popups.

Range(Cells(firstrow, "A"), Cells(lastrow, "AT")).Select
        Selection.Replace What:=" ", Replacement:="", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
        Range("A1").Select

Any ideas?
Thanks