Select Range Until First Empty Row And Column

[dirk1965]

I'm looking for some assistance in being able to automatically select a range based on when the first empty row and first empty column are detected. I've read up on Range.End, but that seems like its detecting for the very last row/column which doesn't account for an empty row or column in the middle of a data set. I would like to detect the very first fully empty row and column.

Thanks

 

[dirk1965]

Just change the name of your sub to, for example, BlueRange. "Range" is a reserved word in VBA.

That worked great! Thanks for the help!

 

[Tetra201]

You are welcome.

By the way, thank you for correcting my typo