Dim rng as Range
set rng = Range("A1").CurrentRegion

' if you want a defined name

rng.Name = "MyName"

msgbox Range("MyName").Address(external:=true)

post back with a clearer explanation of your situation if these don't help.

--
Regards,
Tom Ogilvy


"Chris Parker" wrote in message
om...
I want to define a range on the fly in VBA. The range is dynamic and
constantly changes . I know how to select this but I'm having problems
defining the range.

Can anyone assist ?

Thanks in anticipation.