VBA- Sheets.Copy

Donai

Well-known Member
Joined
Mar 28, 2009
Messages
543
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
CDEFG
1SourceCase No.Value DateSecurity CodeComments
2TESTTESTTESTTESTPhysical Cash settlement - Reallocate to Unit Pricing - Srinivasan SHANMUGAVELU 13/4/11. dfttrtrtytrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrhhgfbrhtrytrytbgfbsedrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrbrewrbrberbewbrewbrebrew
Sheet1
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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.
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0
Donal

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

eg one comment per cell
 
Upvote 0
Couldn't you split up the data after it's been imported?
 
Upvote 0

Forum statistics

Threads
1,213,492
Messages
6,113,967
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top