What character to be used to enter a "tab" in the find box?
D Dave Peterson Feb 28, 2007 #2 It would be the same as =char(9) in a cell, but alt-0009 didn't work for me.
G Gord Dibben Feb 28, 2007 #3 Neither for me, but this does work. Sub Remove_Tab() Selection.Replace What:=Chr(9), Replacement:=Chr(32), _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False End Sub Gord Dibben MS Excel MVP
Neither for me, but this does work. Sub Remove_Tab() Selection.Replace What:=Chr(9), Replacement:=Chr(32), _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False End Sub Gord Dibben MS Excel MVP
