Columns("B").EntireColumn.AutoFit
This statement seems to take the first row of the column and fits to it. If
other cells of the column are wider i.e. their text is longer, they are
truncated. Is there a function which will look at all the cells in the

I very new to this VB coding game, so this may be fairly
obvious to everyone.
What's wrong with this?
~~~~~

Hi listmates,
This macro was posted a couple of weeks back by Doug Robbins. I am trying to
use it for my pruposes, but it fails because the docname variable (docname =
docnamerange.Paragraphs(1).Range.Text) adds an extra space at the end of the

I use the following code to read the height of "Rows" or "Cell":
Height := Table.Rows.Height
Height := Table.Rows.Item(1).Cells.Item(1).Height
The problem is that: the result value of Height is "9999999" (the value of

I am looking for the following symbol : a checkmark sign within a square. I
can only find an empty square or only a checkmark sign (within Marlett
fonttype). Which collection does hold this symbol ?
regards,

I have created a report in excel sheet with data and pie charts and then
copied in to a word document. When user after editing the excel sheet object
in the word document, it is loosing the size. How to restore the the excel
object size? If you have any solution let me know. Thanks.

I have several Addin macros I want to assign to keyboard shortcuts.  No
macro I
assign to a keyboard shortcut "takes".  Anything besides macros assign just
fine, but my Addin macros just won't.  Any ideas out there?

Copying and pasting text from a web page or an email frequently replaces
tabs with numerous spaces. Is there a way to replace > 1 space with a tab?

Is it possible to alter a macro of an another document/current document through a macro available in current document?

I need to set up access to print labels from 2 computers
to 1 printer.  It will not keep my page setup.  I need to
be able to have a custom page size and that is not an
option.  What am I doing wrong?!?!

We have a VB program which opens word documents and data source and
performs mailmerge programmatically.
Whenever there is a problem with mailmerge (eg: some mergefields are
missing) the word session hangs.

I have a relatively simple Form with some textboxes and
comboboxes.  All I simply want to do is that when a user
clicks on "OK" that the procedure verify every field has
data.  If every field is populated then the procedure runs

I am creating a Word table via VBA and assign the value
returned by the add method to a variable. If I use "Option
Explicit", I must declare that variable. What syntax do I
use to declare a variable whose value is the return value

I recorded a macro using Word 2002 that inserts letterhead into the
header of a new document based on a separate template file.  It works
great except that the font of the text in the header changes to
whatever font was used in the document.  How can I make the font in

I have a little complication to work through using VBA to parse out a
section of a string...
What I am in need of help with is the following line of TEXT...
"""<TD onmouseover=""""""""startOver(this, 'check38')""""""""