If you look at the arguements for OFFSET, you'll see that the last number
controls how many columns to return. (the previous controls length). For your
situation, I'd write:

=OFFSET(Sheet1!$C$1,0,0,MAX(COUNTA(Sheet1!$C:$C),C OUNTA(Sheet1!$D$D)),2)

The MAX function is there to determine which column (C or D) is controlling
the size of your range.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Robin" wrote:

I would like to create a dynamic range for multiple columns that are
attributed to the same name for a list. The reason for the dynamic range is
that I would like the user to be able to add to the list. If they had other
data that they would like to incorporate into the list.

I am able to make a list of mutliple columns for a single list and there
are multiple entries.

OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1) is the example they under
create a dynamic range what changes would need to be made to allow this to be
done for multiple columns

Say if the columns that I am interested in are c and d
I have tried the following formula and it does not seem to work. How does
the list appear when it automatically expands does the darkened border expand
around the list.

OFFSET(Sheet1!$C$1,0,0,COUNTA(Sheet1!$C:$D),1)