L
Legacy 98055
Guest
Hi again!
Here's the deal for example
Cell C1 contains a string that varies.
We'll say for this example string in C1 = 4-7
The string in C1 can vary from 4-1 or Col 4/Row 1 to 254-2000 Col IT/ Row 2000
In essence, the range D1:IT2000
There will always be a dash seperator.
A formula in Cell A1 will use this value as
follows.
Formula I can't get to work:
A1 = The value of the cell in Col 7/Row 4
or in this case A1 = G7
Using the value of C1 which is 4-7
I am new to Excel and am trying to learn alternatives to VBA when applicable.
Thanks again Glad Posters!
Tom
Cannot find anything in help for this.
This message was edited by TsTom on 2002-03-26 19:05
Here's the deal for example
Cell C1 contains a string that varies.
We'll say for this example string in C1 = 4-7
The string in C1 can vary from 4-1 or Col 4/Row 1 to 254-2000 Col IT/ Row 2000
In essence, the range D1:IT2000
There will always be a dash seperator.
A formula in Cell A1 will use this value as
follows.
Formula I can't get to work:
A1 = The value of the cell in Col 7/Row 4
or in this case A1 = G7
Using the value of C1 which is 4-7
I am new to Excel and am trying to learn alternatives to VBA when applicable.
Thanks again Glad Posters!
Tom
Cannot find anything in help for this.
This message was edited by TsTom on 2002-03-26 19:05