"MartinW" <mtmw@hotmail.invalid> wrote in message
news:eLM1kdSmGHA.1404@TK2MSFTNGP05.phx.gbl...
> Hi DB,
>
> >But that copies the cell numerical values into the new sheet without
> transferring the formulae that created them.<
>
> Err No. That pastes the formulae or if there is no formula in a cell it
> pastes the value
>
>>(The formula bar contains the number in the cell, not the formula that led
>>to it).<
>
> Errr No again. The formula bar displays the true value of a cell whether
> it
> is a formula or a number or text or whatever and that is the value that is
> copied, not the 'display' that is shown in the actual cell.
>
> Regards
> Martin


Thanks for coming back again, Martin. I've an apology to make...

I was opening a new workbook and copying the data there - not, as it seems
you were suggesting, opening a new sheet in the same workbook. And, yes (I
insist - I've spent all morning p*ss*ng about with this!) doing that *does*
copy across numbers, not formulae.

When I opened a new sheet (sheet 3) in the *same* workbook and copied the
data across to it (from sheet 2) formulae went over to it satisfactorily.
Not now needing sheet 2 I tabbed it up and tried to delete it (Edit - Delete
Sheet) but 'Delete Sheet' was greyed-out - indeed, it's greyed out IRO tabs
1 & 3, too in this workbook.
Now it always opens up at sheet 3 - I still can't get it to open at sheet 1.
But I've got rid of the 65536-row irritation I mentioned in my original
post.

Your replies have been much appreciated but my problems here are quite
insignificant: I can easily live with them, and I'm not looking to you to
come back again. Isn't it just irritating when things don't behave just as
they should and you can't work out why?


Thanks again,
Don.