Hi
I’m trying to copy (Move or copy>>move to end) a worksheet to another spreadsheet. But an error coming as “It has more than 255 character……..”. I do have some cell where content are more than 255 char.
Could you please suggest any way out?
Hi
I’m trying to copy (Move or copy>>move to end) a worksheet to another spreadsheet. But an error coming as “It has more than 255 character……..”. I do have some cell where content are more than 255 char.
Could you please suggest any way out?
I remember facing this similar problem in the past. Try inserting a blank worksheet in your destination workbook and then copy the contents from ur 1st workbook into that sheet.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks Arlu
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks