Query is this.

I have a number of cells that may or may not have content.
I have a second worksheet where i need to insert lines based on the number of cells with contents mentioned above.

Range(“”).cells.count gives me the total number of cells in the range, which is almost what i want.

rows.insert does the second part

Is there a way of saying usedrange(“”).cells.count, that works?

I could use brute force and simply do a if null else approach as it is only 25 cells, but doesn’t strike me as very neat and i would hope that a better method exists.

CountA() is what you are after I think

Thanks, works perfectly.