Trying to have my email generating macro address it based on which radio button is checked on the excel worksheet.
Getting "subscript out of range" on this line
Set ws = ActiveWorkbook.Worksheets.Item("Sheet1")
in below code
Sub IfOptionButtonChecked()
Dim ws As Excel.Worksheet
Set ws =...