Excel有多個工作表，於不同工作表的同一儲存格A1輸入PV001 其後的工作表同一儲存格為連續數字，工作表2的A1儲存格為PV002，工作表3的A1儲存格為PV003, 請問如果用巨集，VBA公式是？我不想逐個工作表改！謝謝！?
回答 (2)
2019-02-27 5:50 pm
Sheet2!A1=PV&TEXT(RIGHT(Sheet1!A1,3)+1,"000")
Sheet3!A1=PV&TEXT(RIGHT(Sheet2!A1,3)+1,"000")
以此類推
Sheet3!A1=PV&TEXT(RIGHT(Sheet2!A1,3)+1,"000")
以此類推
2019-02-25 4:40 pm
For i = 1 To Sheets.Count
Sheets(i).Cells(1, 1) = "AP" & Format(i, "000")
Next
Sheets(i).Cells(1, 1) = "AP" & Format(i, "000")
Next
收錄日期: 2021-05-03 06:49:39
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20190224114043AAFMnCe