ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Editing code (https://www.excelbanter.com/excel-programming/286363-editing-code.html)

Todd Huttenswtine

Editing code
 
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

Dale Hymel

Editing code
 
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




Tim Zych[_4_]

Editing code
 
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




Harlan Grove

Editing code
 
"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




All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com