PDA

View Full Version : change part of a string



udigold1
06-29-2008, 10:24 AM
Hi there,

How can I replace ,using VBA, a part of a string?

For example from "End of December" to "End of January".

Thanks,

Simon Lloyd
06-29-2008, 10:28 AM
Cells.Replace What:="December", Replacement:="January", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False