VBA doesn't work when string length more than 255 characters in the code lines

**thup_98** · 06-29-2016, 02:26 AM

Hello forum,
I have a work sheet with hundreds of row & column. I use VBA to auto fill in "Yes" for all cells but some cells have to be " No". The VBA has functions to reset all cells or each row to the default. It has been working fine until the string length in the VBA get more than 255 characters when I add more cells to the VBA (screen shot 1 &2). How can I increase this number (could be more than 1,000) so it can cover more cells.
The goal is to make the yellow highlight cells in column AG changed to "No" when the user resets the rows 67, 68, 70 & so on or reset all
Thank you for your help.
Thup_98

Please Login or Register  to view this content.

**humdingaling** · 06-29-2016, 02:49 AM

why must you do it all in one line....?

**TMS** · 06-29-2016, 03:37 AM

Easiest way would be to change the If ... Then ... to an If ... Then ... End If and split the Me.Range into two or three parts. Or use underscore (_) to split the line.

**thup_98** · 06-30-2016, 02:49 AM

Thank you humdingaling & TMS. It works perfectly
Thup_98

**TMS** · 06-30-2016, 04:40 AM

You're welcome. Thanks for the rep.

VBA doesn't work when string length more than 255 characters in the code lines

LinkBack

Thread Tools

Rate This Thread

Display

VBA doesn't work when string length more than 255 characters in the code lines

Re: VBA doesn't work when string length more than 255 characters in the code lines

Re: VBA doesn't work when string length more than 255 characters in the code lines

Re: VBA doesn't work when string length more than 255 characters in the code lines

Re: VBA doesn't work when string length more than 255 characters in the code lines

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Add string as formula through code doesn't work with sumif

[SOLVED] How to remove the rightmost N characters when the string length is variable

[SOLVED] Shorten string length if exceeds 31 characters (max sheet name length)

[SOLVED] My code to find longest string in column doesn't work properly! Need Help!!

Delete Entire Row if cell doesn't contain certain number and doesn't meet string length

[SOLVED] Complicated Macro doesn't work properly if lines are deleted

[SOLVED] How can I control the length of characters a code will return?

Bookmarks

Bookmarks

Posting Permissions