selecting an individual cell from a range

mortgageman

Well-known Member
Joined
Jun 30, 2005
Messages
2,015
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
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi, Gene,

you were close
Code:
Range("Rpt_BorrowerCode")(1).Select

kind regards,
Erik

EDIT: perhaps a bit more info
Code:
Range ("Rpt_BorrowerCode").Item(1).Select

Code:
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

Well-known Member
Joined
Jun 30, 2005
Messages
2,015
Thanks - One day I'll learn to try all the combinations without giving up.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,676
Messages
5,549,373
Members
410,911
Latest member
AniEx
Top