Index result too long?

**roasthawg** · 01-23-2012, 04:22 PM

I'm wondering if there is a limit on the size of a string returned by the "index" function? My function seems to work perfectly and then suddenly stops working once the string being returned gets too big... is there any way around this if this is indeed the problem?

**TMShucks** · 01-23-2012, 04:27 PM

Your guess is as good as anybody's unless you care to share the code and, ideally the workbook it runs in.

If there's sensitive data, you need to remove or generalise it before posting.

Regards, TMS

**roasthawg** · 01-23-2012, 04:32 PM

It's a macro and the workbook just has so much going on... was hoping to maybe get an answer to the question regarding whether or not there is a limit on the length of a string that can be returned by the "index" function?

**TMShucks** · 01-23-2012, 04:52 PM

Maybe try Googling for Excel Limits

http://office.microsoft.com/en-us/ex...005199291.aspx

Regards, TMS

**roasthawg** · 01-23-2012, 05:06 PM

Thanks for your help... there's definitely a 255 character limit. Gonna try finding a way around this... maybe by referencing the cell somehow rather than trying to return the value.

**TMShucks** · 01-23-2012, 05:12 PM

If you've got the cell address, I guess you could check the length of the data and use MID to extract blocks of data.

Regards, TMS

**martindwilson** · 01-23-2012, 06:58 PM

it doesnt limit with text see attached

**roasthawg** · 01-24-2012, 10:18 AM

Interesting that it doesn't limit with text. I was able to solve this one by using the "indirect" function and referencing the cell instead of using the "index" function to return a value. Thanks to both of you for the replies!

**OnErrorGoto0** · 01-24-2012, 10:21 AM

What were you trying to return that is over 255 characters long but isn't text?

**TMShucks** · 01-24-2012, 11:18 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save