Name range to have a variable section linked to a cell

[pedexe90]

Hello everyone,

Does anyone know if you can create a variable part in your named range. I don't want a dynamic named range I want to literally change the named range.

So imagine you have a named range : IncomeStatement.17.18.AfterBoardAdj

I want the 17.18 to change to 18.19 by linking it to a cell. I tried this "IncomeStatement."&"17.18"&".AfterBoardAdj" and linked 17.18 to a cell but I get errors.

Can someone help please.

Note: IncomeStatement.17.18.AfterBoardAdj and IncomeStatement.18.19.AfterBoardAdj are in different worksheets.

 

[Fluff]

AFAIK that is not possible.