Array Formula In C1, Write =IF(COUNT(FIND(A$1:A$4,B1))>0,"Y","...
我沒測過，你試試看。 Sub test2() Dim bt as Range, r as Long, c as Long Dim wt as W...
Sub test() Dim myRng As Range, i As Long Set myRng = Cells(Rows.Cou...
我用Select...Case做 Sub test() Dim myRng As Range, rng As Range Dim i As Lo...
建議參考這篇鐵人文章https://ithelp.ithome.com.tw/articles/10156881
我會用dateserial()讓VBA自己去計算日期大概是這樣寫 dim date1 as date, date2 as date, i as long, la...
SELECT invoice_id, item, category, name, count(invoice_id) FROM table_a GROUP BY...
Dim datestart as variant, dateend as variant lastrow = ActiveSheet.UsedRange.Ro...
加入這行應該就可以解決了。 Application.CutCopyMode = False
paicheng0111的鐵人檔案