Thread: [Solved] Help with Code
View Single Post
 
Old 02-19-2017, 03:46 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit 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