Thread: type mismatch
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Donnie Fuqua Donnie  Fuqua is offline
external usenet poster
 
Posts: 1
Default type mismatch

Can someone tell me, off the top of their head, why line 4 throws a type
mismatch error?
Note that the line numbers did not appear in the actual program code. Any
help is much
appreciated.

1 Dim sngValue As Single
2 For lngPattern = 1 To lngPatterns
3 For lngInput = 1 To lngInputs
4 sngValue = CSng(rngInputs.Offset(CVar(lngPattern - 1),
CVar(lngInput - 1)).Value)
5 FNet.SetInput lngPattern - 1, lngInput - 1, sngValue
6 Next lngInput
7 For lngOutput = 1 To lngOutputs
8 sngValue = CSng(rngOutputs.Offset(CVar(lngPattern - 1),
CVar(lngOutput - 1)).Value)
9 FNet.SetOutput lngPattern - 1, lngOutput - 1, sngValue
10 Next lngOutput
11 Next lngPattern

Donnie Fuqua