VBA ¤¤·j´MÄæ¦ìªº¼Æ¦r Âà´«¬°Äæ¦ì
- ©«¤l
- 8
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 12
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2012-4-7
- ³Ì«áµn¿ý
- 2017-8-5
|
VBA ¤¤·j´MÄæ¦ìªº¼Æ¦r Âà´«¬°Äæ¦ì
½Ð°Ý¤@¤U
¨Ï¥ÎVBA¤¤ªº
Set C = Rows("1:1").Find(da, LookAt:=xlWhole)
If Not C Is Nothing Then
Y1 = C.Column ' ¤é´Á¦ì¸m
±o¨ì¤@Ó·j´M¼Æ¦r
½Ð°Ý¦p¦ó±N Y1 ªº¼Æ¦rÂର Äæ¦ìÈ
¨Ò¦p
1=A
2=B
3=C
27=A1 |
|
|
|
|
|
|
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ 1# stran
Y1 = C.address(0,0) 'Cªº¦ì¸m
©Î
Y1 = Split(C.address,"$")(1) 'CªºÄæ¦ì¦r¥À |
|
|
|
|
|
|
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ 2# stillfish00
Y1 ªº¼Æ¦rÂର Äæ¦ìÈ , ¦P²z
=Split(Cells(1,Y1).address,"$")(1)
PS: 27¬OÄæ¦ìAA |
|
|
|
|
|
|
- ©«¤l
- 8
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 12
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2012-4-7
- ³Ì«áµn¿ý
- 2017-8-5
|
¦^´_ 2# stillfish00
·PÁ±z
¥t¥~½Ð°Ý ¦p¥i¥H¦¬´M¨ìªºÄæ¦ì -1 Äæ¦ì
¨Ò¦p¸ê®Æ¬° AB
¦p¦ó-1 °h¤@Äæ ¬° AA |
|
|
|
|
|
|
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ stillfish00
·PÁ±z
¥t¥~½Ð°Ý ¦p¥i¥H¦¬´M¨ìªºÄæ¦ì -1 Äæ¦ì
¨Ò¦p¸ê®Æ¬° AB
¦p¦ó-1 °h¤@ ...
stran µoªí©ó 2012-12-28 16:21
¦pªG¸ê®Æ¬°¤£¦bAÄæ
¥i¥Î
= Split(C.Offset(0,-1).address,"$")(1)
»yªk
¹Bºâ¦¡.Offset(RowOffset, ColumnOffset)
RowOffset ¥¿Èªí¥Ü¦V¤U¦ì²¾¡AtȪí¥Ü¦V¤W¦ì²¾
ColumnOffset ¥¿Èªí¥Ü¦V¥k¦ì²¾¡AtȪí¥Ü¦V¥ª¦ì²¾ |
|
|
|
|
|
|