J
Jeff Wright
Hi, folks
What I'm trying to do in the routine below is to copy the boolean values of
OptionButtons 1 through 50 to column A in another workbook. However, I'm
getting an error 424, "Object required". Any ideas on what's wrong with this
code? Also, do I need to dim i? If so, would the correct syntax be "Dim
i(50)" or "Dim i(50) as Integer"? I tried those statements, but then I get a
"Type Mismatch" error.
Thanks (again!!)
Slightly confused in Arizona,
Jeff
Sub test()
For i = 1 To 50
Workbooks("Jeff1.xls").Worksheets("Sheet1").OLEObjects("Optionbutton" &
i) _
.Object.Value.Copy Workbooks("Jeff2.xls").Worksheets("Sheet1").Cells(i,
1)
Next i
End Sub
What I'm trying to do in the routine below is to copy the boolean values of
OptionButtons 1 through 50 to column A in another workbook. However, I'm
getting an error 424, "Object required". Any ideas on what's wrong with this
code? Also, do I need to dim i? If so, would the correct syntax be "Dim
i(50)" or "Dim i(50) as Integer"? I tried those statements, but then I get a
"Type Mismatch" error.
Thanks (again!!)
Slightly confused in Arizona,
Jeff
Sub test()
For i = 1 To 50
Workbooks("Jeff1.xls").Worksheets("Sheet1").OLEObjects("Optionbutton" &
i) _
.Object.Value.Copy Workbooks("Jeff2.xls").Worksheets("Sheet1").Cells(i,
1)
Next i
End Sub