Variable for Date not working

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Variable for Date not working

FAQ

Thread Tools

Display Modes

04-05-2018, 09:12 AM

Divinedar

Windows 7 64bit Variable for Date not working

Office 2010 64bit

Novice

Join Date: Jun 2016

Posts: 21

I really believe that my problem is here "If sht.Cells(i, 2) = strField Then " because if I run error checking I get a #VALUE! I get an error ""=(IF(ISBLANK(RC1),0,(IF(ISBLANK(R1C),0,prjbymonth(RC1,R1C)))))"" here (red text color).

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable	shimulsiddiquee	Excel	1	05-16-2017 07:39 AM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
Run-time error 91 object variable or with block variable not set	JUST ME	Word VBA	4	03-25-2014 06:56 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM
30+ days Variable Day Date Calculations via Fields	ztag	Word	2	01-06-2012 11:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:23 AM.