|
本帖最后由 yang2739 于 2013-12-19 17:47 编辑
求大神,在线等,问题没看明白在线问。谢谢!
第一列a右边数值为1的单元格对应的标题是2, 就生成a2=1,
b右边的数值为1的单元格对应的标示是1和4,就生成b1=1,b4=1,以此类推。这样说明白了吗?
- Sub test111()
- Dim arr, brr(), i As Long, j As Integer, cnt As Long
- arr = Range("A1:M" & Cells(Rows.Count, 1).End(3).Row).Value
- For i = 2 To UBound(arr)
- For j = 2 To UBound(arr, 2)
- If arr(i, j) = 1 Then
- cnt = cnt + 1
- ReDim Preserve brr(1 To cnt)
- brr(cnt) = arr(i, 1) & arr(1, j) & "=1"
- End If
- Next
- Next
- Range("O2").Resize(cnt) = Application.Transpose(brr)
- End Sub
复制代码
|
|