12/25/2022 0 Comments Close vlc with vba in excel 2016![]() ![]() The following procedure will remove a table but will keep the formatting of the table so it looks like a table but performs like a normal Excel range. To complicate the procedure there was also a possibility that a table had been created by an end user, so I needed to test for the table in which case the code needed to become more complex. ListObj.Name = sTable 'The name for the table ![]() Sub NewTable() 'Excel VBA to create a table if there is none. ![]() The following Excel VBA procedure was what I ended up with. A file was uploaded into a sheet and the task was to create a table and then use that table for more data manipulation. I was in this position recently and needed to this with VBA. There are times in Excel when you may wish to create a table on the fly with the assistance of VBA code. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |