fastballfreddy
Board Regular
- Joined
- Jan 13, 2015
- Messages
- 60
- Office Version
- 2016
- Platform
- Windows
I have the code below where I am finding/replacing. I want to only search in range A1:A26. Sorry I'm new to coding. I've searched but haven't found a way that works. Any help would be greatly appreciated. thanks!
VBA Code:
Sub Macro5()
'
' Macro5 Macro
'
Dim Findtext As String
Dim Replacetext As String
Findtext = Range("D1").Value
Replacetext = Range("F1").Value
Cells.Replace What:=Findtext, Replacement:=Replacetext, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub