selecting an individual cell from a range

[mortgageman]

Easy question (I Hope)
If the following selects the entire range:
Range("Rpt_BorrowerCode").Select

How do I select the first (or ith) cell in that range

I have tried
Range("Rpt_BorrowerCode").Select[1]

and

Range("Rpt_BorrowerCode")[1].Select

Neither of which works

 

[erik.van.geit]

Hi, Gene,

you were close

Range("Rpt_BorrowerCode")(1).Select

kind regards,
Erik

EDIT: perhaps a bit more info

Range ("Rpt_BorrowerCode").Item(1).Select

Sub test()
Dim i As Long

    With Range("Rpt_BorrowerCode")
    .Item(.Cells.Count).Select
        For i = 1 To .Cells.Count
        .Item(i) = "cell " & i
        Next i
    End With
        
End Sub

 

[mortgageman]

Thanks - One day I'll learn to try all the combinations without giving up.

 

[erik.van.geit]

Thanks - One day I'll learn to try all the combinations without giving up.

you could write some VBA to do that