CurrentRegion.Rows.Count HELP !

L

Legacy 169354

Guest
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!
:)
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,277
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,987
Messages
5,526,068
Members
409,685
Latest member
Davetom

This Week's Hot Topics

Top