VB Code for clearing Cells

[Guest]

I need help clearing a range of cells using vb code in place of a long drawn
out macro.

My cell range is D11 to D22

In these cells I have a TRUE/FALSE attached to a tick box.

When I press the button to move to the sheet I would like these cells to say
FALSE and remove any ticks.

Can anyone help.

 

[Dave Peterson]

I would think this would work:

ActiveSheet.Range("d11:d22").Value = False

 

[Guest]

Thanks Dave

I would think this would work:

ActiveSheet.Range("d11:d22").Value = False