Can anyone see why this is generating a RunTime Error 91? Works perfectly as a formula (=F2-WEEKDAY(F2,2)+1)
It should check whether the date in F2 (.cells(2,6) is a Monday. If it is, that becomes STARTDAY. If it isn't, the code should find the previous Monday to the date and use THAT as STARTDAY.
All solutions, suggestions and alternatives welcome as ever
Please Login or Register to view this content.
Ochimus
I'm guessing STARTDAY should be an Integer.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Trevor,
Tried that and it now throws a "Run Time 6 error "Overflow"?
I'll have to "bodge" it for the moment, put the Formula in F3, which works, and use that as the STARTDAY.
NOT a Dry Blackrthorn week, this. Still struggling with the "erratic" percentage number in the Front Form and now this.
Ochimus
Try Long or Date rather than IntegerInteger will err if the date is later than 16 September 1989 (if you are using the normal 1900 system).
Last edited by WasWodge; 11-12-2019 at 05:07 AM. Reason: added "or Date"
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
Take note of the yellow banner
How about this one.
Please Login or Register to view this content.
Last edited by bakerman2; 11-12-2019 at 04:26 AM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks