View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Excel-erate2004[_25_] Excel-erate2004[_25_] is offline
external usenet poster
 
Posts: 1
Default Method 'Range' of Object_Worksheet Failed

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/