I have about 240 cells that I need to give each cell a define name, that 1 should be rente 001 and the last one rente 240
How can I do it without doing one by one, is there a way to define all of them at once

I can't be sure without an example of range, and the formula you want to use the names, but I suspect you can use a single dynamic name instead (a dynamic name will have different value depending the cell it is called from).

Thank you, busy with it