I have three questions regarding the VBA coding:
1- how can i apply the prevention code before closing/sharing the sheet
2- if i am using the code ( Selection.CurrentRegion.RemoveDuplicates Columns:=Array(1, 2, 3, 4, 5, 6, _7), Header:=xlNo ) to remove any data duplication within a certain code and its not applying what's the alternative/solution
3- what's the code for applying two data table in one master sheet - compounding
plz note that i am a beginner with the VBA.
Thanks,
1- how can i apply the prevention code before closing/sharing the sheet
2- if i am using the code ( Selection.CurrentRegion.RemoveDuplicates Columns:=Array(1, 2, 3, 4, 5, 6, _7), Header:=xlNo ) to remove any data duplication within a certain code and its not applying what's the alternative/solution
3- what's the code for applying two data table in one master sheet - compounding
plz note that i am a beginner with the VBA.
Thanks,