Get specific column row count within a selected range.
Posted on 2018-02-13
I found the following online and would like to know how to read and edit this. What each of the 1's are? I do already understand that the -1 is to not count headers.
MsgBox Cells(1).CurrentRegion.Columns(1).SpecialCells(xlCellTypeVisible).Count - 1
What column of the CurrentRegion.Columns is this? If I place data in column A it works, but if the data range starts in cell C3, returns zero.
How would I edit this to tell me, what the row count is for a specific columns in a range, no matter where the current selection is? The first column in the range has x , the third column in the range has x.....
This would still be for only visible cells in the preselected range, and not count any blank cells.