=表( "tabname1" ).范围( "table[thatcolumn]" ) 不接受。想要更改工作表名称并搜索每个选项卡表格中的相同列

Question

我需要在=search("waldo", sheet("tabname1").range("[table1[thatcolumn]]"))范围内建立一个搜索

所有选项卡上都存在表1。

这里怎么了？

非常感谢。

Answer 1

https://exceloffthegrid.com/turn-string-formula-with-evalute/显示了一个VBA"单行"，它可以使Excel像在单元格中键入字符串一样解析任何字符串。

I can now assemble strings with whatever tab/range variations I want, and I get an answer.

例如：

Tab is 0402, Range is Analyzed, desired column is Number
formula = TABNAME & "!Analyzed[@[Number]]"
EvaluateString(formula) takes "0402!Analyzed[@[Number]]" and gives that cell's value
Function EvaluateString(strTextString As String)
Application.Volatile
EvaluateString = Evaluate(strTextString)
End Function