- Jul 11, 2007
Hi everyone. This is probably really simple but how do I select only all cells with data? Basically, I have an array with no blanks but the number of rows is a lot. I just want to select all the cells with data in one step. Is there a function or macro that can do this? Any suggestions would be great. Thanks!