# Longer Custom Lists in Excel 2007

• Hello - I am trying to create a custom list in Excel 2007 by importing cells A1:A312. Unfortunately the custom list stops at row 102 and rows 103 and beyond are not included.

Is there a way to create a longer custom list than the 102?

Thank you for any help!

• Re: Longer Custom Lists in Excel 2007

That might be a limitation in 2007 (total characters in list not to exceed 255), according to a thread I just found: http://answers.microsoft.com/e…de-462f-b492-781ed9adf181. I can't test as I don't have 2007.

Does the number of cumulative characters in your list from topdown exceed 255 chars? If so, is it at about row 102 where the exceeding happens?

I tested it in my version of 2013 and it is not limited to 255.

Someone else with 2007 can test perhaps.

Where there is a will there are many ways. Finding one that works for you is the challenge!

• Re: Longer Custom Lists in Excel 2007

Thank you, NBVC. Yes, initially I'd tried to create it using a single cell and that was impossible as it reached the 255 limit about 13 rows in. Importing from the cells allowed me to go down to 102 rows but still stopped there. Curious.

• Re: Longer Custom Lists in Excel 2007

What is the cumulative count of characters at Row 101, then 102, and then 103? Maybe you have reached another limit.

Where there is a will there are many ways. Finding one that works for you is the challenge!

• Re: Longer Custom Lists in Excel 2007

At row 101 the cumulative length is 2077, at 102 it is 2099 and at 103 it is 2120. So perhaps 2100 is the limit...

• Re: Longer Custom Lists in Excel 2007

It's an odd number, but could be.

We would need to wait for someone with 2007 to test

Where there is a will there are many ways. Finding one that works for you is the challenge!

• Re: Longer Custom Lists in Excel 2007

in 2013, i was able to import a cumulative number of chars equal to about 1875 (maybe the commas between are counted in the final list too).

Where there is a will there are many ways. Finding one that works for you is the challenge!

• Re: Longer Custom Lists in Excel 2007

this is my limit:

Code
``````Sub M_snb()
c00 = Replace(String(400, ";"), ";", "##;##")
x2 = Len(c00)