VBA code to reference current sheet

[boy3hc2004]

I've created a macro in Excel that formats and sorts cells according to colour; however, a portion of the VBA code is limited to using the sheet named "Data2". In order for this code to execute on any sheet that I run it on, I'm trying to make it more generic. The non-generic portion of the code is indicated in yellow below.

 

[kevin9999]

Try replacing:

ActiveWorkbook.Worksheets("Data2").

with:

ActiveSheet.

 

[boy3hc2004]

Try replacing:

ActiveWorkbook.Worksheets("Data2").

with:

ActiveSheet.

Thank you very much. It worked.

 

[kevin9999]

Happy to help, and welcome to the forum.