View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default variable not recognised in embedded macro

AFAIK, you may not embed a Sub within another one.

HTH
--
AP

"R..VENKATARAMAN" a écrit dans le message de
news: ...
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.