As always, post YOUR code for comments

--
Don Guillett
SalesAid Software

"Steph" wrote in message
...
Hi all. How can I have excel clear contents in the range E30:AE30, then
copy E15:AE15 and paste special values in E30:AE30 in two specific sheets
in a workbook (sheet1, sheet2)? The clearing, copying and pasting I can
get through the recorder, but how can I get the code to loop through the 2
sheets? Thanks!