View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mcmanusb mcmanusb is offline
external usenet poster
 
Posts: 6
Default named dynamic range that ends with first text entry

I've found many example on how to created a dynamic named range which ends at
the last numeric or text entry. I would like to create one that ends at the
first text entry.

The data I'm workign with has a heading, then numeric data, then another
heading, then more numeric data. I only need the numeric data between the
first heading and the second, and the amount of rows between frequently
changes.

Is this possible?

Thank you, super-geniuses.