Immediate Window

[Darchcruise]

Hi,

Whenever I run the code below in the module the msgbox returns a value, i.e 9 (signifying 9th row).

Sub test()
x = ActiveCell.Row
MsgBox x
End Sub


But whenever I use the immediate window (print x) or the watch window (x) nothing happens . In other words, it doesn't tell me a value (doesn't tell me what row I'm on). Can someone please explain? How can I make it work?

Thanks,
Jason

 

[Rick Rothstein]

The variable X only exists within the procedure you are using it in (good practice would have you Dim it inside there as well), so you cannot refer to X from outside the routine unless you have executed a breakpoint within your procedure (doing that would mean the procedure is still active). What you would do in the Immediate Window is simply...

MsgBox ActiveCell.Row

 

[Darchcruise]

Thank you

 

[ZVI]

If required the result can be saved in public variable:

' Put code in Module1
Public X

Sub Save_X_value()
  ' All local variables lives only while runtime
  ' But you can store result in public variable
  X = ActiveCell.Row
  Show_X_value
  ' After that press Ctrl-G to go in Immediate window
  ' type: ?X
  ' and press Enter to see X value
End Sub

Sub Show_X_value()
  MsgBox "TypeName(X)=" & TypeName(X) & vbLf & "X=" & X
End Sub