VBA Code Error

[adamheon]

i'm getting an error in the following code. It works fine until i enter 1 of the 2 last ranges (H159:Z159 and/or H170:Z170) not sure why?

Please Login or Register  to view this content.

[AB33]

From my vague memory there is a limit of 255 characters

Please Login or Register  to view this content.

[MarvinP]

Hi Adam,

My guess is that the text string starting with "H12:..." is longer that 256 characters, but I may be wrong.
Read
http://support.microsoft.com/default...b;en-us;177991
for more limits.

[adamheon]

Yeah i believe you're right. How would i continue this string on a new line?

[AB33]

Hi Marvin,
That is also my thoughts, except my number is wrong(Should be 256).
I also think that
H12:Z12 -multi selection may also show an error.

[MarvinP]

Hi Adam, Try this...

Dim MyString as String

MyString = "Stuff"
MyString = MyString & "More Stuff"

Then in your Range("H12:......") put Range(MyString)

See if that works for you...

@AB33, I couldn't find an answer for us about 255 or 256 on the net.

[Izandol]

It is 255 I believe. I will suggest using Union method:

Please Login or Register  to view this content.

[bulina2k]

or replace your

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.