Hi
try
sub foo()
Dim rng as range
set rng = activecell
msgbox rng.value
end sub

--
Regards
Frank Kabel
Frankfurt, Germany

I'm looking for a way to refer to a range with a variable. Let me
demonstrate.

Dim MyVar
MyVar = ActiveCell.Value
Range("A14").Select

I've tried this:

Dim MyVar
MyVar = ActiveCell.Value
Range("A(MyVar)").Select

But (of course) it doesn't work; however this is essentially what I
need.

How can I make this happen?


---
Message posted from http://www.ExcelForum.com/