Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mismatch error
When i try the following statement in a macro, i get an error 13, Type
mismatch. Could anyone solve this please ActiveSheet.Cells(j, colcount) = (data(j, i)) / 587 array data is declared as variant Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mismatch error
Hi
data should be an array e.g. Dim data(1 to 10, 1 to 10) as double Sometimes you need to pass arrays as variants (e.g. when trying to copy an array to a range on a worksheet). Then you would do Dim Variant_data as Variant Variant_data = data and you can access the numbers in Variant_data exactly as if it is an array. But you MUST create data as an array FIRST and then make your variant. regards Paul On May 11, 2:26 pm, Gautam wrote: When i try the following statement in a macro, i get an error 13, Type mismatch. Could anyone solve this please ActiveSheet.Cells(j, colcount) = (data(j, i)) / 587 array data is declared as variant Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mismatch error
the statement was not giving me an error. Tried a couple of ways of ways to
get errror 13. the only way I found of getting error 13 was to declare data as a string Dim data(10,10) as string. Check the declaration of the array data. "Gautam" wrote: When i try the following statement in a macro, i get an error 13, Type mismatch. Could anyone solve this please ActiveSheet.Cells(j, colcount) = (data(j, i)) / 587 array data is declared as variant Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mismatch error
Check your other post.
Gautam wrote: When i try the following statement in a macro, i get an error 13, Type mismatch. Could anyone solve this please ActiveSheet.Cells(j, colcount) = (data(j, i)) / 587 array data is declared as variant Thanks -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mismatch error
On May 11, 6:55 pm, Joel wrote:
the statement was not giving me an error. Tried a couple of ways of ways to get errror 13. the only way I found of getting error 13 was to declare data as a string Dim data(10,10) as string. Check the declaration of the array data. "Gautam" wrote: When i try the following statement in a macro, i get an error 13, Type mismatch. Could anyone solve this please ActiveSheet.Cells(j, colcount) = (data(j, i)) / 587 array data is declared as variant Thanks- Hide quoted text - - Show quoted text - Thanks Joel The first part of the array was indeed a string |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type mismatch error
On May 11, 6:47 pm, wrote:
Hi data should be an array e.g. Dim data(1 to 10, 1 to 10) as double Sometimes you need to pass arrays as variants (e.g. when trying to copy an array to a range on a worksheet). Then you would do Dim Variant_data as Variant Variant_data = data and you can access the numbers in Variant_data exactly as if it is an array. But you MUST create data as an array FIRST and then make your variant. regards Paul On May 11, 2:26 pm, Gautam wrote: When i try the following statement in a macro, i get an error 13, Type mismatch. Could anyone solve this please ActiveSheet.Cells(j, colcount) = (data(j, i)) / 587 array data is declared as variant Thanks- Hide quoted text - - Show quoted text - Thanks Paul The first part of the array was a string which popped an error the other part of the code is fine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Type Mismatch Error | Excel Discussion (Misc queries) | |||
Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming |