VBA- Sheets.Copy

[Donai]

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

Excel Workbook
	C	D	E	F	G
1	Source	Case No.	Value Date	Security Code	Comments
2	TEST	TEST	TEST	TEST	Physical Cash settlement - Reallocate to Unit Pricing - Srinivasan SHANMUGAVELU 13/4/11. dfttrtrtytrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrhhgfbrhtrytrytbgfbsedrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrbrewrbrberbewbrewbrebrew
Sheet1

 

[Donai]

*bump*

 

[Sahak]

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.

 

[Donai]

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?

 

[Sahak]

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.

 

[Norie]

Donal

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

eg one comment per cell

 

[Donai]

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

 

[Norie]

Couldn't you split up the data after it's been imported?