ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Counting cells with data in them (https://www.excelbanter.com/excel-programming/311060-counting-cells-data-them.html)

tony

Counting cells with data in them
 
Sorry if this post came up twice. I would like to know how to do a count
function on a selection of cells. My sheet has been filtered on this column
and then the following lines are used.

Range("d1").Select
Range(Selection, Selection.End(xlDown)).Select
sectornum = Selection.Count

This selects all the cells down to the last cell that has data in it but
then the variable is set to the total amount of cells selected. All I want to
know is how many cells have something in them. Thank you!


All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com