Good Day!
I have created the code with marco, but it only work perfectly when I run the marco in the active sheet but not on other sheet.
Please help.
Here is my file's background.
1. I have a table in sheet1, column B to be replace with column A.
2. I have 3 others sheet, ie. M1, M2 & M3 which content datas
3. I would like to replace all the items listed in the table across M1, M2 & M3 with a marco.
Dylan
I have created the code with marco, but it only work perfectly when I run the marco in the active sheet but not on other sheet.
Please help.
Here is my file's background.
1. I have a table in sheet1, column B to be replace with column A.
2. I have 3 others sheet, ie. M1, M2 & M3 which content datas
3. I would like to replace all the items listed in the table across M1, M2 & M3 with a marco.
Dylan