Hi, Jere. This would probably be automated easier from Word code than Excel
code. You'd want to set a bookmark in your Word document where you want the
value to show. Then a Word macro would open the Excel file, grab the value
of A2 from the correct sheet and put it in a string, and set the contents of
the bookmark as that string. Does this work for you?

HTH
Ed

"Jere" wrote in message
...
How can I create a macro that takes data from exel into word?
For Example take the content of cell A1 in mylist.xls and place it into
word replacing text that says A1?

Thanks in advance.