Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Tom
If xyz is a variable you might just change its value to something else while calling the second macro. For example: Sub Macro1() Dim abc As String abc = "Hello world!" Call Macro2(abc) End Sub Sub Macro2(ByVal xyz As String) MsgBox xyz End Sub -- Best regards Robert, Excel MVP Author of RibbonX: Customizing the Office 2007 Ribbon: Find me at http://www.msofficegurus.com - be part of it! FORUM: http://www.msofficegurus.com/forum/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help editing a macro | Excel Discussion (Misc queries) | |||
Editing a macro | Excel Discussion (Misc queries) | |||
Editing a macro | Excel Discussion (Misc queries) | |||
Editing a Macro | Excel Discussion (Misc queries) | |||
Editing Macro | Excel Discussion (Misc queries) |