LinkBack URL
About LinkBacks
Can you modify me the following code? I need to get back a number as many data are in the column under the cell B6 but ignoring the BLANK CELLS and cells which contains FORMULAS.
Please Login or Register to view this content.
Can you modify me the following code? I need to get back a number as many data are in the column under the cell B6 but ignoring the BLANK CELLS and cells which contains FORMULAS.
Please Login or Register to view this content.
Maybe:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Unfortunately it don't give me the correct value. It count the cells with formulas as well.
I found a formula which give me the right value.
Could you implement in VBA code?Please Login or Register to view this content.
The code given cannot, repeat cannot count cells with formulas unless it is changed to xlFormulas. The xlConstants reference restricts the count to cells with flat values in them.
If you think you're experiecing something different I would love to see that workbook and code, as far as I know that is impossible.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks