#1
|
|||
|
|||
define name
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 |
#2
|
|||
|
|||
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).
|
#3
|
|||
|
|||
Thank you, busy with it
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to define two constraints for a task? | fa2020 | Project | 1 | 01-12-2021 09:33 AM |
Get Sub Module Name using VBA and Truncate to Define Variable? | rekent | Word VBA | 1 | 08-01-2020 09:37 AM |
How to define a permanent frame for word? | blakroz | Word | 4 | 04-27-2019 07:43 AM |
Define New Valid Folder Name | gmaxey | Word VBA | 2 | 01-12-2016 04:43 AM |
How to define restrictions to resource combination | andrebmsilva | Project | 6 | 11-10-2013 03:02 PM |