This formula is used to get a cell value for cell name referred in a cell. This formula can be used in conditional formatting and with other formulas.
=INDIRECT(CELL NO, A1 Style/ R1C1)
Cell No= Cell with cell Name.
A1 style= Normal cell referencing
R1C1= One we use in macro. R is row & C is column. Here R then row number , C then Column Number.
No comments:
Post a Comment