255 Character Limit when copying worksheet

**ads_3131** · 04-02-2012, 07:35 AM

Hi all

im having a major problem with copying/moving a worksheet to a new workbook if a cell has more than 255 characters, is there a way around this or even some VBA ?

regards
adam

**Aflatoon** · 04-02-2012, 09:14 AM

See this MSKB. Copy the sheet, then copy the cells over; or just create a new sheet in the source then copy the cells.

04-02-2012, 07:35 AM	#1
ads_3131 VBAX Regular Joined: Sep 2008 Posts: 69 Kb Entries: 0 Articles: 0	255 Character Limit when copying worksheet Hi all im having a major problem with copying/moving a worksheet to a new workbook if a cell has more than 255 characters, is there a way around this or even some VBA ? regards adam
Local Time: 07:56 AM Local Date: 05-19-2013 Location:

04-02-2012, 09:14 AM	#2
Aflatoon VBAX Regular Joined: Sep 2009 Posts: 733 Kb Entries: 0 Articles: 0	See this MSKB. Copy the sheet, then copy the cells over; or just create a new sheet in the source then copy the cells. Be as you wish to seem
Local Time: 03:56 PM Local Date: 05-19-2013