to Mr. Mehta
thank you.

probably it is my mistake that I did not make myself clear. "embedded" is
wrong word. I am calling another macro in the main macro
I am giving a trivial example

Public Sub test()
Dim symbol
symbol = InputBox("type the symbol")
testone
End Sub

Public Sub testone()
MsgBox symbol
End Sub

msgbox is blank

what mistake am I doing?


"Tushar Mehta" <tm_200310@tushar_hyphen_mehta_dot_see_oh_em wrote in
message om...
No, unfortunately, you have not made yourself clear. It is not possible
to have one sub inside another. So, if your code is working, it is not
organized that way.

Maybe, you should share the actual code you are using. Copy & paste it
from the VBE to whatever program you use to post to the newsgroup.


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article , venkat1926
@touchtelindia.net says...
I have a main macro in whcih there is a variable "symbol"
"symbol" is derived from an inputbox
during the step by step running of the main macro if I type in the
immediate window
?symbol
it gives correct answer
there is another macro embeeded in the main macro at the end (before end
sub)
After the last codestatement of main macro the macro moves to the second
macro. once the step runs into the second macro if I type in the
immdediate
window
?symbol
it gives blank
that means when the cursor moves into the second macro the variable
"symbol"
is not recognised.
where do I do the mistake.

I hope I have made myself clear.