'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