Hi Rob,

If you use the Asc() function to examine the values of the characters
in strCellText, you should find that there is a 9 that represents the
tab, and a 13 and a 7 that together represent the end-of-cell marker.

However, it isn't possible to capture the leader in a string variable.
For one thing, it isn't a property of the tab (which is a simple
character, vbTab, with the ASCII value 9) -- it's a property of the
*tab stop* in the current paragraph.

If you run this code, you'll see what the setting is for the first
tabstop in the first paragraph in the cell:

   Dim oCell As Cell
   Dim ldr As WdTabLeader
   Set oCell = ActiveDocument.Tables(1).Cell(1, 1)
   ldr = oCell.Range.Paragraphs(1).TabStops(1).Leader
   MsgBox ldr

The numbers shown are 1 less than the ones in the Format > Tabs
dialog, with spaces (None) being 0, dots being 1, dashes being 2, and
underline being 3. (There are also two kinds you can set from a macro
that aren't available in the dialog.)

You would have to store the leader value in a separate variable (and
the same goes for the tabstop's position).

A better idea, if you have control of how the document is initially
created, is to use a specific paragraph style that has the tabstop
position and leader defined in it. Get the name of the style of the
paragraph when you store its text in the string, and reapply that
style when you use the string later.

--
Regards,
Jay Freedman
Microsoft Word MVP         FAQ: http://word.mvps.org