I have the attached code and it works to a point. I need to extend the selection range from column A to Column L AFTER the rngSelect is determine. This actually grabs the range of blank cells on the worksheet first, and then I need to grab the columns. I tried making the offset (01,11), but that did not work.

Ok, now I get Object Required on the Set rngSelect = Range(Cells("A2"), Cells(Rows.Count, "A").End(xlDown).Offset(-1, 0)) line. This is getting very frustrating as it works and then does not, so I can't even try the resize as it now does not get past this line.

wabashbdw, I was tring to set the range that had been highligh from Cell A2 to the first non-blank cell in columns A. However, I could not get it to set the range, but this solution is what I am going with.