Hi - finally onto my last four lines of code so this should be my last question for a while
How do I use > with dates in a sumif worksheet function? I have the code below but it throws up a 1004 error - . Offset value is a date, .value in the bottom line is a 6 digit number
Please Login or Register to view this content.
David
The error might not actually be caused by using ">" or dates, it could be something else.
For example this is wrong,
If you want to refer to column 11 on the worksheet PBR you would use this.Please Login or Register to view this content.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Thanks - thats it. How come on everything else where I use ranges I have to say its a range of columns?
Not sure what you mean, Range(Columns(..)) would be wrong wherever you used it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks