Displaying the extent of a range variable

S

simonc

What is the easy way of displaying the range of cells which is assigned to a
range variable? This is for debugging purposes, and I just want a property of
the variable which I can display with debug.print which will show me which
cells are in the range.

Grateful for advice.
 
G

Gary''s Student

MsgBox (r.Parent.Name)
MsgBox (r.Address)

will display both the cells and the sheetname.
 
Top