|
本帖最后由 feiyang8878 于 2019-11-21 23:55 编辑
- Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
- If Target.Rows.Count > 1 Then
- Dim arr, i%, arr1
- arr = Range(Target.Offset(0, 2).Address).Resize(Target.Rows.Count, 1)
- arr1 = Application.WorksheetFunction.Transpose(arr)
- Target.Value = Join(arr1, "、")
- End If
- End Sub
复制代码
- Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
- If Not Application.Intersect(Target, Range("c1:c222")) Is Nothing Then Cancel = True
- End Sub
复制代码
|
|