How to run a macro on only certain Colmuns

[yannmn]

Hi-
I'm tying to run this macro on only column b-h. how do I select those columns instead of the whole sheet?

Sub text()
Dim Findtext As String
Dim Replacetext As String
Findtext = Sheets("sheet3").Range("b2").Value
Replacetext = Sheets("sheet3").Range("a2").Value
Sheets("sheet7").Select
Cells.Replace What:=Findtext, Replacement:=Replacetext, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub

 

[Eric W]

Range("B:H").Replace What:=Findtext, Replacement:=Replacetext, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

 

[yannmn]

Perfect thank you.

 

[Eric W]

Glad to help.