Looking for guidance to have declared variables placed in target cells on a different worksheet within the same workbook. The existing code is below (NumRows hold the number of active rows within the worksheet). While it gets the job done - any suggestions on how to Improve/simplify? THANKS for the view!!
PHP:
Dim CallGoal As Long
Dim ApptGoal As Long
Dim SalesGoal As Long
Dim RevGoal As Long
CallGoal = Application.WorksheetFunction.Min(Range("W2:W" & NumRows))
ApptGoal = Application.WorksheetFunction.Min(Range("X2:X" & NumRows))
SalesGoal = Application.WorksheetFunction.Min(Range("Y2:Y" & NumRows))
RevGoal = Application.WorksheetFunction.Min(Range("Z2:Z" & NumRows))
Worksheets("Report").Select
Range("K5").Select
ActiveCell.Value = CallGoal
Range("K6").Select
ActiveCell.Value = ApptGoal
Range("K7").Select
ActiveCell.Value = SalesGoal
Range("K8").Select
ActiveCell.Value = RevGoal
Range("A1").Select