Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need a variable name to contain the values of several cells
I need a variable name to contain the values of several cells.
For example, If the value of cell A2 = "J10" and the value of cell B1 = "2", I need a variable named "J10-S2". I will be creating a series of these variable names from cells A2-A40 and B1-H1. The value assigned to each of these variables will be the value of the cell at the intersection of these cells. The value of the variable "J10-S2" will be the value of cell B2. I can handle this part of the problem...I'm just drawing a blank on creating and intiializing the variable name. Can anyone get me started? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to set current cell (variable row) to sum values of all cells above | Excel Programming | |||
Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
Defining a variable Range for cells with values in them! | Excel Programming | |||
To fetch the values from the excel cells into the variable | Excel Programming | |||
Cells.Find error Object variable or With block variable not set | Excel Programming |