Using Sheet names & Workbook names in VBA coding
I've got a macro working (thanks to help from this NG) to delete certain
specified rows of data from a spreadsheet. Unfortunately, I have to go into
the VBA code to change th esheet name from "Sheet1" to the actual name of
the sheet. As I want to be able to use this code on more than one sheet (&
possibly across workbooks) is there a simple line of code that I can put
into the VBA to automatically put in th ecorrect sheet name & file name?