Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 01-23-2014, 11:02 AM
BobBridges's Avatar
BobBridges BobBridges is offline Need help sumif with variable for VBA Windows 7 64bit Need help sumif with variable for VBA Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Actually, I agree with you for the purpose of ordinary Excel formulae. It's only because I do so much with VBA that I use R1C1 most of the time; for programming, it's much easier to think in.

It does have one other advantage. When we're talking about formulae on this forum, A1 notation requires one to explain the context when using relative references. That is, if I say the formula should be =SUM(C$2:C45), I have to explain as an aside that this is correct only when entered in C46. But in R1C1 I can just say =SUM(R2C:R[-1]C) and the location doesn't matter.

But, alas!, most people don't know R1C1 so it wouldn't be helpful to use it no matter how much clearer it is.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help sumif with variable for VBA Average if and sumif jennamae Excel 4 01-17-2014 05:10 AM
Need help sumif with variable for VBA object variable or with block variable not set MJP143 Excel 1 02-11-2013 05:07 AM
Need help sumif with variable for VBA Run-time error '91': Object variable or With block variable not set tinfanide Excel Programming 2 06-10-2012 10:17 AM
Help! 'SUMIF' Formulas dave1372 Excel 2 09-08-2011 07:05 AM
Need help sumif with variable for VBA Multiple criteria in SUMIF? pumpkin head Excel 1 02-17-2006 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft