Sub test()
Dim rngap As Range
For Each rngap In Sheets(1).Range(m5:q17)
rngap = False
Next
End Sub
On Thu, Nov 17, 2011 at 8:11 PM, John A. Smith johnasmit...@gmail.comwrote:
Your help is appreciated. I need a macro to uncheck all the check boxes
on the attached spreadsheet. User will
Perfect! Thank you Ashish. Thank you very much.
John
On Thu, Nov 17, 2011 at 9:45 AM, ashish koul koul.ash...@gmail.com wrote:
Sub test()
Dim rngap As Range
For Each rngap In Sheets(1).Range(m5:q17)
rngap = False
Next
End Sub
On Thu, Nov 17, 2011 at 8:11 PM, John A. Smith
Another way would be to use a single line without a for loop
Sheets(1).Range(M5:Q17).Value = False
Regards,
Sam Mathai Chacko
On Thu, Nov 17, 2011 at 8:22 PM, John A. Smith johnasmit...@gmail.comwrote:
Perfect! Thank you Ashish. Thank you very much.
John
On Thu, Nov 17, 2011 at 9:45 AM,
Thank you Sam, that is a clean approach. Appreciate the help.
John
On Thu, Nov 17, 2011 at 11:19 AM, Sam Mathai Chacko samde...@gmail.comwrote:
Another way would be to use a single line without a for loop
Sheets(1).Range(M5:Q17).Value = False
Regards,
Sam Mathai Chacko
On Thu, Nov 17,