LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Type Mismatch [email protected] Excel Worksheet Functions 1 May 16th 07 03:29 PM
Type Mismatch Brad Excel Programming 2 May 2nd 05 04:49 PM
Type Mismatch teresa Excel Programming 10 December 28th 04 10:14 PM
Type Mismatch Jack Schitt Excel Programming 2 September 3rd 04 11:55 AM
Type mismatch Stuart[_5_] Excel Programming 4 February 19th 04 07:54 PM


All times are GMT +1. The time now is 10:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"