I have a requirement to log all the changes made to a particular worksheet. I cringe whenever I’m faced with that particular task. I could use a Worksheet_Change event coupled with a Worksheet_SelectionChange event to log the old cell value and the new cell value. I really hate that option for a couple of reasons. […]
Hi everyone, first time authoring here and looking to pass on one of the neat, but less intuitive aspects of data management in Excel. Often I find myself with data in an external database, such as Access and continuously editing the query there to get the data how I want it in Excel. With care, […]
The Workbook_BeforeClose event fires when a workbook is closed. But just like the name says, it actually fires just before the workbook is closed – or so you thought. The problem with the BeforeClose event is that it can run even if the workbook is not eventaully closed. If the workbook is unsaved and the […]
A formula to put the sheet’s name into a cell =RIGHT(CELL(“filename”,A1),LEN(CELL(“filename”,A1))-FIND(“]”,CELL(“filename”,A1))) The CELL() function with the “filename” argument will return the full path of the workbook plus the sheet name. The workbook will be enclosed in brackets []. This formula finds the right bracket (]) and returns everything after that. Note that if the workbook […]