Highest Rated Comments
beyphy10 karma
A flight takes 55 minutes (with driving, airport times, etc, it typically takes me 2h 30m door-to-door) and I usually pay $65 for tickets.
The $65 dollar rate isn't typical from what I can see. A quick search on Google for flights between LA to SF shows that prices range from anywhere between ~$100 - ~$250. I might consider taking a train vs a $100 plane ride if it would save me a bit, would be more comfortable, and I wasn't in a hurry. And my willingness to do that would increase as plane tickets became more expensive.
beyphy9 karma
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 karma
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 karma
They're putting their efforts in the JavaScript API. Look into ScriptLab. It's a much better development experience than VBE. And JavaScript / typescript offer many of the features you mentioned above. (Fwiw, I'm also employed as a VBA developer)
beyphy358 karma
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