Selecting a range bases on 2 Variables

brgipple · Oct 30th 2005

Hello

I am wanting to select a range of cells in a column but the start point and end point will be different each time, The Column will be a Known each time though. I have the following code and wondering how to adapt it to do what i want.

Code

Range("D2:D" & NumOfRows).Select

I want to make the '2' of D2 a variable(StartOfRows). I know i'm just missing something simple.

Thank you all for youe help

Brian G.

jindon · Oct 30th 2005

Re: Selecting a range bases on 2 Variables

Hi
try
[vba]
Range("D" & StartOfRows & ":D" & NumOfRows).Select [/vba]

Dave Hawley · Oct 30th 2005

Re: Selecting a range bases on 2 Variables

Another way

Code

Dim lRowStart As Long
Dim lRowEnd As Long


    lRowStart = Range("D1").End(xlDown).Row
    lRowEnd = Range("D65536").End(xlUp).Row
        If lRowStart >= lRowEnd Then lRowStart = 1
        Range("D" & lRowStart & ":D" & lRowEnd).Select

Selecting a range bases on 2 Variables

Participate now!

Share