On Tue, 13 Nov 2007 08:58:05 -0800, pgarcia
wrote:

Why is it that a cell should format data differently then the cells above it?
When I cut and paste value there shouldn’t be any formatting, right? And when
I look at the data from "Format" there is nothing there, however, if you look
at the list you can plainly see that the data does not line up. It waves and
it misses with my VB code. I have to take the first "good" data and drag it
down. What gives? Is there a fix for this? And does this happen in all the
versions of Excel? I'm in 2000.

Thanks for any reply to this.

Since you gave no examples, one can only speculate. But there are any number
of ways this can happen. One common issue is that your data is variously being
interpreted by Excel as number, date or text.

This frequently occurs when users are unaware as to how Excel interprets input.

If you are interested in possible solutions, examples of your data, and code,
might be helpful.
--ron