CurrentRegion.Rows.Count HELP !

[Legacy 169354]

Hi,
the below code counts occupied cells , but if I have a formula in that cell then it counts it even though nothing is in it visibly!

Is there anyway to make this count exclude counting the formula in the cell???

RowCount = Worksheets("Data0").Range("A1").CurrentRegion.Rows.Count

Thanks!

 

[AlphaFrog]

Do you only want to check column A for cells with values?

Will any of the formulas create blanks in between values and if yes, to you want to find the last used row with a value or just count rows with values excluding blanks in between.

What is the end result your specifically looking for?