Where R1C1 addresses was used?
Was there some other spreadsheet which used such addressing? Why such bizarre convention was defined?
|
Where R1C1 addresses was used?
"st" wrote in message
... Was there some other spreadsheet which used such addressing? Why such bizarre convention was defined? AFAIK ALL spreadsheets use that convention. What else would they use? |
Where R1C1 addresses was used?
Multiplan (Excel's predecessor) used only R1C1 style references.
It's not bizarre at all; it's just that you're probably used to A1 style. Refencing the row above, for example, is easy and understandable; R[-1] and the same in any row. I still use it a lot, but never for work I have to share with others, because it seems to confuse some........... -- Kind regards, Niek Otten Microsoft MVP - Excel "st" wrote in message ... Was there some other spreadsheet which used such addressing? Why such bizarre convention was defined? |
Where R1C1 addresses was used?
"Niek Otten" wrote in message ... I still use it a lot, but never for work I have to share with others, because it seems to confuse some........... What do you expect from a bizarre convention? <bg |
Where R1C1 addresses was used?
R1C1 reference style can be very useful.
You can write a formula to sum from row 2 to the row above with an R1C1 formula like: =sum(r2c:r[-1]c) It would be a pain to toggle the setting, write the formula, then toggle the setting, though. But if you're writing a macro that does the same thing, the code is easier: dim myCell as range set mycell = somevariablerangehere mycell.formular1c1 = "=sum(r2c:r[-1]c)" And if you're looking for inconsistent formulas, you can toggle this setting (and widen the columns), show formulas, and almost use the naked eye to find any formulas that don't belong. (or use code to look at .formular1c1 to see if it matches the one above.) st wrote: Was there some other spreadsheet which used such addressing? Why such bizarre convention was defined? -- Dave Peterson |
All times are GMT +1. The time now is 04:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com