VBA find/replace adding range to search

[fastballfreddy]

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!

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

 

[kevin9999]

Instead of

Cells.Replace

Try

Range("A1:A26").Replace

 

[fastballfreddy]

I figured it out. Sorry for the question.

 

[fastballfreddy]

Instead of

Cells.Replace

Try

Range("A1:A26").Replace

Thanks Kevin! appreciate your response

 

[kevin9999]

Thanks Kevin! appreciate your response

Happy to help