Hello,
I have the below code to add a table of data to a calculation file. The table add copies the first existing table and then finds the next available column next to the table and pastes then giving you the option to name the new table. The file is locked down so once the table is added it cannot be deleted unless I unlock the file and delete. There are too many files out there for this. I was wondering if anyone had a suggestion on code to set up a delete table button. Click the button and a window pops asking which table you want to delete. It finds the table and deletes it. The table is three columns wide. The table name is in the third column at the top of the table so when it finds the table name it would need to delete the column it finds plus 2 columns to the left. Any help would be greatly appreciated. The file is too large to load to the site. The table name is in row 17. People can continue to add tables so it has to look at the entire row 17 and not a range.
Bookmarks