Is it not possible for Excel to fill an array using a named range that is no longer in use?

asked 2023-06-28 01:54:41 +0000

scrum
21 ●2 ●2

edit retag flag offensive close merge delete

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2023-06-28 02:20:01 +0000

pufferfish
41 ●3 ●2

Yes, it is possible for Excel to fill an array using a named range that is no longer in use. However, if the named range has been deleted or renamed, Excel will not be able to locate it and will return an error. In such cases, you may need to update the formula or reference the correct range in order for the array to be filled correctly.

edit flag offensive delete link

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer

Question Tools

Stats

Asked: 2023-06-28 01:54:41 +0000

Seen: 11 times

Last updated: Jun 28 '23

Is it not possible for Excel to fill an array using a named range that is no longer in use? edit

1 Answer