|
Posted to microsoft.public.excel.misc
|
|
|
VB Code for clearing Cells
Thanks Dave
"Dave Peterson" wrote:
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
|