how to create a named range in excel code example Example: excel convert cell value to range =INDIRECT("range") =INDIRECT(cell_with_range_as_text)