Hi

I have found a workaround to the problem as follows, and did it this particular way so the worksheet presentation does not have to be changed.

Data is entered by the user and as the sheet needs to be hidden after use, all code is attached to the button for hiding the sheet.

All named ranges are generated using VBA as dynamic ranges (could not get the code to work for static ranges), after each dynamic range has been generated, the actual range is derived using "RefersToRange.Address" and the named range converted to a static one.

I am sure there are simpler ways, but this works well for me.

Regards

Jeff