Forum Discussion
JoeCavasin
Jul 30, 2023Brass Contributor
Excel VBA - Define Range of rows from known static range as start to flexible range address as end
Need help with an Excel VBA process. Below is a screenshot of the current logic with the intended goal noted in the red box. Can someone assist with helping me set criteria to define the range or r...
HansVogelaar
Jul 30, 2023MVP
That could be
WSN.Range("A11:A" & RowEnd - 1).EntireRow.Select
Do you really need to select those rows? For example, if you want to delete them, you can use
WSN.Range("A11:A" & RowEnd - 1).EntireRow.Delete