Using Debug.Print with Range Variable with more than one cell
Thanks
"Jacob Skaria" wrote:
var1 = Range("A1:A10")
For Each strval In var1
Debug.Print strval
Next
--
If this post helps click Yes
---------------
Jacob Skaria
"ExcelMonkey" wrote:
I have a range variable. I want to print its value to the Immediate Window
upon selection of it.
Currently I use this to do so:
var1 = Target
Debug.Print var1
However this fails if the range is greater than one cell. How can I modify
this to print all values in the selection?
Thanks
EM
|