Thank you Sam, that is a clean approach. Appreciate the help.
John
On Thu, Nov 17, 2011 at 11:19 AM, Sam Mathai Chacko wrote:
> 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
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 wrote:
> Perfect! Thank you Ashish. Thank you very much.
>
> John
>
> On Thu, Nov 17, 2011 at 9:45 AM, ashish koul wrot
Perfect! Thank you Ashish. Thank you very much.
John
On Thu, Nov 17, 2011 at 9:45 AM, ashish koul 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 wrote:
>
>> Your he
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 wrote:
> Your help is appreciated. I need a macro to uncheck all the check boxes
> on the attached spreadsheet. User will answer an unspecified
