excel vb macro - Row Count Filter

[NarutoFanatic]

Hi, I need help. i'm having trouble with selecting the row counts using the vb macro. I need to select the row count of records with a given criteria in one column in excel. I've tried using filter criteria but somehow i got the total row counts including the hidden rows filtered by the criteria.

Sample SQL:
Select Count(*) From Sheet1 Where Column1 = 'Resident'

Somehow i can't make this simple code in VB... Could we use a criteria in row count like the above sql code.

[Killer42]

You might try this thread and see whether it helps. It's about selecting the visible cells. Once you do so, there should be a count available.

[NarutoFanatic]

Thanks for the help. Now I have a new problem hehe.. I need to select just the content of one column after filtered. Is there a way to change the selected to be limited to a certain column?

[Killer42]

Thanks for the help. Now I have a new problem hehe.. I need to select just the content of one column after filtered. Is there a way to change the selected to be limited to a certain column?

Shouldn't be too hard, I think.

I'm no expert in the Excel arena, but I believe that where the sample code says...

Selection.SpecialCells(xlCellTypeVisible).Select

in place of Selection you can probably use any range object. In other words, it could easily refer to a column. I can't recall right now how you refer to a column, though. I'd guess something along the lines of ActiveSheet.Range("C:C").