I wonder if anyone could help me.
I am setting up an input sheet, where the user will type in the cell reference such as B2. However, I have a macro that requires Cells(2,2) rather than B2. I won't go into the reasons why just yet, they aren't relevant just now.
So, currently, instead of letting the user type B2, I have two columns - one for Row number, and the other for Col number like this
Row Col
24 2
35 6
3 13
I will probably let the user type in B2, F67 or whatever in column "A" of a spreadsheet, then have some functions in column B and C to give us the row and column numbers respectively (probably by manipulating text strings etc.)
If anyone can help me out finding such functions then this would be cool. I want the end result to look like this
CellRef Row Col
B2 2 2
D5 5 4
D7 7 4
Where the user enters only the cellRef and the Row& Col are calcualted by formulas on sheet. Thanks.
This message was edited by RET79 on 2002-03-26 19:23
I am setting up an input sheet, where the user will type in the cell reference such as B2. However, I have a macro that requires Cells(2,2) rather than B2. I won't go into the reasons why just yet, they aren't relevant just now.
So, currently, instead of letting the user type B2, I have two columns - one for Row number, and the other for Col number like this
Row Col
24 2
35 6
3 13
I will probably let the user type in B2, F67 or whatever in column "A" of a spreadsheet, then have some functions in column B and C to give us the row and column numbers respectively (probably by manipulating text strings etc.)
If anyone can help me out finding such functions then this would be cool. I want the end result to look like this
CellRef Row Col
B2 2 2
D5 5 4
D7 7 4
Where the user enters only the cellRef and the Row& Col are calcualted by formulas on sheet. Thanks.
This message was edited by RET79 on 2002-03-26 19:23