Category: VBA

This is about how to the reference a table and its columns in VBA (where it is known as a ListObject) in a multitude of scenarios. The aim is to make your VBA code robust for the situations where a table name, column name or column position is liable to change.

The spreadsheet calculates volume loss in a tunnel based on its deformation in Plaxis rather than from surface deformation. This can be used for cross-referencing your results or if need be, estimating the trough width parameter (K). A link to the spreadsheet can be found at the top of the blog post.