[RESOLVED] selecting information

[MORT1703]

Hi

I have a list of bills displayed on a worksheet - 1 bill to a row
I have a variable called BillCount - which works out how many bills I have

my bill display from cell "B6"

QUESTION
I need to select a range starting at "B6" and ending with the last row of bills.
so for arguement sake - I have 10 bills starting at cell "b6" and ending at cell "b16"

I can't use the following statement

Worksheets(ASheet).Range("B6:B16").Select

because I need to replace "B16" with the variable BillCount

so i get I need to be able to select a range using a variable

any one got any ideas

[si_the_geek]

Like this:

Worksheets(ASheet).Range("B6:B" & (6+BillCount)).Select