Microsoft Office Forums - View Single Post - Variable for Date not working

Thread: Variable for Date not working

View Single Post

Old

04-05-2018, 09:12 AM

Divinedar

Divinedar is offline

Divinedar uses Windows 7 64bit

Windows 7 64bit Divinedar uses Office 2010 64bit

Divinedar uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Jun 2016

Posts: 21

Divinedar is on a distinguished road

Default

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).

Reply With Quote