| 今日の復習 いつも役にたつ下記コード DIM MY1 AS RANGE WITH ACTIVESHEET.USEDRAGEN.OFFSET(N) SET MY1 = .RESIZE(.ROWS.COUNT - N) END WITH MYR1.AUTOFILTER #ExcelVBA #資格試験 |
| 今日の復習 いつも役にたつ下記コード DIM MY1 AS RANGE WITH ACTIVESHEET.USEDRAGEN.OFFSET(N) SET MY1 = .RESIZE(.ROWS.COUNT - N) END WITH MYR1.AUTOFILTER #ExcelVBA #資格試験 |