ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   a similar convention for tabs/wksts as in for R[1]C[1]? (https://www.excelbanter.com/excel-discussion-misc-queries/41914-similar-convention-tabs-wksts-r%5B1%5Dc%5B1%5D.html)

JimTobin2

a similar convention for tabs/wksts as in for R[1]C[1]?
 
Is there a way to refer to tabs/worksheets in an equation in a similar
convetion as R[1]C[1]?

Dave O

You can toggle between reference styles by clicking Tools Options,
and on the General tab select or deselect the box for R1C1 reference
style.



All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com