Hello Everyone,
Need help with an excel macro to clear data in specific columns on different sheets.
Sheet1 would start on A2 and clear columns A to AA, down to the last row of data.
Sheet2 would start on A2 and clear columns A to AG, down to the last row of data.
Sheet3 would start on K2 and clear columns K thru O, down to the last row of data.
Finally is there a way to only clear specific sheets using check boxes, and if no check boxes are selected then it would clear all three sheets?
Thanks for your help.
Need help with an excel macro to clear data in specific columns on different sheets.
Sheet1 would start on A2 and clear columns A to AA, down to the last row of data.
Sheet2 would start on A2 and clear columns A to AG, down to the last row of data.
Sheet3 would start on K2 and clear columns K thru O, down to the last row of data.
Finally is there a way to only clear specific sheets using check boxes, and if no check boxes are selected then it would clear all three sheets?
Thanks for your help.