Dim rng as Range
set rng = Range(Activecell,ActiveCell.end(xldown))

rng.name = "Datarange"


or

set rng = ActiveCell.End(xldown)

or

set rng = Range("A1").End(xldown)

--
Regards,
Tom Ogilvy

"jos " wrote in message
...
to make a datarange variable in a macro, I need to put the command
"down" (cursor one or more steps down). I can not find the exact
command phrase.


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