• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel VBA help to ensure all corresponding Cells have been Filled

R

raginkp

New Member
Hi,


I haven an excel file, where I need to ensure that all columns are filled.


imagine I have 10 column and I have entered the data till 100 rows(But is not fixed, you can enter as much as you want). Here I need to ensure that no cells are left as blank and he should not be able to close the file with out entering the data in all field.
 
Raginkp


Firstly, Welcome to the Chandoo.org Forums


What about a simple cell somewhere with

=IF(COUNTA(A2:CV101)<10000,"Incomplete","Ok")
 
You must log in or register to reply here.
Back
Top