Search results

Thanks, much appreciated!

Thanks for your help. In what situation would you need it?

Would it be best to take the line of code out or change it to =true?

How do I reenable screen updating?

Please explain. What is it, why do I need it and how did I get rid of it?

I have a table added to my spreadsheet and I have two buttons. One to add a row to the table and one to delete a row from the table. When I put them in, they both will work but then I go and do some other formatting on the spreadsheet and I come back to the buttons and I click them and only the...

I found out what I should do. I just included the long formula in the cell in F7 so it updates correctly now. Yay Now I just need a way to ask for confirmation before deleting a row if the row has text in it...

This is the row that is highlighted: Set tbl = ws.ListObjects("Costing") Is there anything wrong with this line as my table is called Costing, so I have no idea??

This is driving me nuts! I went to an earlier version of the file where the table tools did show up but when ever I select it make it into a range and add in just the I to the new table, it gives me the same error.

so it isn't registering as a table.

I moved the formulas then made another table. It still gives me the same error. When I have a cell within the table selected, the table tools menu item won't even show up.

Now it won't let me convert to a range. I am selecting the table, right clicking on a cell but it doesn't give me the option.

When I try and run it and press the add button row, this is the line that has the error: Set tbl = ws.ListObjects("table3") It says run time error 9, subscript out of range. But that doesn't make sense as my table is set to table3??

This spreadsheet records more then 1 item. This is the code I have behind my add button. Private Sub CommandButton3_Click() ActiveSheet.Unprotect Password:="" Dim ws As Worksheet Set ws = ActiveSheet Dim tbl As ListObject Set tbl = ws.ListObjects("table3") 'add a row at the end of the table...

Thanks, that looks just like what I need. Only problem is, I don't know how to get it working. When I try and paste the code below behind a button, I get an error for tbl.ListRows.Add. The error is Run time error 424, Object required Does tbl needed to be declared as something?

I have formulas in rows F, G, H and M, which all need copying down. They are all part of one table except M, which is part of it's own table.

This is the code I have for the Add a row button: ActiveSheet.Unprotect Password:="" Dim ws As Worksheet Set ws = ActiveSheet Dim tbl As ListObject Set tbl = ws.ListObjects("table3") 'add a row at the end of the table tbl.ListRows.Add ActiveSheet.Protect Password:="" Where do I put that code...

I am feeling a little confused. Should I leave it as a table or change it to a range?

I am going to try instead of the table, converting it to a range and see how I go.

I did find that table, thanks. I have worked out how to insert and delete rows but I am getting a lot REF errors in the formulas as they aren't being filled down when I make a new row. Does anyone know the vba to fill a formula down when a row is inserted?