[RESOLVED] selecting information
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
Re: selecting information
Like this:
Code:
Worksheets(ASheet).Range("B6:B" & (6+BillCount)).Select