intersect question

[glda19]

I've made a calendar With a lot of other things on it.

Now i made for every month a range that contains only the weekdays.
And check if the user selection is different of the weekdayrang . When he is bigger i say selection contanins a weekend day.

A friend told me that it was posible to dedect with intersect that the user selection contains weekend day's. But i don't know how ?

Must i change the range of the moth include with the weekenddayS ?
Thangs for the help so far

[JLGWhiz]

If your month of weekdays is on row 5 from column 1 to column 21 then using VBA

Please Login or Register  to view this content.

But your layout has the days on multiple row with different beginning and ending columns so the Intersect function could not be applied to an entire month of weekdays. If you had blocks of data where the beginning cell was in the same column as the following weeks and the ending cell was in the same column as the preceeding weeks, like a 4 row by five column matrix and all were weekdays, then you could use the Intersect function on the entire block like

Please Login or Register  to view this content.

The Intersect function does just that, it returns true if the target cell or cells intersect the parameters in the arguments.

[glda19]

It is not about the activecell but off a selection of cells

[glda19]

what did you mean with not the same begin and end cell

[JLGWhiz]

I thought the 5 by 4 matrix would explain what I I meant. If you want to use Intersect function to find if a user selects a cell within your calendar weekdays, you have to be able to define a range that includes only those days. So when your month begins in Column D and Ends in column F, there is not a equilateral matrix, So, although you could define a rang to cover all the days, it would have to include cells that precede the first of the month and cells that follow the last of the month. So it leaves the Intersect function subject to fictitious returns. If you can imaginge drawing a vertical line through a rows of data in a range on your sheet, every time the line passes through a row it is an intersect with that row, If your line is more than one column wide, then there will be a multiple cell intersect for each row the line crosses. I only used the active cell as an example of how to return whether there is an intersect or not. The function is a powerful VBA function and can be used in other ways. It can be used to return values, define a range of cells out of a larger range of cells and more. You can do a web search for a tutorial on using the VBA intersect function if you want more details.

but, again, I don't see a practical way to use it on your calendar layout. Maybe someone else can.

[glda19]

when i use the range b5:h10 and the user make a selection how can check if it's contain weekend days.

[JLGWhiz]

on your calendar, columns G:H and P:Q are not weekdays, which means that B:F and K:O are weekdays, but might include holidays. Nonetheless, you can use the intersect method like this

Please Login or Register  to view this content.

The problem is that if the user has selected a cell in those ranges that is not on one of your calendar pages, it will still indicate a weekday. You have a lot of gaps on the sheet between months. You can use the narrower range of B5:F10, but it would still leave 2 cells subject to invalid return. If you want to go to the trouble of locking all cells except the calendar days, then you could use the code above with a high degree of confidence, because the user would be blocked from selecting anything except a calendar day.