View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jean-Yves[_2_] Jean-Yves[_2_] is offline
external usenet poster
 
Posts: 253
Default URGENT problem with Autofill in a macro

Hi Donna,

In the project explorer, make the debug toolbar visible and click the
immediate window icon (the one with an exclamation mark).
This is very handy to control exectution of your code, or to assign value to
variable which are not yet initialised.
To get info in the immediate window , use debug.print in your sub
(eg debug.print "Age variable value = " & myVarAge)
To ask value in debug mode, type directly in the immediate window : << ?
myVarAgeenter.
The ? is like debug.print in sub. You can also assign value by typing :
<<myVarAge= 18

Regards
Jean-Yves
wrote in message
ups.com...
This is a side question.This Debug.Print thing....where does it print?
I have tried before to use this and I can't find anything in any of my
open books. A simple thing I know but it's usually the simplest that
catch you out!
Donna