Excel macro to name ranges.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top