Error 450

E

ExcelMonkey

I just tried the following and recieved an Error 450:

ChkbxArray(0, 4) = ActiveSheet.Comments
ChkbxArray(1, 4) = ActiveSheet.UsedRange
ChkbxArray(2, 4) = ActiveSheet.UsedRange
ChkbxArray(3, 4) = ActiveSheet.UsedRange
ChkbxArray(4, 4) = ActiveSheet.UsedRange
ChkbxArray(5, 4) = ActiveSheet.UsedRange

Should I have used quotes for this to work properly?

Thanks
 
E

ExcelMonkey

Oops should have had:

Set ChkbxArray(0, 4) = ActiveSheet.Comments
Set ChkbxArray(1, 4) = ActiveSheet.UsedRange
Set ChkbxArray(2, 4) = ActiveSheet.UsedRange
Set ChkbxArray(3, 4) = ActiveSheet.UsedRange
Set ChkbxArray(4, 4) = ActiveSheet.UsedRange
Set ChkbxArray(5, 4) = ActiveSheet.UsedRange
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum not working on Array 1
Problems Defining Object Variable in For Each Loop 7
Empty Array 4
array data type issues - 11
Select only columns 2
multiple sheets 7
Automatically hide rows with 0 value....faster? 5
Performing a Macro within a range 2

Top