Selecting a Range Using Variables in Excel

[OzzieOwl]

Help, I need to select a range of rows in excel, but the range needs to be selected from the following varibles.

rowa - Start Row
rowb - End Row

I've tried everything I can think of, but keep getting selection errors.

Has anyone got any ideas ?

 

[nath]

Hi MartinLymn

I think this is what you are looking for:

Sub test()
    Dim rowa As Integer
    Dim rowb As Integer

    rowa = 5
    rowb = 10

    Rows(rowa & ":" & rowb).Select

End Sub
[\code]

If not, what exactly do you want to do?

Nath

 

[OzzieOwl]

Thanks nath mate, thats brilliant.

Cheers Martin