vba add/delete rows

I want to write a macro that will allow me to add rows to a table in Excel. I would like to do this across several tabs. I would like the macro to find the last row in my table with data in it, and then add a row below the last row. After adding the row, I would like it to copy the formulas...

I have a sheet, where Column A has Boolean values. However there are also cells with #VALUE!. I want to delete the entire rows with FALSE or #VALUE! in column A. I have the code below which does half the job, it deletes the FALSE rows. What I need now is to delete the #VALUE! rows, but I...

Hello, I created a userform in VBA that is used to add product options to a proposal spreadsheet. I want a command button on the userform that, when clicked: adds a new row in the proposal spreadsheet assigns an index number to the newly added row (or names the row in some way) - so users...