Range("a4:h" & myrow)区域是运行代码得到的数据,有空单元格,必须逐个选定空单元格,按delete键后才能再进行运算,请问如何一次选定所有空单元格?下面代码不对,请指教!谢谢!
Sub 选定空单元格() '清除空单元格
Dim myrow As Integer
myrow = Range("b65536").End(xlUp).Row
ar = Range("a4:h" & myrow)
For i = 1 To UBound(ar)
For j = 1 To UBound(ar, 2)
If Cells(i, j).Value = "" Then
Cells(i, j).ClearContents
End If
Next j, i
End Sub