'How to Run Macro on Specific Sheet Only
I have this block of code:
Sub Clean_Data()
Columns("K:K").Select
Selection.Delete Shift:=xlToLeft
Range("J2").Select
ActiveCell.FormulaR1C1 = "BAU"
Range("J3").Select
ActiveWindow.ScrollColumn = 12
ActiveWindow.ScrollColumn = 26
ActiveWindow.ScrollColumn = 33
Columns("AO:BE").Select
Selection.Delete Shift:=xlToLeft
Range("AO13").Select
ActiveWindow.ScrollColumn = 1
End Sub
I would like it to run on a specific sheet only. I tried doing it using With but nothing seems to work. Can you anyone help out?
Thanks!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
