Yes, an explanation may help.

I have some data in excel and I want to create a word document. I don´t
know how many rows I would have to export since it can change depending
of the selection.

So if I select "x" I would like to export to a table in excel:

Name 1 Adress 1 Telephone 1
Name 2 Adress 2 Telephone 2
Name 3 Adress 3 Telephone 3
Name 4 Adress 4 Telephone 4

but if I select something different I would like to have 10 rows
instead of 4. I have created a template and defined a matrix inside it
as follows:


{1,1} {1,2} {1,3}
{2,1} ................
........................
{15,1} {15,2} {15,3}

and what I am doing is using find and replace from VBA Excel to change
this values to name, adress and telephone. If I have only 4 records in
my list, the rest of the values to 15 I replace them with a blank
space.

The problem is that I want to add some text after the table, and if I
add only 1 row to it, the text below it its going to be far below (like
if I had 15 rows). I want to be able to select some of the table and
delete the rows I have not used.

Hope it helps a little bit more.


--
internacio
------------------------------------------------------------------------
internacio's Profile: http://www.excelforum.com/member.php...o&userid=30960
View this thread: http://www.excelforum.com/showthread...hreadid=519727