Clipboard usage

V

vikesh

I want to copy a cell's formula & its format at many places that are no
sequentially or logically arranged.

For this I decide to use clipboard command. I copy the cell int
clipboard but when i try to paste the formula & its format- the forma
is copied but the formula is not !! Excel pastes the values of th
formula in the destination cell. Why is it so?

can this problem be resolved.

Thanks in advance.

Vikesh Jai
 
A

Andy Wiggins

From the menu: Edit > Copy

Then at each destination cell: Edit > Paste

No need for the clipboard.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
V

vikesh

why i want to use clipboard is that

once you have used the Edit>Paste function and afterwards you typ
something & then again you want to paste the earlier copied cells- thi
cannot be done.

whereas the same is possible using the Clipboard function
 
G

Guest

the only command that i know of that will paste formulas
as values is the PasteSpecial Paste as values command. the
paste commmand is suppose to paste all which includes
formats, cell contends as is ect. check to see which paste
command you are using. (on the menu bar>edit>PasteSpecial
The copy commmant (all of them) uses the clipboard. In my
many years of macro writing, I have had to find others
ways to move data because of the copy command which uses
the clipboard and there for memory.
 
D

David McRitchie

Hi Vikesh,
If you use copy and paste you are copying the format and
the formula when you copy, and when you paste you are
copying the format and the formula from the clipboard
unless you use use Paste Special (still uses the clipboard).

The formula will change depending on it's new location.
If there is no forumula then the formula is actually the value,
and value only would not change when pasted to a different
location.

It is not clear to me exactly what it is that you want to do,
because the only way to get the results you describe is to
have used Paste Special values.

If you want to paste a formula to a new location unchanged,
you can copy from the formula bar instead of from the cell
and paste to another cell. You can also do this with a macro
http://www.mvps.org/dmcritchie/excel/excel.htm
 
Top