Excel is still my spreadsheet workhorse, but VS Code handles the awkward file-level jobs I don't want Excel touching.
While it is easy to have ChatGPT write VBA for you, the process of returning that code to an actual Excel workbook is a different matter.You open the VBE, find the target module, delete the old code, ...
This simple procedure can save you a lot of time when you’re finished with your work. Susan Harkins tells you how. Some of us work with several Microsoft Excel workbooks open at the same time. Either ...