I would think this would work:

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



Rich wrote:

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