Hello,

I am looking to use a short script to cycle the relative / absolute nature of a cell. To do this I know I can use
cell.Formula = Application.ConvertFormula(cell.Formula, xlA1, xlA1, 1)
where 1 is the equivalent of xlAbsolute

What I would like to do is have this cycle, so if it is already absolute, it will use 2 instead which is the equivalent of xlAbsRowRelColumn. It would then go to 3, 4 and the back to 1 etc.

To do this I would like to simply read the current state of xlReferenceType for a given cell and then increment it with a mod function, however I do not know how to read the state of xlReferenceType (or any Enumerations for that matter).

Any ideas how to do this please?

Thanks