I need a solution on how to create a named range based upon cell values. The cell values are variable, and the sheets on which the named ranges need to be created are hidden from the end user, hence the need to automate it. I've had some success with the actual name of the range as per a cells...