Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-15-2024, 03:34 PM
DavidPaul DavidPaul is offline Are all cells in the column empty Windows 11 Are all cells in the column empty Office 2013
Novice
Are all cells in the column empty
 
Join Date: Oct 2023
Posts: 9
DavidPaul is on a distinguished road
Default Are all cells in the column empty

I want code that checks whether all cells in a specified column are empty. I currently do it by looping and checking each cell individually, but this is very slow, so I'm looking for a more efficient solution.



The main problem seems to be that Column doesn't have a Range property.

Any ideas for a workaround? Thanks in advance.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Are all cells in the column empty Calculate average in a column, but ignore empty cells? alnonymous Word 1 08-09-2022 07:46 PM
If a2 is not empty, color empty cells in b2:af2 turkanet Excel 2 08-20-2017 11:00 PM
Apparently empty (blank) cells aren't empty daymaker Excel 3 03-08-2012 03:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft