VBA Workaround for 255 character limit in cell?

**Bjordion** · 11-13-2013, 03:38 PM

Hello,

I am using VBA to populate a column within my worksheet with the bolded formula below. This returned value in some instances results in "####" displaying in the cell due to total characters in the cell exceeding 255; the cell displays correctly in all other instances when the character count is 255 or less. My code is as follows:

Please Login or Register  to view this content.

I have referenced both

HTML Code:

and

HTML Code:

but I cannot figure out how to apply this to what I am doing.

Any help will be greatly appreciated. Thanks!

Bjordion

**Izandol** · 11-13-2013, 04:02 PM

There is not a 255 character limitation here. Perhaps the returned value is too wide for the cell.

**Bjordion** · 11-13-2013, 04:26 PM

I agree, this is not an issue of character limitation in the cell itself. I believe the issue is occurring when the value that is looked up is greater than 255 characters when the formula is placed into the cell by VBA. I can type out that exact same formula directly into Excel and receive the desired text every time.

Any thoughts?

**Izandol** · 11-14-2013, 09:41 AM

Are the cells becoming formatted as Text? If yes, change the format to General

**Bjordion** · 11-14-2013, 10:25 AM

Ughhhhhhhh... somehow the custom formatting from an adjacent column was being applied to my problem column. Changing the formatting to General remedies the issue completely. Hahaha, wow. Ocham's Razor never ceases to amaze me. Many thanks Iz.

VBA Workaround for 255 character limit in cell?

LinkBack

Thread Tools

Rate This Thread

Display

VBA Workaround for 255 character limit in cell?

Re: VBA Workaround for 255 character limit in cell?

Re: VBA Workaround for 255 character limit in cell?

Re: VBA Workaround for 255 character limit in cell?

Re: VBA Workaround for 255 character limit in cell?

Thread Information

Users Browsing this Thread

Similar Threads

VBA formulaarray 255 character limit workaround

[SOLVED] Workaround to the 32767 character limit for strings in VBA?

Display Active Character Count + Limit Character Per Cell

Workaround needed for 255 character find limit

[SOLVED] busted workaround for 255 character limit in cells

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions