ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ½Ð°Ý¦Û°Ê½Õ¾ãÀx¦s®æ¤j¤pªº vba ¦p¦ó¤U ÁÂÁÂ

[µo°Ý] ½Ð°Ý¦Û°Ê½Õ¾ãÀx¦s®æ¤j¤pªº vba ¦p¦ó¤U ÁÂÁÂ

½Ð°Ý¦Û°Ê½Õ¾ãÀx¦s®æ¤j¤pªº vba ¦p¦ó¤U
¤~¤£·| ########
ÁÂÁÂ

test.rar (17.16 KB)

ÁÂÁÂ G ¤j
^0^

TOP

¦^´_ 1# wufonna
  1. With ¤u§@ªí1
  2.         .Rows("1:12").Delete
  3.         .Rows("18:34").Delete
  4.         .Cells.EntireColumn.AutoFit
  5.     End With
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 1# wufonna
½Ð¸Ô¬Ý VBAªºRange»PCells»¡©ú
  1. 'Office 2010 ªº Columns.Count =16384
  2. Debug.Print ¤u§@ªí2.Range("A" & ¤u§@ªí2.Columns.Count).End(xlToLeft).Column
  3. MsgBox ¤u§@ªí2.Range("A" & ¤u§@ªí2.Columns.Count).Address
  4. Debug.Print ¤u§@ªí2.Cells(1, Columns.Count).End(xlToLeft).Column
  5. MsgBox ¤u§@ªí2.Cells(1, Columns.Count).Address
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

®w¦s¿é¤J­pºâ µo°ÝµLªk¤W¸üÀÉ®×

¥»©«³Ì«á¥Ñ GBKEE ©ó 2013-9-9 06:20 ½s¿è

½Ð°Ý¥i¥H¥ÎRangeªí¥Ü¶Ü¡A¬°¤°»ò´ú¸Õµª
¤@­Ó¬O 1 ¤@­Ó¬O 7

Debug.Print ¤u§@ªí2.Range("A" & ¤u§@ªí2.Columns.Count).End(xlToLeft).Column
Debug.Print ¤u§@ªí2.Cells(1, Columns.Count).End(xlToLeft).Column

RangeEnd.rar (274.07 KB)

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD