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.

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"John" <(E-Mail Removed)> wrote in message
news:Y3C4d.31851$(E-Mail Removed)...
> 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
>
>
>

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.

John wrote:
>
> 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

--

Dave Peterson
(E-Mail Removed)

Don, how do you 'centre across' two columns? I thought that was Merge and
Centre? (which is what I have)


"Don Guillett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I would suggest you unmerge and use "center across" instead. You can add a
> custom button to your toolbar.
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "John" <(E-Mail Removed)> wrote in message
> news:Y3C4d.31851$(E-Mail Removed)...
> > 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
> >
> >
> >
>
>

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 Removed)
"John" <(E-Mail Removed)> wrote in message
news:4LQ4d.31906$(E-Mail Removed)...
> Don, how do you 'centre across' two columns? I thought that was Merge and
> Centre? (which is what I have)
>
>
> "Don Guillett" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > I would suggest you unmerge and use "center across" instead. You can add
a
> > custom button to your toolbar.
> >
> > --
> > Don Guillett
> > SalesAid Software
> > (E-Mail Removed)
> > "John" <(E-Mail Removed)> wrote in message
> > news:Y3C4d.31851$(E-Mail Removed)...
> > > 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
> > >
> > >
> > >
> >
> >
>
>

Thanks Don

"Don Guillett" <(E-Mail Removed)> wrote in message
news:Oh%23O%(E-Mail Removed)...
> 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 Removed)
> "John" <(E-Mail Removed)> wrote in message
> news:4LQ4d.31906$(E-Mail Removed)...
> > Don, how do you 'centre across' two columns? I thought that was Merge
and
> > Centre? (which is what I have)
> >
> >
> > "Don Guillett" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > I would suggest you unmerge and use "center across" instead. You can
add
> a
> > > custom button to your toolbar.
> > >
> > > --
> > > Don Guillett
> > > SalesAid Software
> > > (E-Mail Removed)
> > > "John" <(E-Mail Removed)> wrote in message
> > > news:Y3C4d.31851$(E-Mail Removed)...
> > > > 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
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

glad to help

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"John" <(E-Mail Removed)> wrote in message
news:ihW4d.31940$(E-Mail Removed)...
> Thanks Don
>
> "Don Guillett" <(E-Mail Removed)> wrote in message
> news:Oh%23O%(E-Mail Removed)...
> > 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 Removed)
> > "John" <(E-Mail Removed)> wrote in message
> > news:4LQ4d.31906$(E-Mail Removed)...
> > > Don, how do you 'centre across' two columns? I thought that was Merge
> and
> > > Centre? (which is what I have)
> > >
> > >
> > > "Don Guillett" <(E-Mail Removed)> wrote in message
> > > news:(E-Mail Removed)...
> > > > I would suggest you unmerge and use "center across" instead. You can
> add
> > a
> > > > custom button to your toolbar.
> > > >
> > > > --
> > > > Don Guillett
> > > > SalesAid Software
> > > > (E-Mail Removed)
> > > > "John" <(E-Mail Removed)> wrote in message
> > > > news:Y3C4d.31851$(E-Mail Removed)...
> > > > > 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
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>