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!