VBA单元格引用问题

2025-05-17 01:41:34
推荐回答(2个)
回答1:

把 "ABC.xlsx"改为:thisworkbook.sheets("3").range("Z1") & ".xlsx"

回答2:

activeworkbook.sheets(1).name=actveworkbook.sheets(3).range("Z1")