View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default Call Not Working in Excel 97

Hi Raul

when you put a breakpoint (click on the line & press F9) on the call
routine03 line and step through the code does it in fact go to sub routine03
or what?

Cheers
JulieD

"Raul" wrote in message
...
I've got a routine that works in Excel version 10 but does not in Excel
version 9. The glitch is apparently in a call statement I'm making. What
I'm
using looks like...

Sub Routine02 ()
Dim stuff as whatever
Get stuff
Call Routine03(ThisSheet, RNumRows, RFirstRowNum, LastRowNum,RFirstColNum,
RNumCol, OutputRow, OutputCol)
End Sub

Sub Routine03 (ThisSheet, RNumRows, RFirstRowNum,
RLastRowNum,RFirstColNum,
RNumCol, OutputRow, OutputCol)

Do stuff
End Sub

Obviously version 10 is more forgiving of sloppy programming. Can anyone
tell me what I'm doing incorrectly?

Thanks in advance,
Raul