Results 1 to 8 of 8

VBA- Sheets.Copy

This is a discussion on VBA- Sheets.Copy within the Excel Questions forums, part of the Question Forums category; Hi, i have noticed when i am using "Sheets.Copy in Excel 2002 some of the comments in Col G is ...

  1. #1
    Board Regular
    Join Date
    Mar 2009
    Location
    Essex, England
    Posts
    537

    Default VBA- Sheets.Copy

    Hi, i have noticed when i am using "Sheets.Copy in Excel 2002 some of the comments in Col G is missing, i tried in 2010 and it works perfectly.

    Can someone who has 2002 check if they get the same issue

    Sheet1

     CDEFG
    1SourceCase No.Value DateSecurity CodeComments
    2TESTTESTTESTTESTPhysical Cash settlement - Reallocate to Unit Pricing - Srinivasan SHANMUGAVELU 13/4/11. dfttrtrtytrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrhhgfbrhtrytrytbgfbsedrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr rrrrrrrrrrrrrbrewrbrberbewbrewbrebrew


    Excel tables to the web >> Excel Jeanie HTML 4

  2. #2
    Board Regular
    Join Date
    Mar 2009
    Location
    Essex, England
    Posts
    537

    Default Re: VBA- Sheets.Copy

    *bump*

  3. #3
    Board Regular
    Join Date
    Nov 2006
    Location
    Los Angeles
    Posts
    636

    Default Re: VBA- Sheets.Copy

    Hi Donai,

    Microsoft Excel
    The sheet you are copying has cells that contain more than 255 characters.
    When you copy the entire sheet, only the first 255 characters in each cell are copied.
    To copy all of the characters, copy the cells to a new sheet instead of copying the entire sheet.
    I Envy The Person Who Knows Excel All The Way.
    << Excel 2007 >>

  4. #4
    Board Regular
    Join Date
    Mar 2009
    Location
    Essex, England
    Posts
    537

    Default Re: VBA- Sheets.Copy

    Quote Originally Posted by Sahak View Post
    Hi Donai,

    Microsoft Excel
    The sheet you are copying has cells that contain more than 255 characters.
    When you copy the entire sheet, only the first 255 characters in each cell are copied.
    To copy all of the characters, copy the cells to a new sheet instead of copying the entire sheet.
    Hi I need to copy entire sheet, it works fine on 2010. Is there a vba work around?

  5. #5
    Board Regular
    Join Date
    Nov 2006
    Location
    Los Angeles
    Posts
    636

    Default Re: VBA- Sheets.Copy

    Hi Donai,

    In my opinion with VBA you can copy all sheet first & then one by one (use loop) copy the cells which contains comments.
    I Envy The Person Who Knows Excel All The Way.
    << Excel 2007 >>

  6. #6
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling
    Posts
    64,939

    Default Re: VBA- Sheets.Copy

    Donal

    Is there no way you could use multiple cells for the comments?

    eg one comment per cell
    If posting code please use code tags.

  7. #7
    Board Regular
    Join Date
    Mar 2009
    Location
    Essex, England
    Posts
    537

    Default Re: VBA- Sheets.Copy

    Quote Originally Posted by Norie View Post
    Donal

    Is there no way you could use multiple cells for the comments?

    eg one comment per cell
    Norie the data is imported via in-house system, therefore i cannot use multiple cells

  8. #8
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling
    Posts
    64,939

    Default Re: VBA- Sheets.Copy

    Couldn't you split up the data after it's been imported?
    If posting code please use code tags.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com