beyphy358 karma2017-10-18 16:34:04 UTC
Do you guys have a preference internally between A1 and R1C1?
Also, what new features are you most excited to introduce into Excel that you're able to talk about?
View HistoryShare Link
beyphy9 karma2017-10-18 16:52:05 UTC
Yeah, same here. The only advantage I could see for using R1C1 is when using it is when writing a formula across many cells with different ranges in VBA. Something like "range("C1:C1000").formla = "=sum(RC[-2]:RC[-1]"" or something like that
beyphy7 karma2017-10-18 16:40:00 UTC
Ah I see. I meant when you have to write a worksheet formula, or a formula in VBA, do you have a preference between A1 and R1C1?
beyphy7 karma2020-02-12 18:15:31 UTC
beyphy3 karma2018-11-06 19:00:33 UTC
I’ve recently started using ScriptLab and have been very impressed with the user interface. It looks miles ahead of something like VBE. Can we expect something like this to get integrated more tightly into Excel at some point in the future? i.e. not requiring an add-in or an internet connection
Copyright © 2014 BestofAMA.com, All rights reserved.
reddit has not approved or endorsed BestofAMA, reddit design elements are trademarks of reddit inc.