Public Sub Test

'End Sub

<my existing code here
end sub

Above is a code that I would like to modify at run time.
I need for it to take the ' out of "'End Sub".

Thanks

Todd Huttenstine

A Sub only has one End Sub. The End Sub should be blue in color.

The ' before any text signifies a comment and changes the text that follows
the ' to the color green. These comments can be deleted.


"Todd Huttenswtine" wrote in message
...
Public Sub Test

'End Sub

my existing code here
end sub

Above is a code that I would like to modify at run time.
I need for it to take the ' out of "'End Sub".

Thanks

Todd Huttenstine

Unusual request. What are you trying to do?

"Todd Huttenswtine" wrote in message
...
Public Sub Test

'End Sub

<my existing code here
end sub

Above is a code that I would like to modify at run time.
I need for it to take the ' out of "'End Sub".

Thanks

Todd Huttenstine

"Todd Huttenswtine" wrote...
Public Sub Test

'End Sub

<my existing code here
end sub

Above is a code that I would like to modify at run time.
I need for it to take the ' out of "'End Sub".

It'd be much simpler, quicker and easier to maintain if you used something
like

Public Sub Test()
If SomeBailoutStateVarible Then Exit Sub
'your code here
End Sub