No.
What effect would you like achieve.
There may another method like Center Across Selection.
Gord Dibben MS Excel MVP
I want to put:
Vendor Name Cust Name Cust Phone Cust Fax all on one row
For the sake of consistency throughout a large workbook, I wanted to use
cells to keep everything lined up equally.
Thought about using text boxes, and maybe even coding in the Workbook
Name = Vendor Name, Worksheet Name = Customer name - then I would only
have to add the phone and fax on each worksheet. But since the workbook
is already so large, I figured adding textbox controls and coding to
each worksheet to do something that can be done once and will never
change was going to bulk up the workbook and slow things up
un-necessarily.
> No.:
>
[quoted text clipped - 8 lines]
> >worksheet?
> >Joanne
Gord Dibben - 09 Oct 2007 05:03 GMT
It's late so maybe that's why I don't see a problem.
What is preventing you from entering Vendor Name Cust Name Cust Phone Cust
Fax in A1:D1?
It can't be that easy so what else have I missed or you have left out?
Maybe you need VLOOKUP formulas on each sheet?
Gord
>I want to put:
>Vendor Name Cust Name Cust Phone Cust Fax all on one row
[quoted text clipped - 20 lines]
>> >worksheet?
>> >Joanne