|I am sorry I've upset you. I fully understand that you are giving your time freely here and I apologize that you feel I'm wasting it...that was not my intention. Regardless of whether or not you choose to reply further, I do appreciate your help. |
When I said that I needed one cell to be able to tell me when another cell is selected, that is exactly what I meant, and is still what I mean. In other words, I need a cell in column L to tell me when a cell in column A is selected. What I didn't say is that I need that functionality on one or more rows of the spreadsheet to allow for the flexibility I need. Therefore, regardless of how many cells are selected in column A, I need the corresponding cells in column L to reflect that with a 'Yes'. Otherwise the cells in column L should say 'No.
I had no way of knowing that the code would only work on the first cell of the selected range in column A. Having no knowledge of VB, I could only assume it worked similarly to the way Excel formulas work.
But to answer your question, I need to be able to select one date OR multiple dates in column A, and have the corresponding cells in column L reflect that with a 'Yes', otherwise they should say 'No'. Again...your code does everything I need, except it doesn't allow for multiple date selections, or for more than one consecutive date selections.
I think this covers covers it. Thanks!