谢谢pjiang老师的指点!解开了,请见如下:
Sub demo()
Set sht = Sheet2
sht.Columns(1).ClearContents
r = 1
Sheet1.Select
lst = [a1].End(xlDown).Row
For j = 20 To 37
For i = 1 To lst
If Cells(i, j).Interior.Color <> 16777215 Then
sht.Cells(r, 1).Formula = Cells(i, j - 18).Text
r = r + 1
End If
Next
Next
End Sub