How to select range by using named ranges in cell address

[mdd16]

Hello,

I have a two cells "A10" named TabBeg and "Axx" named TabEnd. I use these two named cells to mark beginning and end of table. The no of rows between these two cells keeps changing with use.

For example at a particular moment I have A10 as TabBeg and A20 as TabEnd

In "B11" to "B19" I have some strings which can contain "/" character. I need use these strings in file names that I create along the way. Since windows won't allow "/" in the file names I have to change them to "-" by using find-replace method.

Problem :
How do I select the range between B11 and B19 ( and the row number 19 would keep changing dynamically with use) by using TabBeg and TabEnd.
and apply find-replace code.

Sorry if it is too much ask.. and thanks in anticipation of help.

 

[StephenCrump]

Range("B" & Range("TabBeg").Row + 1 & ":B" & Range("TabEnd").Row - 1).Replace What:="/", Replacement:="-", LookAt:=xlPart

 

[mdd16]

Range("B" & Range("TabBeg").Row + 1 & ":B" & Range("TabEnd").Row - 1).Replace What:="/", Replacement:="-", LookAt:=xlPart

Stephen..Thanks for your support..I was looking to solve this sort of offset selection for a long time..

This method of selection of range will be useful for me in many situations

The original problem I solved with a better solutions. When I am picking the string, I am now replacing the "/" there

strFilename = Replace(strFilename, "/", "-")