Use a string to represent a range object

[gnawoncents]

Greetings,

I am trying to find out if something is possible in Excel VBA. I would like to use a string or integer to modify/represent the name of a range object. Please note that I do not have a range stored in string format.

For example, I have the following range objects already set: rng1, rng2, rng3, etc.

I am looping through rows and want to change the associated range with each iteration, using either a string or integer. Below is a sample of the code (not working) I need help with.

Dim loImmobile As ListObject
Dim rowImmobile As ListRow
Dim shtImmobile As Worksheet
Dim rngPlace As Range
Dim intCount As Integer
 
Set shtImmobile = Worksheets("shtImmobile")
Set loImmobile = shtImmobile.ListObjects("tblImmobile")
intCount = 5
 
For Each rowImmobile In loImmobile.ListRows
        rngPlace = RandCell(Rng(intCount))
       'Do things with rngPlace
        intCount = intCount + 1
Next rowImmobile
 
 

The problem area is in the line below. RandCell calls a function that retrieves a random cell from the given range.

        rngPlace = RandCell(Rng(intCount))
 

Thank you for your help!

[Luuk]

With the line below you can select all kind of range's

Range(Cells(row1, col1), Cells(row2, col2)).Select

With the values:
row1=2, col1=2, row2=4, col2=5,
You will select the range "B2:E5"

[Luuk]

sorry, duplicate posting.. ;(