Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Need help editing this code | Excel Discussion (Misc queries) | |||
Recalculation Speed After Editing Macro Code | Excel Programming | |||
Protect macro code from viewing/editing | Excel Programming | |||
Code Editing Code | Excel Programming |