Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-19-2017, 03:46 PM
BobBridges's Avatar
BobBridges BobBridges is offline Help with Code Windows 7 64bit Help with Code Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I haven't been back here in a while, AJacLo; I don't know what you mean by "the same values". The same as what? I guess you're referring to a previous thread, but you don't cite it here.

As I read your code, it asks the user to specify a range. It puts in some random cell—the cell that happened to be active when you started the program—a formula counting the number of non-zero values in the range. Then in E2 it puts the number of values (zero or non-zero) in the same range. In F2 it puts the difference between the E2 and D2. If the user started the program while D2 was active, then that third figure shows the number of zero values in the specified range.

Of course I may be misreading it. But to help I still gotta know "the same values as what"?
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Code VBA Code to search for field codes with certain text before the Field code and to change style welcometocandyland Word VBA 4 02-08-2017 06:53 PM
Help with Code QR-code qrcode Word 3 05-26-2015 06:38 AM
Help with Code code to run once only gerrymac Word VBA 6 07-26-2014 12:19 AM
Help with Code Where does my code go? rbaldwin Word VBA 3 03-14-2012 02:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:24 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