Hi
that is what i have now
For the workingdays
The month january have Range("B5:F10")
the month February have range ("B12:F17")
And the same for the weekend
january Weekend = Range("G5:H10")
Set february Weekend = Range("g12:H17")
Now i do it so
Can i do the same with a array for the working days and one for the weekens and do a intersection with a cell that the user have selected
Please Login or Register to view this content.
Last edited by glda19; 10-08-2019 at 04:59 PM.
Hello glda19,
The Application.Intersect function only works with Range objects, not arrays.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
So i have to leave it like it is.
Ore im wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks