Run Macro using WITH

[ItalianPlatinum]

Is there a way for me to run a macro designed for a particular sheet using WITH? My current approach seems inefficient. I don't think it causes me time drag but I am trying to optimize anywhere I can. Do I really need to activate the sheet in order to run the macro designed for that sheet?

'clear and set filters
With WsSec
    .Range("H2:J6").Cells.ClearContents
    .Range("8:8").Cells.ClearContents
    .Range("ACCT") = F
    .Range("V") = V
    .Range("DATE") = RUN
    .Range("1ITEM") = "G"
    .Range("1OP") = "="
    .Range("1VALUE") = "S"
    .Range("A8:D8") = Array("D", "4", "A", "U")
    .Activate
    .Range("A10").CurrentRegion.Delete
End With

'clear and run
Call Sec2

 

[rlv01]

If you avoid using 'Select' and 'Selection' and qualify your range references you often do not need to activate sheet. As with all things programming, the devil is in the details.

 

[ItalianPlatinum]

The sec2 is very specific to that sheet though (WsSec). So if i remove activate as it is. it wouldn't operate unless on that sheet.

 

[rlv01]

If you say so. But it is absolutely possible to write code that does not require a given sheet to be active.

 

[ItalianPlatinum]

That code isn't mine. It's a program from our vendor. I can though modify items in that workbook just not that code unfortunately. So that is part of my obstacle. So I activate the sheet then run that code. I am assuming there is no other way for me to not activate like I am doing then?