vba如何选择最后行连续区域

2025-02-27 10:35:44
推荐回答(3个)
回答1:

Range(Range("E65536").End(xlUp).End(xlUp), Range("B65536").End(xlUp))

回答2:

range("B12",Cells([e65536].End(xlup).row,5)).Select

回答3:

cells(rows.count,1).end(xlup).entirerow.select