rdekanter
10-10-2018, 05:21 AM
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
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