Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Why am I getting this error "Can't Assign To Array" for this code?
Dim myArray(0 To 5) As Single Dim Var as Single ERROR = myArray = Array(var1, var2, var3, var4, var5, var6) For Each Var In myArray Var = 0 Next Var but if I code it this way everything works: Dim myArray As Variant Dim Var as Variant ERROR = myArray = Array(var1, var2, var3, var4, var5, var6) For Each Var In myArray Var = 0 Next Var Any help would be great. -- Cheers, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Coverting single-value array into an ordinary variable | Excel Programming | |||
Sun IF two data types are the same in a single column | Excel Discussion (Misc queries) | |||
how do I make single character as a variable in an array | Excel Worksheet Functions | |||
assign objects into array or object variable? | Excel Programming | |||
VBA - Convert my variable range array to single cell string | Excel Programming |