Hi All,

At work we often work with triangulated data in Excel.

As such, could anyone please show how to code in the most robust and elegant manner a macro to sleect a triangular area if a vertical column is selected.

I have attached a picture to show the selected column, and the target output i.e. a top-triangle selection, with the bottom left cell being the "Activecell".

If anyone could please assist in writing the macro that would be appreciated.

regards,