Thread: Using Debug.Print with Range Variable with more than one cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
  
Posts: 553
Default Using Debug.Print with Range Variable with more than one cell
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
Reply With QuoteReply With Quote