Hello,

This is my first post.

I need some help with a named range and how to make it dynamic.
I have a series of data in column B and I need the range to capture it all. The problem is, the data series starts on a different row each time. So, sometimes the data will be in rows 25 to 100, another time it will be rows 34 to 75.
I know I can use offset to count down to the last used row, but for the life of me I can't figure out how to make the range figure out where the range starts (i.e. The first used row).

Does anyone have any ideas? It seems like there's a wealth of stuff on line about finding the last used cell in a column, but not the first used cell.

Any help would be greatly appreciated.

Thanks.