Automated Naming of ranges...

  • Thread starter Thread starter gman
  • Start date Start date
G

gman

Hi,

Can someone suggest which of the do...loop
structures would work best for the following.

I have a big chunk of data that I need to automatically
name into same-sized ranges (i.e. 5 columns by 5000 rows
where i would want to name 100 ranges comprised of 5
columns by 50 rows.) Each range name is named after the
upper-left cell the first 50 lines.

Now given that there are some blank spaces in my table, i
was unable to automate a macro to go until it found a
blank space because it would end the range naming function
too early.

help...

thanks,

Gman
 
Well, if your cells are contiguous (i.e., an entire row
or column does not separate them) you can loop using the
CurrentRegion property of your data chunk (e.g., use the
total number of rows in the CurrentRegion to be you loop
limit).

Seth
 
Back
Top