Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #11   Report Post  
Old December 31st 20, 09:46 AM
Junior Member
 
First recorded activity by ExcelBanter: Dec 2020
Posts: 26
Default Try this:

Blank is an often confusing term with regard to Excel and here I've taken
you literally i.e. nothing on the cell, totally empty.

Call with

=countblanks()

Function countblanks()
For x = ActiveCell.Row - 1 To 1 Step -1
If Cells(x, ActiveCell.Column).Formula = vbNullString Then
countblanks = countblanks + 1
Else
Exit Function
End If
Next
End Function

Regards,
Jerry

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to count#cells w/= value in other column and not count blank c aganoe Excel Worksheet Functions 4 April 9th 10 11:36 AM
count blank cells to next value Malika Excel Discussion (Misc queries) 7 March 29th 10 04:36 PM
Count from Blank & Non-Blank Cells Mandeep Dhami Excel Discussion (Misc queries) 4 February 12th 08 04:25 PM
Count the non blank cells vijaydsk1970 Excel Worksheet Functions 3 November 10th 06 01:04 PM
Count the non blank cells vijaydsk1970 Excel Worksheet Functions 1 November 9th 06 03:25 PM


All times are GMT +1. The time now is 07:46 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017