ä¸æ¯ç´æ¥å¼ç¨ï¼ä¾å¦ï¼å¨åå æ ¼C1ä¸è®¡ç®A1+B1ï¼å¨excelä¸å¸¸è§æä½å°±æ¯C1è¾å ¥å ¬å¼ï¼=A1+B1ï¼èå¨vbaä¸å½å ¥ä»£ç [c1]="=a1+b1",æææ¯å°"=a1+b1"èµå¼ç»c1åå æ ¼
äºæ¯è°ç¨å·¥ä½è¡¨å½æ°ï¼æ¯å¦ï¼è°ç¨sumå½æ°ã[c1] = WorksheetFunction.Sum([a1:b1])
ä¸æ¯è°ç¨vbaå½æ°ï¼æ¯å¦ï¼è°ç¨leftå½æ°ã[c1] = VBA.Left([a1], 1)