LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 41
Default variable not recognised in embedded macro

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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
My first macro - doesnt work - function not recognised James Cornthwaite Excel Worksheet Functions 2 May 14th 06 05:13 PM
Create an external reference link with embedded variable Greentree Excel Worksheet Functions 1 October 9th 05 07:46 PM
Variable Chart Width (Embedded) Joel Mills Excel Programming 1 November 10th 04 06:29 PM
Can a variable workbook be embedded into an Excel funtion? Tom Ogilvy Excel Programming 1 August 11th 03 08:38 PM
Can a variable workbook be embedded into an Excel funtion? steve Excel Programming 0 August 11th 03 07:52 PM


All times are GMT +1. The time now is 06:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"