This seems like it should be simple to execute, but for the life of me I cannot find the proper command or trick.

In my macro, I systematically generate a Range of Rows using Union between the Range and the new row in a loop:

```
Set DesiredRange = Union(DesiredRange, ActiveSheet.Cells(Val(ParsedText(Count)), 1).EntireRow)

```

However, in order for this union to work, I must first Set the `DesiredRange` equal to some range so that the Union does not error out.

The trouble I am having is that there are certain row numbers that I need to disclude, but the rows are chosen from a userform textbox that allows the user to input whatever they wish (I've coded in error control so that the values passed are valid), so they can hypothetically make the first value (and thus the one I am using to initialize the range) a discluded row.

I am hoping someone here can have a solution that allows me to complete all the operations and then remove this first added row from the range if it is within the discluded category (rows 1 through 7). If not, I think I may have a work around (but part of me is asking this question more for education than solving the problem)

Thanks!