| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting the cell number as a variable
Is there a way to set the number of a cell (A5) as a variable (A(variable))
so that I would be able to select different cells in column A by changing the variable? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Setting the cell number as a variable
Let's say your variable number is located in cell A1, and you want to
reference somewhere in column B. Use this formula: =INDIRECT("A"&A1) You can see the help file for further details, if you need them. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Intern" wrote: Is there a way to set the number of a cell (A5) as a variable (A(variable)) so that I would be able to select different cells in column A by changing the variable? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting number in cell back to zero | New Users to Excel | |||
| Setting a string variable as the file name | Excel Discussion (Misc queries) | |||
| variable number format in cell | Excel Discussion (Misc queries) | |||
| Setting Cell Number Format With A Worksheet Function | Excel Worksheet Functions | |||
| Setting a variable cell address | Excel Discussion (Misc queries) | |||
Linear Mode
