Hi,
I have a dynamic range that changes fairly frequently. When it changes, it adds a new row at the bottom and resizes itself. I cannot figure out how to select this new row. I need to select it and type in a new person's name into the new cell. Despite several attempts, I cannot figure out how to select the last row. I cannot use the End(xlUp) or End(xlDown) functions because it goes all the way down to the end of the column instead of the few cells that are part of the range. (All of the ranges on my worksheet are adjacent). I know this is pretty simple, yet I cannot figure it out. Here is my code so far. Thanks for your help!
Bookmarks