¦p¦ó§Q¥ÎVBA¨Ó¹F¨ì "³sµ²" ®ÄªG?
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¥»©«³Ì«á¥Ñ ML089 ©ó 2016-1-23 23:51 ½s¿è
¦^´_ 6# RCRG - 'VBAµ{¦¡©ñ¦b ¨Ï¥ÎÀÉ.XLS¤¤ ThisWorkbook
- Private Sub Workbook_Open()
- xF = "'C:\Documents and Settings\®à±\§Q¥ÎVBA§ó·s³sµ²\קï¸ê®Æ§¨\[קïÀÉ.xls]¤u§@ªíA'!R1C1:R999C7"
- Workbooks("¨Ï¥ÎÀÉ.xls").Worksheets("¤u§@ªía").Range("A1:G999").FormulaArray = "=if(" & xF & "="""",""""," & xF & ")"
- End Sub
½Æ»s¥N½X |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 9# RCRG
R1C1:R999C7
R1:²Ä1¦C
C1:²Ä1Äæ
µ¥©ó A1
R999:²Ä999¦C
C7:²Ä7Äæ
µ¥©ó G999
U1:CC300 = R1C21:R300C81
COLUMN(U1)=21
COLUMN(CC300)=81 |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 8# RCRG
³o¼Ë¤~¯à¤£¶} "קïÀÉ" ¡A"¨Ï¥ÎÀÉ"¤S¯à¦P¨B§ó·s |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 12# RCRG
§Ú´ú¸ÕÀ³¸Ó¨S¦³°ÝÃD
¥ý¶ÇÀɮפW¨Ó¬Ý¬Ý |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|