use something like this

Range("a1").End(xlDown).End(xlToRight)


rangerpooch wrote in message
...
In Excel. Using VBA to write code. I need help to name a range where the
upper left is known and the lower right varies