Call Not Working in Excel 97
 

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

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

Call Not Working in Excel 97
 

JulieD,
Thanks for your help. It turns out I did a sloppy job of declaring the
variables. Everything worked on version 8 after I made the corrections to
the Dim statements.

Thanks again,
Raul

"JulieD" wrote:

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