Am Thu, 2 Nov 2006 01:15:57 UTC, schrieb John Smith
What are the commands to manipulate tables?
A Table is a collection of various objects (Table is itself a member
of the Tables collection) which each have certain properties and
provide various methods to act on those objects.
The ones which you need are the Rows, Columns, and Cells, which are
indexed by their number, e.g. Rows(25), Columns(2), or Cells(7,5). The
VBE (Visual Basic Editor) helps you find the properties and methods of
those objects, and the online help also gives some information.
I have a table containing two columns. Column a contains words and
b sentences. I would like to look in column b for the words that
are in column a and change their color to red.
Your friend is the Find-Object and its sister, the
Replacement-Object.
It is not clear to me, if you want to look only for words in the
same row, or if you want to search in all cells of column 2 for the
word in e.g. cells(1,1). Depending on that, you would loop thru all
cells of column 1 and use the full column 2 as "Range", on which the
Find/Replacement work, or you would select for each cell in column 1
the cell of column 2 in the same row, and chase the Find/Replacement
objects on that cell.
Hope that helps,
L.W.
