Copy Constants Only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Khalil Handal - 17 Mar 2008 20:56 GMT

Hi,
Need to copy all "values" or "constants" (not Formulas) from one sheet to
another sheet in a different workbook. I did the following:
Edit -->Go To then Special (from dialogue box) then "constants"
I see all the cells that I want are selected. Then I tried to use the copy
command but I got the error message: "that command cannot be used on a
multiple selection".
Any ideas is appretiated!
Khalil

Reply to this Message

Bernard Liengme - 17 Mar 2008 23:17 GMT

Here is a method that works,
Copy everything to the second sheet
Not use Edit | Go To | Special | Formulas and tap the Delete key
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

> Hi,
> Need to copy all "values" or "constants" (not Formulas) from one sheet to
[quoted text clipped - 5 lines]
> Any ideas is appretiated!
> Khalil

Reply to this Message