Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
array values type mismatch?
Hi,
I would appreciate help with the following. It's probably something simple but it doesn't make sense to me. This line gives me the error ActiveWorkbook.Worksheets("Sheet1").Cells(y + 1, x + 1).Value myarray(y, x) Variable uses an automation type not supported in visual basic. I get the same error when I trying to do msgbox myarray(y, x) & " " I think it has something to do with putting two different types together but I'm not too sure. thanks -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
other type values in array. | Excel Programming | |||
Variant Array with String Values - Type Mismatch | Excel Programming | |||
setting ctl to array of checkboxes yields type mismatch error. | Excel Programming | |||
setting ctl to array of checkboxes yields type mismatch error. | Excel Programming |