A problem with the replace function

[LenaMWork]

Hi all

I`m trying to select dynamic range and replace a letter within that range
I identified the last row and column of the whole range by R and C respectively
I need to start my selection from the 1-st row, 3-rd column , so I wrote this code:

Range(Cells(1, 3), Cells(R, C)).Select
Cells.Replace What:="h", Replacement:="", LookAt:=xlPart, SearchOrder:= _
xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False

But it still replaces data in the 1-st column and 1-st row

Can anyone tell me what is the problem with this code?

 

[MickG]

Perhaps:-

Range(Cells(1, 3), Cells(R, C)).Replace What:="h", Replacement:="", LookAt:=xlPart, SearchOrder:= _
xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False

 

[JackDanIce]

Although you have the line and so selected: Range(Cells(1,3), Cells(R, c)).Select, your next line begins Cells.Replace and Cells on its own means the cells of the whole worksheet.

Instead, try:

Cells(1,3).Resize(R, C-3).Replace What:="h", Replacement:="", LookAt:=xlPart

 

[LenaMWork]

Although you have the line and so selected: Range(Cells(1,3), Cells(R, c)).Select, your next line begins Cells.Replace and Cells on its own means the cells of the whole worksheet.

Instead, try:

Cells(1,3).Resize(R, C-3).Replace What:="h", Replacement:="", LookAt:=xlPart

Thanks! Worked!!

 

[JackDanIce]

You're welcome