PDA

View Full Version : 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 (http://support.microsoft.com/kb/213548). Copy the sheet, then copy the cells over; or just create a new sheet in the source then copy the cells.