There are many different ways of transferring data from Excel to Word; you need to be far clearer about what your needs are. Macros may not even be required. Possible methods of addressing those needs include mailmerge, the use of DATABASE fields in Word, OLE, or macros using any one or more of a variety of approaches.