在excel表格中空单元格怎么填充

1.excel中如果有空的单元格,则自动填充上一单元格的内容

真是太简单了

Private Sub CommandButton1_Click()

Dim M As Integer, N As Integer

M = InputBox（"请输入你要计算到第几行M= (M>1)")

N = InputBox（"请输入你要计算到第几列N="）

For i = 2 To M

For j = 1 To N

If Cells(i, j).Value = "" Then Cells(i, j).Value = Cells(i - 1, j).Value

Next

Next

End Sub