Recent content by N1GHTEYES

Actually, there are more efficient ways of doing it, and I do have some old code knocking around somewhere that I wrote years ago, but it was for a different job, and made some assumptions which are not true in this instance, so it would need some mods. I was just trying to be efficient (lazy)...

Thanks Mint. I begin to suspect that there probably is no way to do this directly via worksheet functions alone. But your code is neat and does the job. And it is easier than coding the whole object (clump) selection & counting process directly. Thank you very much. Ah, I just spotted...

Hi Skip, Yes, =AREAS((A2:B3, A5, B8:B9))returns 3. But what I want is to have a workbook with some data on it, and to be able to change the value in a cell which represents an acceptable threshold for the data. As that threshold changes, the set of cells which are thresholded change. What I...

Hi Skip, The details are not germane, but essentially what I am doing is scoring a 2D dataset based on some criteria (actually it is how well it correlates to another dataset but that really does not matter). I can set a user-defined threshold of score which is considered significant. So for a...

Hi, I am trying to find a quick way of counting the number of contiguously connected sub-ranges, within a larger range, that meet a specified criterion. For example, in the range A1:C10, there may be say, 7 cells with values above some specified threshold, let's say 1 for the sake of argument...

Thanks both, especially Mint. Yes, I had forgotten that count does not work on blank cells. Thank you also for the heads up that later versions automatically make an array formula if it returns an array. I had not realised that.

Hi. In a workbook, I am trying to write a function in a cell which returns the size of the overlap between two specified ranges. I think the range intersection operator is a space, so I want to write something like: = Count($A$1:$E$5 B2:F6), and I expect to get the answer 16 (i.e. the number...

I just realised that the "Save Workspace" feature has been removed in Excel 2013. Does anyone know of a workaround? I was considering writing a macro to: create a new workbook note all open workbooks and the settings, (number of windows, positions, placement etc.) store that data in the...

Whoop-di-do! Now all I've got to do is get the rest of it working. Thanks so much to both of you. I don't think I would have ever got that. >It was introduced at least 20 years ago ... I never claimed to move with the times. I struggle to move with Ex-Lax nowadays...

Thanks strongm. I hadn't realised the was a Getobject inbuilt function nowadays. Good suggestion. Not the problem though. It still does not work. I have slimmed down the code as much as possible. Apart from a simple sub in a standard module to respond to a button press and show the form...

Thanks for that Combo, but it still does not want to work. I have stripped everything down to basics. I have a user form with no controls. Its entire code is copied exactly from what you posted. There is also a standard module with a single sub which shows the user form. That sub is...

OK, I agree with you, the first part of the conditional compilation should be running in both cases. So if the declaration I've written in the first case works equally well for 32 and 64 bit cases, then the code should run the same in both cases. As far as I can see, that should be what ought...

Thanks for the comment combo, but I think I've already addressed that issue as far as I understand it - though I find what those sites say is a little confusing. One minute they seem to say that VBA7 is the prime determinant of the declaration syntax, and the next they say it is the 32/64 bit...

I'm trying to write some code which will allow me to do some simple image analysis, manipulation, and display in Excel. I think I have an issue with version compatibility though. Below is an example of some simple code which demonstrates the problem. It is currently set up (just for debug...

That sounds like yours works just fine. It could be entirely possible that this is just a quirk introduced by some unique screw-up by our IT guys at work. From past experience, they have quite a talent for it. Still, I'd love to hear from anyone else - either with or without the problem...