Are all cells in the column empty
I want code that checks whether all cells in a specified column are empty. I currently do it by looping and checking each cell individually, but this is very slow, so I'm looking for a more efficient solution.
The main problem seems to be that Column doesn't have a Range property.
Any ideas for a workaround? Thanks in advance.
|