I got one macro in Sheet1 and another macro in sheet2 under the same workbook.I want to assign a button in sheet1 so it can execute both the macros in sheet1 and sheet2.Can someone help me....please
there is no macro in one sheet and another macro in another sheet. the macros are in one module in vb editor
anyhow try this modification
whenever you talk about error message you musts tell at which statement the error message occurs(or the macro stops) and also the text of error message which will be helpful to try to solve the problem.