I have the following Macro that needs to be run on the current active sheet and create the Pivot table on the active sheet as well. Right now I can only get it to run for a specific sheet. How would I change this?
Sub Macro3()
'
' Macro3 Macro
'
'
Range("B28").Select...