Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto...Return question
Hi,
Here's part of my code: Function doProcess(input as string) as integer '(...code here) Goto CleanUp '(...code here) Exit Function CleanUp: '(...code here) if flag = true then Return 'here I need to resume the 'function after the "Goto CleanUp" line end if '(...code here) End Function Here's the problem: The "Return" line doesn't work. What do I need to write instead? I'm using Goto because that part of the code is used many many times in that function and I cannot rewrite it as another function. Thanks MouseTrap |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto...Return question
Change Goto Cleanup to GoSub Cleanup ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto...Return question
Instead of "Return", use "Resume Next".
-- Vasant "mousetrap" wrote in message ... Hi, Here's part of my code: Function doProcess(input as string) as integer '(...code here) Goto CleanUp '(...code here) Exit Function CleanUp: '(...code here) if flag = true then Return 'here I need to resume the 'function after the "Goto CleanUp" line end if '(...code here) End Function Here's the problem: The "Return" line doesn't work. What do I need to write instead? I'm using Goto because that part of the code is used many many times in that function and I cannot rewrite it as another function. Thanks MouseTrap |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto...Return question
In article ,
"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote: Instead of "Return", use "Resume Next". -- I already tried that. I get an error: Resume without error. MouseTrap |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto...Return question
In article ,
mudraker wrote: Change Goto Cleanup to GoSub Cleanup I thought that GoSub worked only in a Sub and not in a function. However, I tried it and it worked. Thanks. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto...Return question
My mistake ... I thought Cleanup was your error handler, but obviously it is
not! -- Vasant "mousetrap" wrote in message ... In article , "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote: Instead of "Return", use "Resume Next". -- I already tried that. I get an error: Resume without error. MouseTrap |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on "On Error GoTo skip" | Excel Discussion (Misc queries) | |||
goto (F5) question | Excel Discussion (Misc queries) | |||
Validation Data & Goto question | Excel Discussion (Misc queries) | |||
VBA rookie question - listbox and GOTO | Excel Programming | |||
Question: OPEN return status | Excel Programming |