Check for each cell in range if is it empty when user click to some cells

**cronet** · 12-25-2012, 01:55 PM

Hello,

First of all sorry for my poor english :-)

So i have in my excel sheet 3 column :

A B C where B is a date of mounth so if user whant change a cell in C3 and if cell B3 i want show message and select another cell and son for cell C4 et B4
1
2
3

So i make this function which works great BUT there is a bug, in fact user can not change cell B4 even if C4 is not empty

Please Login or Register  to view this content.

So this is my function i thin problem come from "Set myRange = ActiveSheet.Range("B7:B12")"

beacuse if all cells from this range must not be empty if user can write in range E7:E13

Could please someone help me with this code, thank you very much

Onother question is if i want add more range to check like A12:A25, A50:A60 and so on how can i do please.

**Tsjallie** · 01-01-2013, 04:35 PM

Not at all sure what you are trying to achieve, but maybe this user teasing long shot is somewhat in the direction you're looking at.
Code is in the selection_change procedure of Sheet1.