Excel VBA - Define Range of rows from known static range as start to flexible range address as end

Brass Contributor

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 rows between a static row (11 - aka RowStart) and one above a flexible end row, with the end row being determined by a cell match?

Copy of file attached as well.  Mod in question is "ModCreateNewUserTEST".  All other Mods are working as intended and do not need changes.

JoeCavasin_0-1690722489784.png

 

1 Reply

@JoeCavasin 

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