- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¥»©«³Ì«á¥Ñ GBKEE ©ó 2011-11-2 07:29 ½s¿è
¦^´_ 1# Helain - Private Sub Workbook_Open() 'ThisWorkbook ªºµ{§Ç Àɮ׶}±Ò®É¦Û°Ê°õ¦æ
- Ex
- End Sub
- Private Sub Ex() 'ThisWorkbook ªºµ{§Ç
- With Sheet1
- .Names.Add "table1", .Range(.[C6], .[C6].End(xlToRight).End(xlDown)) '©w¸q¦WºÙ
- .Names.Add "table2", .Range(.[C14], .[C14].End(xlToRight).End(xlDown)) '©w¸q¦WºÙ
- End With
- End Sub
½Æ»s¥N½X- Private Sub Worksheet_SelectionChange(ByVal Target As Range) '¤u§@ªí1ªºµ{§Ç
- Dim R As Double, C As Double
- If Intersect(Target, [table1]) Is Nothing Then Exit Sub
- R = Target.Row - [table1].Cells(1).Row + 1
- C = Target.Column - [table1].Cells(1).Column + 1
- MsgBox "¿ï¨ú" & Target(1).Address(0, 0) & " ¹ïÀ³ " & [table2].Cells(R, C).Address(0, 0)
- End Sub
½Æ»s¥N½X |
|