Column width totals

[Deborah]

I have to link different sheets of data throughout a Word document.
When performing a copy/paste however, the sheets come in in different
sizes and I need them to be consistent in size.
Is there a way to somehow see the total width over multiple columns in
Excel. Specifically, I want to highlight one table and know in Excel
it is 5" wide, then highlight another spreadsheet content and somehow
see it's width so I would know before copying to Word how much larger
or smaller to make it.

I hope someone can understand what I am asking.

Sincerely,
Deborah

 

[dave]

If you higlight the table and either make all the columns
the same width(and multiply the width timed the # of
columns) or measure each column's width in excel and make
sure that the total for each table is the same by making
small adjustments to the column widths in excel, they
should both paste with identical sizes.

 

[A.W.J. Ales]

Deborah,

Sorry, this was accidentally answered to your mail address in stead of to
this group.


This subroutine calculates the width of an selected area.
I think it is measured in "point" ( not inches or pixels).
Somewhere there are some function which translates point in inches or
centimeters, but since you are just interested in comparing two ranges I
didnt take the effort to look for it.

Sub CalcWidth()
W = Selection.Width
MsgBox W
End Sub


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *