| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define variable range
Hi
I'm not even sure this is possible so advice would be welcome! I need to define a y range based on two variable x parameters, x1 an x2. To give an example, x values ranging as integers from 4 to 16 are i column A (A1:A13) on my spreadsheet, corresponding y values in colum B. I have listed x1 in cell E1 and x2 in cell F1. x1 = 0 and x2 = 1 for this particular example. If 0<=x<12, I want to define the corresponding y range from column B. Here it would be the range B1:B8. Any suggestions -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define variable range input for SUM() function | Excel Worksheet Functions | |||
| Define Variable Name using VBA | Excel Discussion (Misc queries) | |||
| Using a Variable to Define Series | Charts and Charting in Excel | |||
| How to take the worksheet name as a variable(Label/Define) in a fo | Excel Worksheet Functions | |||
| Syntax to define a variable for current file | Excel Programming | |||
Threaded Mode
