When you type data into an Excel workbook, the sheet's name appears ... Dim sheetName as String Add the following line to assign the tab's name to the variable:sheetName = ActiveSheet.Name ...

On the Mac, the equivalent keyboard shortcut is Control-U, as F2 is assigned to cut the contents of the current cell. (If you’d like to see all of Excel’s keyboard shortcuts, open Help ...