Macro needed to select an "incomplete" range
Posted by Jennifer Johnson on November 04, 2001 5:56 AM
I work with a range of cells that varies each day (maybe A1 to D500 one day, and A1 to F475 the next day, etc). I have figured out how to select the range if all the cells in the range are occupied, but sometimes even that is not the case. For example, if my range today is from A1 to D500, sometimes cell D500 is empty (but A500, B500, and C500 have data in them). Or maybe A1 is blank or any other random cell in the range is blank. I just need a macro to select the entire range even if one of the cells within the range is empty, especially if it is a "corner cell" like D500 or A1, keeping in mind that the range is slightly different every day. Can this be done? Thank you if anyone can help me.
~ Jennifer J