¦bVBA¤¤¡A¦p¦ó¨Ï¥Î¥¨¶°ÁôÂó¡¥÷Äæ¦ì
- ©«¤l
- 1429
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 1453
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Excel 2010 & 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2020-7-15
- ³Ì«áµn¿ý
- 2024-5-18
|
|
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y
|
|
|
|
|
- ©«¤l
- 1429
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 1453
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Excel 2010 & 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2020-7-15
- ³Ì«áµn¿ý
- 2024-5-18
|
|
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y
|
|
|
|
|
- ©«¤l
- 1429
- ¥DÃD
- 40
- ºëµØ
- 0
- ¿n¤À
- 1453
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Excel 2010 & 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2020-7-15
- ³Ì«áµn¿ý
- 2024-5-18
|
¦^´_ 7# aassddff736
Sub Hidden()
Dim Brr, A, B
A = InputBox("½Ð¿é¤J¶}©lrow"): V = Val(A)
If StrPtr(A) = 0 Or V = 0 Then MsgBox "¸ê®Æ¦³»~" : Exit Sub
B = InputBox("½Ð¿é¤Jµ²§ôrow"): V = Val(B)
If StrPtr(B) = 0 Or V = 0 Then MsgBox "¸ê®Æ¦³»~": Exit Sub
Worksheets(1).Rows((A) & ":" & (B)).Select
Selection.EntireRow.Hidden = True
End Sub |
|
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y
|
|
|
|
|