1、怎么引用过去呢?
2、这个又错在哪里呢?
Set wb = Workbooks.Add
Cells(i, "AA") = Cells(i, x) / ThisWorkbook.Sheets("产量2")!CT5
éè¦æåå®ä¹ï¼æ¯å¦a=thisworkbook.name
å¦å¤Sheets("产é2")!CT5è¿éåºè¯¥æé®é¢ï¼ä¸ç¥éè¿æ¯ä»ä¹ææ
cells(i,x)è¿éçxæ¯åéè¿æ¯xåï¼
ä¿®æ¹å
a=thisworkbook.name
Set wb = Workbooks.Add
Cells(i, "AA") = Cells(i, âxâ) /workbooks(a).Sheets("产é2").cells(5,"CT")
è¯è¯è¡ä¸è¿½é®
å¦å¤Sheets("产é2")!CT5è¿éåºè¯¥æé®é¢ï¼ä¸ç¥éè¿æ¯ä»ä¹ææ
cells(i,x)è¿éçxæ¯åéè¿æ¯xåï¼
ä¿®æ¹å
a=thisworkbook.name
Set wb = Workbooks.Add
Cells(i, "AA") = Cells(i, âxâ) /workbooks(a).Sheets("产é2").cells(5,"CT")
è¯è¯è¡ä¸è¿½é®
è¿æ ·ç®åºæ¥æ¯å¾æ°ï¼æä¹å¯ä»¥å¾å°å ¬å¼å¢
温馨提示:答案为网友推荐,仅供参考