- Sub t1()
- Range("C1:C19").SpecialCells(xlCellTypeBlanks) = "."
- End Sub
方法二,判断是否空值,是就等于"."
- Sub t2()
- Dim arr, i
- arr = Range("C1:C19")
- For i = 1 To UBound(arr)
- If Len(arr(i, 1)) = 0 Then arr(i, 1) = "."
- Next
- Range("C1:C19") = arr
- End Sub