n-1、n-2是下标吧?通过加一个宏,把n作为参数,调用下面的代码,就可以了。Private Sub getNotNull(n As Integer)
Dim iCol As Integer
iCol = n - 1
Do While Cells(1, iCol).Value = ""
iCol = iCol - 1
If iCol = 0 Then
Exit Do
End If
Loop
If iCol >= 1 Then
Cells(1, n).Value = Cells(1, iCol).Valu