Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
Why can't i use this: Dim num, num2, num3 as single ? Shall i use this: Dim num as single, num2 as single, num3 as single?????????? regards alvin |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Alvin,
The declaration Dim num, num2, num3 as single ? is equvalent to: Dim num As Variant Dim num2 As Variant Dim num3 As Single --- Regards, Norman "alvin Kuiper" wrote in message ... Hi Why can't i use this: Dim num, num2, num3 as single ? Shall i use this: Dim num as single, num2 as single, num3 as single?????????? regards alvin |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can use it if you wish, but it is just declares num1 and num2 as variant
types, not single. If you need them all as single, then do it as per your second example. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "alvin Kuiper" wrote in message ... Hi Why can't i use this: Dim num, num2, num3 as single ? Shall i use this: Dim num as single, num2 as single, num3 as single?????????? regards alvin |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks
Alvin "Bob Phillips" wrote: You can use it if you wish, but it is just declares num1 and num2 as variant types, not single. If you need them all as single, then do it as per your second example. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "alvin Kuiper" wrote in message ... Hi Why can't i use this: Dim num, num2, num3 as single ? Shall i use this: Dim num as single, num2 as single, num3 as single?????????? regards alvin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Runtime Error '91' Object variable or With block variable not set | Excel Discussion (Misc queries) | |||
Run-time Error'91: Object variable or With block variable not set | Excel Programming | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Run-time error '91': "Object variable or With block variable not set | Excel Programming | |||
Cells.Find error Object variable or With block variable not set | Excel Programming |