Hi, I've got a big problem in Excell and I'd like to solve it with a VBA macro. This is what I have to do:
Imagine that in cell A20 I've got the formula =SUM(A1:10). As you can there some cells (from cell A11 to cell A19) that are selected. If I am in this situation I'de like to have a message that say me: "Hey man, you have not selected ALL the cells before A20". Viceversa if I've selected all the cells before A20 I don't want any message.
Is it possible to do something like that?
My english is not very good, so I hope you've understood my problem.
Imagine that in cell A20 I've got the formula =SUM(A1:10). As you can there some cells (from cell A11 to cell A19) that are selected. If I am in this situation I'de like to have a message that say me: "Hey man, you have not selected ALL the cells before A20". Viceversa if I've selected all the cells before A20 I don't want any message.
Is it possible to do something like that?
My english is not very good, so I hope you've understood my problem.