Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a Range of (Variable) Rows
Hi, I suspect this might not be too difficult, but I'm a VBA novice! "Help" didn't help, so here I am... I am trying to select a Range of Rows by using Variables to define the starting and ending Rows. The command *Rows("X:Y").Select* would have worked if I had fixed rows to select. I.e. if I knew that my range should contain rows 3 to 5 then *Rows("3:5").Select* would have been ok. The problem is that I want X and Y to be variables, established in between the programme flow. That is, I want the programme to identify a number of consecutive Rows, and select them all together so as to perform some action on them. I face this problem often, when I can find acommands in VBA that correspond to strings of fixed values for a range, and not to variables. Any help? Many thanks -- Loucas ------------------------------------------------------------------------ Loucas's Profile: http://www.excelforum.com/member.php...fo&userid=5509 View this thread: http://www.excelforum.com/showthread...hreadid=537359 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select a variable range | Excel Worksheet Functions | |||
Use a Variable to select a range | Excel Discussion (Misc queries) | |||
Using variable to select rows | Excel Programming | |||
Select a Range Through a Variable | Excel Programming | |||
Select rows using a variable | Excel Programming |