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

¤@­Óªí³æ½Ð¨D¨ó§U

¥»©«³Ì«á¥Ñ GBKEE ©ó 2012-2-13 13:16 ½s¿è

¦^´_ 5# ©P¤j°¶
¨t²Îªºªºªí³æ
  1. Sub Ex()
  2.     With ActiveSheet
  3.         .UsedRange.Name = "DATABASE"
  4.         If [DATABASE].Rows.Count = 1 Then [DATABASE].Resize(2).Name = "DATABASE"
  5.         .ShowDataForm
  6.     End With
  7.     Names("DATABASE").Delete
  8. End Sub
½Æ»s¥N½X
ªí³æ.rar (11.41 KB)

TOP

¦^´_ 8# tonycho33
1  ¿ï©w¸ê®Æ½d³ò¤ºªº¥ô¤@Àx¦s®æ
2 «ü¥O:  ¤u¨ã->¸ê®Æ->ªí³æ
3 «ö¤U½T©w
ªí³æ´N¥X²{

TOP

¦^´_ 10# 317
§ÚÁ٧䤣¨ì¦p¦óÅܤj

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD