Need help sumif with variable for VBA

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

FAQ

Thread Tools

Display Modes

01-22-2014, 02:31 AM

jingo

Windows 7 32bit Need help sumif with variable for VBA

Office 2010 32bit

Novice

Join Date: Jan 2014

Posts: 1

Need help sumif with variable for VBA

i try to use use VBA as below but not work, can someone help me to fix it.
how we can use "</ >" with variable

numyear = Range("B3").Value
tillww = Range("D2").Value

ActiveCell.FormulaR1C1 = "=SUMIFS(C[-8],C[-4],RC[-1],C[-15]," & numyear & "C[-7], ""<= "" & tillww & ")"

Thank you

« Previous Thread | Next Thread »

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 10:14 PM.