是否可以在工作表上命名尚不存在的范围? [英] Is it possible to name a range on a sheet that does not exist yet?

问题描述

我正在尝试为工作簿中尚不存在的工作表创建一个命名范围.我将使用宏导入用户定义的文本文件作为源.

I am trying to create a named range for a worksheet that does not yet exist in the workbook. I will be using a macro to import a user-defined text file as the source.

我仅限于在导入工作表后才定义这些命名范围，还是可以在尚不存在的工作表上命名将来的范围?

Am I restricted to only defining these named ranges once the worksheet has been imported, or can I name a future range on a sheet that does not exist yet?

推荐答案

In指的是:

=INDIRECT("NotYetASheet!$A$1")

这篇关于是否可以在工作表上命名尚不存在的范围?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！