nickirvine
12-23-2010, 03:17 AM
Hi,
Wonder if you can help me.
I'm trying to get a piece of VB code or a formula to add 1 to the figure in a cell. The cell it select and adds the figure to is based on the end result of a formula.
I.e
in one cell I have the collumn number and one cell I have the row number.
So Cell C1 on my sheet is the collumn letter so the value of C1 is "A",
Cell C2 is the Row number so the value of C2 is "4"
Is there a formula which will select the info from "C1" and "C2" and add one to the figure in "A4".
The worksheet is protected so I can't provide a physical example but that should be all the information you need.
Any help would be really appreciated.
Thansk,
Nick
Wonder if you can help me.
I'm trying to get a piece of VB code or a formula to add 1 to the figure in a cell. The cell it select and adds the figure to is based on the end result of a formula.
I.e
in one cell I have the collumn number and one cell I have the row number.
So Cell C1 on my sheet is the collumn letter so the value of C1 is "A",
Cell C2 is the Row number so the value of C2 is "4"
Is there a formula which will select the info from "C1" and "C2" and add one to the figure in "A4".
The worksheet is protected so I can't provide a physical example but that should be all the information you need.
Any help would be really appreciated.
Thansk,
Nick