Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setup a range based on a variable
Hello Group
I am trying to set up a range in which I input a number into a form, then the spreadsheet range will expand or retract accordingly. For instance if my range starts out at nothing and I input a "10" into the range box, then I want the range to be A1:J12. If I input a "5" into the same range box, then I want the range to be A1:E12. Basically the A1 is a constant and the 12 is a contant. Thanks in advance, James |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
setup a range based on a variable
Hi
try range(cells(1,1),cells(12,variable)) -- Regards Frank Kabel Frankfurt, Germany "James New" schrieb im Newsbeitrag ... Hello Group I am trying to set up a range in which I input a number into a form, then the spreadsheet range will expand or retract accordingly. For instance if my range starts out at nothing and I input a "10" into the range box, then I want the range to be A1:J12. If I input a "5" into the same range box, then I want the range to be A1:E12. Basically the A1 is a constant and the 12 is a contant. Thanks in advance, James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return a range based on a variable | Excel Worksheet Functions | |||
Formula based on variable range | Excel Worksheet Functions | |||
Deleting a range of rows based on a variable; syntax error | Excel Discussion (Misc queries) | |||
dynamic summed range based on a variable | Excel Worksheet Functions | |||
How can I assign a range starting cell based on a variable locati. | Excel Discussion (Misc queries) |