hi,
i am developing an excel file that use the MACROS, i have an issue which is how can i run a macro in sheet2 from an object in sheet1?
for example, i have a bottom to click on it in sheet1 that will run the MACROS and delete the rows in sheet2, the issue is that when i start this MACROS the rows that will be deleted going to be in sheet1 not sheet2.
thanks
i am developing an excel file that use the MACROS, i have an issue which is how can i run a macro in sheet2 from an object in sheet1?
for example, i have a bottom to click on it in sheet1 that will run the MACROS and delete the rows in sheet2, the issue is that when i start this MACROS the rows that will be deleted going to be in sheet1 not sheet2.
thanks