PASTING VALUES

M

Maureen

When I try to copy the formula in a cell that is a merge
of 3 columns as a VALUE using Paste Special to a similar
cell of 3 merged columns, it is not accepted. What's the
problem? I have no problem copying formulas or formats in
the same situation.

Thanks
 
D

Don Guillett

try
Range("d1:f1").Copy Range("h1:j1")
or
Range("h1:j1").Value = Range("d1:f1").Value
or even
Range("h1").Value = Range("d1")
 
M

Maureen

Sorry, I don't understand. Is "range" a function?
-----Original Message-----
try
Range("d1:f1").Copy Range("h1:j1")
or
Range("h1:j1").Value = Range("d1:f1").Value
or even
Range("h1").Value = Range("d1")
--
Don Guillett
SalesAid Software
[email protected]



.
Click to expand...
 
D

Don Guillett

This was a macro to do it.
If you want to use a formula you will need to unmerge>do your copy
paste>remerge
OR better yet
unmerge and use center across instead to do you copy/paste values
 
Top