P
PP
Hi All
We have a requirement whereby we would like to loop-thru range of cells,
read the values from these cell range and then do certain action.
For example, we will define list of values in a column say C5:C25
......D525; see example below
---------------------------
C D
---------------------------
5 AgentID 10
6 Agentname 25
7 Address 20
........
What we would like to do is
1. Read the Cells one by one starting [C5 and D5] , then [C6 and D6] and
then [C7 and D7]...
2. The value in C5 will be the Column in Pivot table
The value in D5 will be the Column Length for that column
3. Repeat the same (in-loop) for C6 and D6......... C25 and D25
4. The only catch is, the MAX range is un-predictable, it could be C5 - C10
for one report and C5-C15 for others.
Is this in any way achieveable? I know we can give some "Virtual Name" for
the cells of the excel, not sure if I can do that for range of Cells.
Thanks
Prasanna
We have a requirement whereby we would like to loop-thru range of cells,
read the values from these cell range and then do certain action.
For example, we will define list of values in a column say C5:C25
......D525; see example below
---------------------------
C D
---------------------------
5 AgentID 10
6 Agentname 25
7 Address 20
........
What we would like to do is
1. Read the Cells one by one starting [C5 and D5] , then [C6 and D6] and
then [C7 and D7]...
2. The value in C5 will be the Column in Pivot table
The value in D5 will be the Column Length for that column
3. Repeat the same (in-loop) for C6 and D6......... C25 and D25
4. The only catch is, the MAX range is un-predictable, it could be C5 - C10
for one report and C5-C15 for others.
Is this in any way achieveable? I know we can give some "Virtual Name" for
the cells of the excel, not sure if I can do that for range of Cells.
Thanks
Prasanna