¥i¥H±N¹B¦Û¥X¨ÓªºÈµ¹RANGE(),·í¤Þ¼Æ¶Ü?
- ©«¤l
- 199
- ¥DÃD
- 45
- ºëµØ
- 0
- ¿n¤À
- 252
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7 (X64)
- ³nÅ骩¥»
- office 2010 (x64)
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2010-12-24
- ³Ì«áµn¿ý
- 2020-3-31
|
¥i¥H±N¹B¦Û¥X¨ÓªºÈµ¹RANGE(),·í¤Þ¼Æ¶Ü?
¦p:Dim str_ran as string,Y¹Bºâ«á str_ran ="A:1040"¨º»ò³o¼Ëªº«ü©w¥i¥H¦¨¥ß¶Ü? RANGE(STR_RAN)? |
|
V98
|
|
|
|
|
- ©«¤l
- 128
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- Office2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥|¤t¦¨³£ÊT崃
- µù¥U®É¶¡
- 2010-9-13
- ³Ì«áµn¿ý
- 2017-5-12
|
两Ïú±¡况¤U¥i¥H¦¨¥ß:
1.¨Ï¥Î¦W称:
°²设¤u§@ï¦s¦b¦W称"AAA",则¤U¦C¥N码¦¨¥ß:
Sub test1()
Dim str_ran As String
str_ran = "AAA"
MsgBox Range(str_ran).Address
End Sub
2.¨Ï¥Î单¤¸®æS围:
Sub test2()
Dim str_ran As String
str_ran = "a1:c300"
MsgBox Range(str_ran).Address
End Sub
§A©Ò说ªº"A:1040"¬J¤£¯à§@为¦W称(¦]为¥¦¤£²Å¦X¦W称ªº©R¦W规则),¤S¤£¯àªí¥Ü¥X单¤¸®æªºS围. |
|
|
|
|
|
|
- ©«¤l
- 199
- ¥DÃD
- 45
- ºëµØ
- 0
- ¿n¤À
- 252
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7 (X64)
- ³nÅ骩¥»
- office 2010 (x64)
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2010-12-24
- ³Ì«áµn¿ý
- 2020-3-31
|
et5323¤j¤j¦pªG¦p¤U¤ù¬q,
rows_count = Range("A1").CurrentRegion.Rows.Count
str_rows_count = "1:" + Str(rows_count)
Rows(str_rows_count).RowHeight = 19.2
·|¶]¤£¤U¥h,¦]¬°·|¥X²{¦p¤Uªº¿ù»~°T®§"«¬ºA¤£¦X",rowS_count = 1040
str_rows_count = "1:1040"
¦pªG§ï¦¨³o¼Ë´N¥i¥H¶]:rows("1:1040"),rows()¤£±µ¨üÅܼƤ޼ƥG?
ÁÂÁ«ü¾É!! |
|
V98
|
|
|
|
|
- ©«¤l
- 199
- ¥DÃD
- 45
- ºëµØ
- 0
- ¿n¤À
- 252
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7 (X64)
- ³nÅ骩¥»
- office 2010 (x64)
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2010-12-24
- ³Ì«áµn¿ý
- 2020-3-31
|
ÁÂÁ GBKEE ª©¥D,+ ©M & ®t§O¦b³o¸Ì°Ú!, |
|
V98
|
|
|
|
|
- ©«¤l
- 199
- ¥DÃD
- 45
- ºëµØ
- 0
- ¿n¤À
- 252
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7 (X64)
- ³nÅ骩¥»
- office 2010 (x64)
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2010-12-24
- ³Ì«áµn¿ý
- 2020-3-31
|
str_rows_count = "1:" + Trim(Str(rows_count)) ³o¼Ë¤]¥i¥H,+¸¹·|¦h²£¥Í¤@ӪťÕ,ÁÂÁ GBKEE ª©¥D. |
|
V98
|
|
|
|
|
- ©«¤l
- 62
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 253
- ÂI¦W
- 0
- §@·~¨t²Î
- xp , win7
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¤H¤ß
- µù¥U®É¶¡
- 2010-5-21
- ³Ì«áµn¿ý
- 2012-8-3
|
+ ¸ò & ªº¥Îªk ¡A³Ì¦n¬O°Ï¤À¶}¨Ó¡A§Kªº·d¶Ã±¼(ÁöµM¦n¹³+ ¸ò& ¤@¼Ë)
¼ÆȥΠ+
¤å¦r¥Î & |
|
¬O¾Çµ{¦¡¦Ó¤£¬Onµ{¦¡¡A¬O¶i¨Bªº°ò¦
|
|
|
|
|
- ©«¤l
- 199
- ¥DÃD
- 45
- ºëµØ
- 0
- ¿n¤À
- 252
- ÂI¦W
- 0
- §@·~¨t²Î
- windows 7 (X64)
- ³nÅ骩¥»
- office 2010 (x64)
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2010-12-24
- ³Ì«áµn¿ý
- 2020-3-31
|
ÁÂÁÂ!! ¥H«e¼gªºµ{¦¡¥Î + ©Ò¥H³e¥Î,¦ý¬O·t¶Â¿ôªº¬O! |
|
V98
|
|
|
|
|