Here's Print Using Mismatch error

[Kernelpanic]

Code: (Select All)

Print Using "In the year ####, & was ## years old."; 1973, "Steve", 0

Just like the above, which is a little more obvious when tossed into a sentence like so, for us. 

The comma is wrong here. 

Code: (Select All)

Print Using "In the year #### & was ## years old."; 1973, "Steve", 0 

[Kernelpanic]

One can also "Print Using" separate.

Code: (Select All)

Option _Explicit



Dim As Integer i

Dim As Double salary



Randomize Timer

For i = 1 To 12

  Print Using "& ##"; "Month"; i;

  salary = (Rnd * 500) + 2800

  Print " : "; Using "###,#.##"; salary

Next i



End

[PhilOfPerth]

@SMcNeill: I can't find any reference to the freq() that you used anywhere, but it doesn't error out - what is it, and what does it do? 

[SMcNeill]

@SMcNeill: I can't find any reference to the freq() that you used anywhere, but it doesn't error out - what is it, and what does it do? 

No idea.  It was part of Dimster's original code.  If I had to guess, I'd bet on it being a function or array used elsewhere in his code and which just kinda got copied/pasted over with what he was questioning over.  

[PhilOfPerth]

Yep, that sounds reasonable. Thanks.

[Dimster]

Hi Phil.  ya, freq() is an array. I'm trying to design a distribution chart. freq() is intended to hold the frequency of multiple event occurrences.