To give A1:U2 the name Name_1

Range("A1").Resize(2,21).Name = "Name_1"

You have given no information on determining how many rows a range might
have or how the name would be determined.

--
Regards,
Tom Ogilvy

"Ocicat" wrote in message
...
I need an Excel macro to name ranges. The ranges always start in column A
and end in column U. The problem is that the ranges aren't the same
number
of rows. The names are based on numbers such as _1, _2 etc. They often
are
more than 900 ranges.