I'm trying to set a range equal to the nonblank cells within range I81 and I111 (number of no blanks changes). Cells with data in are always at the top of the range with no blanks separating.
At the moment I am setting the range by manually altering the last cell in the range any ideas how to achieve this automatically greatly apreciated.
At the moment I am setting the range by manually altering the last cell in the range any ideas how to achieve this automatically greatly apreciated.

Rich (BB code):
Set rSrc = Range("l80:(last non blank cell up to l111)")