Copy Paste Special not Working

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am trying to Copy-Paste Special Value from one Workbook in to another, but
its coming up with the following Error "This operation requires the merged
cells to be identically sized"

I'm assuming that it is because I have headings centred across columns. How
can I get around this if I do want these headings Centred and formatted like
the source workbook? I have been Copying-Pasting and then Copying-Paste
Special values to remove the links but this is causing a #Value! Reference
error

Thanks
 
I would suggest you unmerge and use "center across" instead. You can add a
custom button to your toolbar.
 
You could do it one cell at a time. But copy from the formulabar and paste to
the formulabar. By pasting to the formulabar, it'll be treated just like typing
in the value.
 
Don, how do you 'centre across' two columns? I thought that was Merge and
Centre? (which is what I have)
 
format>alingment>text alingment>center across.
I have a macro assigned to a button on my toolbar
Sub CenterAcross()
Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub
 
Thanks Don

Don Guillett said:
format>alingment>text alingment>center across.
I have a macro assigned to a button on my toolbar
Sub CenterAcross()
Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub
--
Don Guillett
SalesAid Software
(e-mail address removed)
add
Click to expand...
 
Back
Top