Unanswered: how do a modify this find and replace code?
hey guys, this
particular macro does a find and replace but how do i do it so it runs the macro until it reaches the last record of the column? Right now it only does sepcified records in the column but the dataset changes everysay so i need to run it until it reaches eod of last record.
Selection.Replace What:= null, Replacement:="none" LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _