-
Solved: Run Macro on Specific Sheet
I am trying to run a macro on a specific sheet ( regardless of the active sheet at the time) and have attempted the following, however it applies the macro to whatever the active sheet is. I am assuming that this is the incorrect way to achieve this. Any help would be appreciated.
Sub Noukaibi()
With Worksheets("Gold")
If Range("B35").Value <= Range("L40").Value Then
Range("B37").Value = Range("L39").Value
End If
End With
End Sub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules