Need help sumif with variable for VBA

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Need help sumif with variable for VBA

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-22-2014, 04:52 PM

macropod

Windows 7 32bit Need help sumif with variable for VBA

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

Three questions:
1. What is the actual formula you're trying to generate (in A1 notation)?;
2. Why are you using R1C1 notation?
3. Why are you referencing ActiveCell rather than specifying a cell address?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Average if and sumif	jennamae	Excel	4	01-17-2014 05:10 AM
object variable or with block variable not set	MJP143	Excel	1	02-11-2013 05:07 AM
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
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 01:41 PM.