Now open Excel Options again and put it back into A1 display mode by unchecking the R1C1 reference style checkbox (followed by clicking the OK button). Okay, now that you have Excel Options open, select the Formula item on the left and look for a section titled similar to Working with formulas in which you will find a checkbox with the caption R1C1 reference style.Įxcel is now in R1C1 display mode (you can tell because the column header letters have now turned to numbers).Ĭopy paste the above formula into whatever cell it was originally destined for (to do this, you will need to convert the column letter for the cell to a column number, the row is already a number).įor the above formula, lets say that cell (the ActiveCell in your example code line) is E10. TRIM(R-9C-2) Since it is an R1C1 formula, switch Excels display format to R1C1 display mode.
0 kommentar(er)
