I am using the counta function to count how many cells have data in them but blank cells are being counted. If I manually do "clear contents" on any of the cells then they are not counted. This is a large spreadsheet so I'm looking for a faster way to do a global "clear contents". Any suggestions?
You could try http://dmcritchie.mvps.org/excel/join.htm#trimall
HTH
Regards, Jeff
Thanks Jeff but, ugghh, I'm having challenges following this. I am not super knowledgeable in macros so this one is bit above my head. Do you have any other solutions?
Thanks!
Without manually clearing those fields, a macro is required.
Does this help?
Paste code in a Normal module
- Where to paste code
- Highlight macro to copy >> Ctrl + C >> Open your workbook
- Alt + F11 >> opens the Visual Basic Editor (VBE)
- Ctrl + R >>opens the Project Explorer (if not already open on left side of screen)
- Insert menu >> Module or Alt + I, M >> activates the Insert menu and inserts a Standard Module
- Paste code >> Ctrl + V (right side of screen)
- Alt + Q >> exits VBE and returns to Excel
- Back in Excel >> Alt + F8 >> Macro Dialog Box >> Highlight macro >> Run
If this does not help, would you like to post the workbook and what you want to achieve?
Please Login or Register to view this content.
Let's assume cell A1 is one of these blank cells that's being counted.
Try to find out what's in the cell. In an empty cell enter this formula:
=CODE(A1)
What result do you get?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks - the macro worked!
You are very welcome and thanks for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks