Jaslake,
I had to change my sheet and I don't know what I have to change in your code to make it work again, because now it doesn't :s
In fact, it no longer has to check one column, it has to check five columns.
Row 11 = always visible, value is fixed
Row 12 = always visible, is empty by default (user can input name or names in the range C12:G12
Row 13 = NOT visible, unless user has made an input in one (or more or all) of these cells: C12, D12, E12, F12 or G12
Row 14 = NOT visible, unless user has made an input in one (or more or all) of these cells: C13, D13, E13, F13 or G13
...
Row 21 = NOT visible, unless user has made an input in one (or more or all) of these cells: C20, D20, E20, F20 or G20
Row 22 = always visible, value is fixed
Same for all the other empty lines in the sheet.
I also have a VBA that stopped working when I copy pasted your code (the VBA code to 'UPPERCASE input user)
Hope you can help me once againI'll attach my sheet ...
I would be very thankfull
Grt
Kristof
Bookmarks