PASTING VALUES

[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

 

[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")

 

[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
(e-mail address removed)



.

 

[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

 

[Guest]

The "unmerge, center across, copy/paste value" works great.

Thanks a lot.

 

[Don Guillett]

glad to help