Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call Application.Volatile(True) NOT WORKING | Excel Discussion (Misc queries) | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
Call other application from excel | Excel Programming | |||
COM-call-in to Excel | Excel Programming | |||
Macro working in Excel 2003; not working in Excel 2000 | Excel Programming |