Hi Guys,
Hope you can help.
Do you know how to use a range named (with offset formula) when restricting access with Allow user to Edit Ranges. For some reason, as soon as I used an offset formula or a named range with an offset, the dynamic range is automatically converted to a hard coded range....
As usual, your help is greatly appreciated
Cheers
Hope you can help.
Do you know how to use a range named (with offset formula) when restricting access with Allow user to Edit Ranges. For some reason, as soon as I used an offset formula or a named range with an offset, the dynamic range is automatically converted to a hard coded range....
As usual, your help is greatly appreciated
Cheers