copying top 15 rows

it seems to work - but because of the formula that is in the sheet2, it copies the formula and that stuffs it up.

how do you make it just copy the actual value not forumla? i belive it will work perfect then.

thanks again loz

Joel

hey,

just for references for future people all i need was

Worksheets("Summary").Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial xlValues

xlValues - added to end of line.

worked fine.

thanks again loz

Joel