Not sure why my posts don't appear on the actual newsgroups all the
time. Anyway..
The following code should do what you're after:
Sub removeH()
Range(Cells(6, "H"), Cells(Rows.Count, Columns.Count)).Replace _
What:="h", Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, _
MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
End Sub
--
Paul
- Paul
------------------------------------------------------------------------
Paul's Profile: 1697
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=192578
http://www.thecodecage.com/forumz