Solved: Dimming Intergers and Doubles

[petedw]

Is there a way to Dim something as a integer and then use that along side something else and Dim it as a double.

For example;

Dim iNum As Integer
iNum = 1

Dim reading(iNum) As Double

I know this doesn't work, but is there any way of getting it to? How do i re-write the code??

Many Thanks

Pete

[TonyJollans]

Hi Pete,

Not quite sure what you're trying to achieve here.

An array of doubles might do the trick (if you have a consecutive series of inums ...[vba]Dim iNum as integer
dim reading(1 to 20) as double ' perhaps
iNum = 1
readng(inum) = 123456789[/vba]

Or, perhaps a user-defined type[vba]Type PeteStuff
iNum As Integer
Reading As Double
End Type
Sub Something()
Dim Stuff As PeteStuff
Stuff.iNum = 1
Stuff.Reading = 123456789
' rest of code
End Sub[/vba]

[petedw]

Cheers Tony, i'll give that a go