Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub parameter passing
Is this the proper way to pass a varible parameter to and back from
subroutines? My code seems a little sloppy, I would think that I'm missing some delclaration The subroutine "Orig_WS_name" is call with the following statement: Call Sub Orig_WS_name("orig_name") Private Sub Orig_WS_name(WSIn As String) 'WSIn has the value of "orig_name") prior to call Call Add_WSname_Chars(WSIn) 'WSIn has the value of "orig_name-textadded") after call End Sub Private Sub Add_WSname_Chars(WS_name As String) WS_name = WS_name & "-txt added" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a function as a parameter | Excel Programming | |||
Passing chartobject as a parameter to sub | Excel Programming | |||
?Passing argument/parameter | Excel Programming | |||
?Passing argument/parameter | Excel Programming | |||
Passing a parameter to Excel | Excel Programming |