Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default Copying text from a cell

in my database I am copying a number of cells from one sheet into another
and using paste special/values. I then run a macro to insert a line which
moves the information down a row. However, one cell contains text with upto
200 characters and whenever the paste takes place the text never copies to
the cell on the new sheet even though cells on both sheets are formatted to
text. Can anyone help please?

DAT


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying a cell and changing the formating from number to text Mark Gloves Excel Discussion (Misc queries) 3 June 22nd 07 01:51 AM
copying text Max Excel Worksheet Functions 0 March 28th 07 01:20 AM
Truncated text when copying text from one excel doc to another sunny pete Excel Discussion (Misc queries) 3 August 12th 05 02:11 PM
Copying Text to another cell/worksheet Lisa Excel Worksheet Functions 3 April 12th 05 07:00 AM
Text not copying as text from Word to Excel 2003 Christine Excel Discussion (Misc queries) 4 March 3rd 05 11:33 PM


All times are GMT +1. The time now is 10:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"