How to Count blank Cells till last used row

**BDH-EXC** · 01-04-2013, 10:26 AM

Hi There,

I have been busy with VBA today and i'm making an overview of the resultcodes in a workbook, only the amount of rows vary each day.

Is there a method to count the blank cells in a specific column to the last row instead of getting a number like 64,954?

I need to display the amount of blank cells, i display the number in a different sheet then the data is in.

The sheet with the data is called "DATATABLE" i now have Range("B40").Value = "=COUNTIF(DATATABEL!C[42],"""")" but this gives me every single blank cell until the end, i just need the blank cells till the last row.

Thanks in advance!

Gr. Bas

**Mumps1** · 01-04-2013, 11:01 AM

Try the following code. It assumes that your data is in column A starting in the second row and places the count in B1. You can make the changes to suit your situation.

Please Login or Register  to view this content.

**BDH-EXC** · 01-04-2013, 11:06 AM

Thnx Mumps1,

I will try it right away!

**watersev** · 01-04-2013, 11:14 AM

option, counting in A column

Please Login or Register  to view this content.

**BDH-EXC** · 01-04-2013, 11:17 AM

Well the problem that i have now is that it fills the data in the worksheet it counts in. I need to count in 1 sheet and fill it in the other.

**BDH-EXC** · 01-04-2013, 11:22 AM

watersev, your way also counts the wrong sheet.

I need to count the row's in the sheet "DATATABLE" and then put the data in the "STATUS" sheet.

I have no clue what to do..

Please Login or Register  to view this content.

**Mumps1** · 01-04-2013, 11:22 AM

Change the line:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

**watersev** · 01-04-2013, 11:25 AM

Please Login or Register  to view this content.

**Mumps1** · 01-04-2013, 11:26 AM

Try this:

Please Login or Register  to view this content.

**BDH-EXC** · 01-04-2013, 11:29 AM

Thank you watersev, this line works like a charm!

Mumps1, also thanks for the quick responses!

You guys are the best!!

How to Count blank Cells till last used row

LinkBack

Thread Tools

Rate This Thread

Display

How to Count blank Cells till last used row

Re: How to Count blank Cells till last used row

Re: How to Count blank Cells till last used row

Re: How to Count blank Cells till last used row

Re: How to Count blank Cells till last used row

Re: How to Count blank Cells till last used row

Re: How to Count blank Cells till last used row

Re: How to Count blank Cells till last used row

Re: How to Count blank Cells till last used row

Re: How to Count blank Cells till last used row

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions