- ©«¤l
- 163
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 170
- ÂI¦W
- 0
- §@·~¨t²Î
- Window 7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-5
- ³Ì«áµn¿ý
- 2022-7-20
|
¦^´_ 1# missbb
¥H¤U¬O¤gªk·Ò¿ûªºµ²ªG¡G- Sub test()
- For n = 1 To 2
- er = 0
- ec = 0
- With ActiveSheet
- For j = 1 To .UsedRange.Columns.Count
- For i = 1 To .UsedRange.Rows.Count
- If .Cells(i, j).Value <> "" Then
- If i > er Then er = i
- If j > ec Then ec = j
- End If
- Next i
- Next j
- .Rows(er + 1 & ":" & Cells.Rows.Count).Delete
- .Range(Columns(ec + 1), Columns(Cells.Columns.Count)).Delete
- End With
- Next n
- End Sub
½Æ»s¥N½X §O°Ý§Ú¬°¦ón°j圏¨â¦¸¡H³o¬O¦h¤è´ú¸Õµ²ªG(ÁÙ¬O¦³«e½úª¾¹Dì¦]¨Ã§iª¾)¡AY¤£¥Î°j°éªº¸Ü¡A«h³Ì«á¤@¦Cn¥[¤Wµ{¦¡½X¨ÓÃö³¬ÀɮסG
ActiveWorkbook.Close 1
ÃöÀɮתº¥Î·N¬O¸g¹L¦A¶}±Ò¥»Àɮתºµ{§Ç¤~·|¥Í®Ä¡C |
|