Selecting a range
Posted on 2014-12-12
I would like to select all cells to put in a For Selection loop. How do I start in cell C2 and search down for the first non blank cell and select everything in that range. I have an issue when there is only one value and it is in C2, xlDown selects all the way down to line 1048576. How can I select the range so it picks the range, even when there is only one cell there to select in the range? I have seem some solutions that use xlUp? but I need it to select the range beginning in cell C2, so the header is left out. Yes it is a list and there is no cell that are blank in-between. Please advise and thanks.