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

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

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

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

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.

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