• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Insert a new row at the bottom of named Excel range using VBA and copy formular

    Thank you very much. That looks great but how did you delete table headers. When I selected table headers and selected Delete Table Columns, the process deleted all content in every column in the selected table, not just headers. PS: I do want to keep description headers, such as: Morning...
  2. J

    Insert a new row at the bottom of named Excel range using VBA and copy formular

    Hi Nebu, For some reason, I didn't even think about using 3 tables on each spreadsheet. My manager wanted a button on each day spreadsheet (day 1 to day 11) to insert a new row for specified meal time (breakfast, lunch, or afternoon tea); however creating 3 tables without headers on each...
  3. J

    Insert a new row at the bottom of named Excel range using VBA and copy formular

    As you'll see there are 11 spread sheets in the workbook, plus three I used for testing (JohnTest, JohnTest2, and FoodList). Each spread sheet will have 3 define name lists/tables, and some way of adding a new row to each named list by either a button or a drop down list. Each list will have 5...
  4. J

    Insert a new row at the bottom of named Excel range using VBA and copy formular

    I need to add/insert a new row at the end of a named range (defined name) to expend the named range and copy formula from the row (4 cells) above to inserted row using Excel VBA. There are three named ranges on the spreadsheet, 11 spreadsheets in the workbook and I would have insert new rows...
Back
Top