Copying paste text from one excel to another doing something strange

[christhedonstar]

Hi,

I have two excel sessions with a seperate sheet in each.

On sheet 'A' I hit Ctrl and `. Then I select all and then paste into sheet 'B' as text.

What I've found is that when I get to column BB I get the columns being misaligned. Now what was in BC in sheet 'A' is now in BB in sheet 'B'. The cells to the left match.

Any idea why this happens and how to resolve it?

Thanks,

Chris

 

[GSCaupling]

Hi Chris,

What was in BB on Sheet A? Was it empty?

If A!BB was empty, did you have other empty columns (from A to BA) that were not overwritten in a similar manner?

Finally, was BC the last column in the range that you copied? If not, did all the columns to the right of BB also shift one column to the left?

GS

[small][navy]**********************^*********************
I always know where people are going to sit. I'm chairvoyant.[/navy][/small]