Hello
This is my problem:
beeing in a sheet, user can choose in a cell between a list of value (I used the option "data validation") - What I'd like to do, is that based on the selection from the user, I can "clear" some sections of my sheet ..

So, in the Private Sub Worksheet_Change(ByVal Target As Range)
function of my sheet, I have the following instruction :

thisSheet.Range(Cells(target.Row, 7), Cells(target.Row, 16)).ClearContents
(that is : clear cell from column 7 to 16 for the row = target.Row)

The problem is that I get a loop : since each time a cell is zeroed, the Worksheet_change function is invoked and it restart again ..

Is anyway to avoid the loop?


thanks
*pimar