Select a dynamic range of cells

2019-09-05 07:03发布

I'm trying to record a macro that will select a range of cells where the first cell (A3) is consistent, but the last cell changes from sheet to sheet. I started by recording a macro with the ending cell already selected, but it doesn't work from sheet to sheet. Any help is appreciated.

1条回答
冷血范
2楼-- · 2019-09-05 08:06

This will select from A3 to the bottom of data in column A:

Sub cutaneous()
    Range(Cells(3, 1), Cells(Rows.Count, 1).End(xlUp)).Select
End Sub
查看更多
登录 后发表回答