Hello,
If i have a set of data which changes size, so its in a single column and sometimes there are 30 cells with values sometimes theres more and sometimes less.
I understand i can count the cells with values but is there a way to have a macro select just the cells with values, this will be a single range (there are no gaps in the middle or anything), just varying in length?
I hope this is clear.
Many thanks,
Andrew
If i have a set of data which changes size, so its in a single column and sometimes there are 30 cells with values sometimes theres more and sometimes less.
I understand i can count the cells with values but is there a way to have a macro select just the cells with values, this will be a single range (there are no gaps in the middle or anything), just varying in length?
I hope this is clear.
Many thanks,
Andrew