Consulting

Results 1 to 2 of 2

Thread: 255 Character Limit when copying worksheet

  1. #1
    VBAX Regular
    Joined
    Sep 2008
    Location
    Sheffield
    Posts
    72
    Location

    Exclamation 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

  2. #2
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •