VB Code for clearing Cells

R

Rich

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.
 
D

Dave Peterson

I would think this would work:

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