|
-
Oct 4th, 2008, 07:23 AM
#1
Thread Starter
Addicted Member
[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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|