宣告一個陣列,把inos.FullName存進去。或者是宣告一個字串變數,把inos.FullName串接進去 dim str as string ... Fo...
打開EXCEL dim ec as object, wb as object set ec = createobject("excel.applic...
方法一 SELECT dat, (SELECT Max(dat) FROM table WHERE dat < A.dat) AS l...
你的狀況應該要在C208寫 =IF(B208="","",INDEX(表2!$1:$1,1,SUM((表2!$C$2:...
我自己比較喜歡用sumifs()函數。它從office 2007開始支援,而且比sumif()函數靈活。在J3寫下=sumifs($G:$G,$F:$F,J$2...
你有試跑過嗎?下面這段應該會發生錯誤。 If ActiveCell.Formula = "=MATCH(Cells(i,2),Worksheets(&...
Sub test() Dim r As Range, i As Integer Set r = Cells(Rows.Count, 1).End(...