判斷到哪裡結束應該是Excel VBA最常見的操作之一,下面代碼能實作這個功能:
ref:
http://excelvbamacro.com/how-to-find-the-last-row-that-contain-data-in-excel.html
http://excelvbamacro.com/get-position-of-last-column-containing-data-with-excel-vba.html
判斷到哪裡結束應該是Excel VBA最常見的操作之一,下面代碼能實作這個功能:
ref:
http://excelvbamacro.com/how-to-find-the-last-row-that-contain-data-in-excel.html
http://excelvbamacro.com/get-position-of-last-column-containing-data-with-excel-vba.html