Have you ever come across an Excel spreadsheet where the serial numbers are not in sequence? Well I have 😛 It’s not as simple as putting 1 in cell A1, =A1+1 in cell A2, and copying the formula to the subsequent cells. Sometimes you may insert/delete a row, move some rows, insert section headers and …
Was preparing my personal budget Excel workbook for next year. It contains a Summary worksheet and a worksheet for each month of the year. Copied this year’s workbook, renamed it and thought there must be a better way to clear the month worksheets and set recurring expenses. So I wrote 3 Excel VBA procedures (1 …
Continue reading “Clear worksheets and set rows using Excel VBA macros”
Writing this down after almost pulling my hair out in grappling with the correct syntax as it has been a long while since I coded macros in Excel. To start dabbling with macros in Excel 2013, go to File > Options > Customize Ribbon and tick the checkbox for the Developer tab on the right …
