Sorry about the delay in reply; Rob I could loop through the layouts successfully however when I use the Set attributes function nothing changes. I looked into the code and its because of the row count for the dwg name and the rowcount for the attribs are different any ideas to work around. I hope you understand what I mean. If you want I can attach the modified excel spreadsheet