Excel offers myriad options for referring to workbooks and sheets in your VBA code. ... to retrieve the name of the active sheet, you’d use a function similar to the following: ... A cheat sheet ...