|
Simple
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! |
| All times are GMT +1. The time now is 01:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com