Question

VBa 用变量表示单元格的方法

Dim l As Long
l = Cells(Rows.Count, 1).End(xlUp).Row
Dim e As Variant
For Each e In [e1:e("l")]
If e.Value = " " Then e.Value = "你好"
这段代码想实现的功能是先判断最后一行，然后判断某一列中为空值的单元格，然后填入一个值，现在问题是如何表示 [e1:e("l")]这个区域呢？

Answer 1

Dim l%
l = Cells(Rows.Count, 5).End(xlUp).Row
Dim e As Range
For Each e In Range("e1:e" & l)
If e = "" Then e.Value = "你好"
Next