Convert LastUsedColumnNumber to Excel letter-representation

Question

In version 4.71.4, I tried to use the LastUsedColumnNumber, and as the name already gives away it returns a number while I had hoped for a column name in the range of 1 to “ZZZ” like the ones that Excel uses. This would make it easier to also used it in the column/data range definition when reading data.

Can anyone advice on how to easily/efficiently translate this?

Thanks in advance!

Page 1 / 1

You can convert it from the numerical representation to the letter-representation using the axll::ColumnName function (see https://how-to.aimms.com/Articles/228/228-data-ranges.html#axll-functions)

Reply

gdiepen · Accepted Answer

You can convert it from the numerical representation to the letter-representation using theaxll::ColumnName function (seehttps://how-to.aimms.com/Articles/228/228-data-ranges.html#axll-functions)

Reply

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded