Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

are these glitches?

Posted by kevon neelon on March 06, 2001 1:33 PM
I'm working with a reasonably large file (10000 rows) in Excel 2000 and have come across two problems - minor ones, but disturbing ones.

Does the TRIM function not always work? I tried it on the string "A 1326 A" and had to manually delete the spaces in between. Are some ascii characters not visible?

I pasted a large amount of rows - maybe 2000 - from one worksheet to the large one I'm working on now. As soon as it copied over, a section of the this selection turned yellow. I tried un"Fill Color", but no luck. What's going on?


Re: are these glitches?

Posted by Mark W. on March 06, 2001 1:46 PM
> Does the TRIM function not always work?
> I tried it on the string "A 1326 A" and had
> to manually delete the spaces in between.

Removes all spaces from text except for single
spaces between words.

> I pasted a large amount of rows - maybe 2000 -
> from one worksheet to the large one I'm working
> on now. As soon as it copied over, a section of
> the this selection turned yellow...

Did you check for the presence of a Conditional
Format?


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.