用vba怎么实现双击sheet1中的某个单元格跳转到另一个sheet
用vba怎么实现双击sheet1中的某个单元格跳转到另一个sheet
[解决办法]
本帖最后由 bcrun 于 2013-06-15 21:21:08 编辑
Dim R As Range
Set R = Sheet1.Cells(4, 5)
R.Activate
Sub test()
Dim R As Range
Sheet2.Activate
Set R = Sheet2.Cells(4, 5) 'X=1,2,3,4,5
R.Activate
End Sub