Dynamic named range that expands "horizontally"

Hi,
I know how to create a dynamic range that expands vertically in the same column. But, my data starts at cell I5 and is arranged in one row, and I keep adding new data to the side.
I need to create a dynamic named range that expands horizontally.
I appreciate it if someone provided the formula. Thanks

Thanks Bernie Deitrick and martindwilson,

It seems solution 2 of Bernie Deitrick is the closest so far. However, it is still not performing at 100% due to the special circumstances that I have.
I have extra values before column I, but I also have extra values in additional tables to the far right after a column space.

Is it possible to end the dynamic range at first blank without further expansion to the dynamic range?

Currently, the desired dynamic range starts at I5 and ends at Q5. I have one blank column, and then another table starts.
When I add new records, I “insert” new columns in between (at column R), shifting all tables on the right and so on. I need the dynamic range to expand then stop at the first blank without expanding to the adjacent table. Is this possible?

I am attaching an example!!

Horizontal range.xlsx

Thanks martindwilson, it works perfect!!

just couple of follow up questions since I am also learning from this. Is it also possible to accompolish it by any or both the following methods:

- Can I replace I5 with named range? let us assume cell I5 called "Start_date" for example, what the formula would be?

- Another scenario: If the named range is defined at cell H4 instead; "COG_VAL"; how the formula would be changed to if I need to reference "COG_VAL" by offsetting from it?

Thanks a lot!

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.