WS1.OLEObjects("CheckBox" & _
varr(i) & k).
should resolve to
WS1.OLWObjects("CheckBoxboulderL1")
but it looks like you control is named CheckBoxBoulderL1
so change the words in the array so they will match your checkbox names.
(capitalize the first letter, as an example in this case).
--
Regards,
Tom Ogilvy
"Excel-erate2004 " wrote in
message ...
Tom,
I'm having trouble with this line of your suggested code:
If WS1.OLEObjects("CheckBox" & _
varr(i) & k).Value = False Then
and when I use the debugger the value of:
varr(i) = boulderL
K = 1
Value = False
I get a Run Time error '438' Object doesnt support this property or
method.
Any ideas? Thanks for all your help
---
Message posted from http://www.ExcelForum.com/