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
Bookmarks