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

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

®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

¦^´_ 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

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

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

test.rar (17.16 KB)

¦^´_ 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

ÁÂÁÂ G ¤j
^0^

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD