How to get past Excel's limit of 255 characters with ActiveSheet.Range().Select

[gte]

I have added individual cells to a textbox as MS recommends, but when I try the code below with tbxLongString holding a 565 character string in it, the function still fails?

https://support.microsoft.com/en-us/kb/213841

What am I doing wrong?

ActiveSheet.Range("tbxLongString").Select

[jayherring86]

Hello,

So as i understand it, your tbxLongString is longer than the maximum allowed, at 565 characters and this is preventing you from passing it into a range.select statement?

Firstly, to select the range you should just have to do: tbxlongstring.select, when i try to select a range object using the range().select i get an error.

** Edit: I just realised that tbxLongString is probably a string at the moment. You would need to convert it to a range, and THEN say ThatRange.select

Without knowing what your actual string is, I couldn't even begin to offer help on how to convert it **

[TMS]

If tbxLongString is defined (Dimmed) as a String, or is the value in a Text Box, (that is, string text) then this:

Please Login or Register  to view this content.

should probably be this:

Please Login or Register  to view this content.

[shg]

Do you just want a function that returns a range for a long range string?

[shg]

The forum isn't cooperating. The attachment contains a demo procedure that creates a 5,000-character range string listing 1300 non-contiguous cells, and the FastUnion function returns a range.