Hi,

Possible there are macros in the file which are interfering with the
command. Is the Edit, Copy command available?

It's really important to determine what is actually going on, but in the
meantime you can probably copy by holding down the Ctrl and dragging the
border of the cell you want to copy to the location where you want to paste
it.

To try to find the problem:
1. Close all Excel files except the one with the problem
2. Choose Window and see if the Unhide command is available - if it is there
is a hidden file open, probably Personal.xls.
3. Open the VB Editor - press Alt+F11
4. If the Project Explorer window is open in the top left expand the folder
under your file, if the window is not displayed press Ctrl+r to display it.
5. If there is a Modules folder expand it and double click on each of the
module and see if there is any code.
6. Also, double-click each of the object in the Excel folder (Sheet1,
Sheet2,..., thisWorkbook) and check for code.

You may need to do this for the Personal.xls file if you have one.

In all cases you are looking for code which might be preventing the
execution the normal copy and paste commands.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


" wrote:

I am using Excel 2000 (yeah, I know it's old) and am having a problem
copying formulas. Normally when you copy a formula, you highlight the
cell, press ctrl-C or 'edit/copy' and the border of the cell blinks/
winks (or whatever you want to call it), then you move to a new cell
and press ctrl-V or 'edit/paste' and the formula copies. I'm not
getting the blinky/winky when I press ctrl-c (actually I get one blink
and that's it) and when I move cells and press ctrl-v I get the cell
value copied, not the formula.
Any ideas??