| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting cells in a macro
Call the COUNTA worksheet function.
sectornum = Application.WorksheetFunction.CountA(Selection) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tony" wrote in message ... If I have a group of cells selected and all I want to know is the number of cells that actually have data in them. How would I count them and set that to a variable? My worksheet has been filtered for non-blanks on this column, so when I use the following lines Range("d1").Select Range(Selection, Selection.End(xlDown)).Select sectornum = Selection.Count it selects all the cells down to the last one that has data in it, but then it returns the total number of cells selected. All I want to know is how many cells in this column have data in them, not a count that includes the blank ones. Thanks for the help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting cells in a macro
Thank you Chip that worked great...having issues with the site updating so
again i am sorry for the double post. "Chip Pearson" wrote: Call the COUNTA worksheet function. sectornum = Application.WorksheetFunction.CountA(Selection) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tony" wrote in message ... If I have a group of cells selected and all I want to know is the number of cells that actually have data in them. How would I count them and set that to a variable? My worksheet has been filtered for non-blanks on this column, so when I use the following lines Range("d1").Select Range(Selection, Selection.End(xlDown)).Select sectornum = Selection.Count it selects all the cells down to the last one that has data in it, but then it returns the total number of cells selected. All I want to know is how many cells in this column have data in them, not a count that includes the blank ones. Thanks for the help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the number of cells between 2 seperate cells | Excel Discussion (Misc queries) | |||
| counting cells that are 0 in a range of non-contiguous cells | Excel Worksheet Functions | |||
| Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) | |||
| Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Linear Mode
