Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by N1GHTEYES

  1. N1GHTEYES

    Count areas within a range

    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)...
  2. N1GHTEYES

    Count areas within a range

    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...
  3. N1GHTEYES

    Count areas within a range

    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...
  4. N1GHTEYES

    Count areas within a range

    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...
  5. N1GHTEYES

    Count areas within a range

    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...
  6. N1GHTEYES

    Count range overlap cells

    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.
  7. N1GHTEYES

    Count range overlap cells

    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...
  8. N1GHTEYES

    Save Workspace - workaround for 2013?

    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...
  9. N1GHTEYES

    Problem with Getobject in excel 2013, 64 bit version

    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...
  10. N1GHTEYES

    Problem with Getobject in excel 2013, 64 bit version

    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...
  11. N1GHTEYES

    Problem with Getobject in excel 2013, 64 bit version

    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...
  12. N1GHTEYES

    Problem with Getobject in excel 2013, 64 bit version

    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...
  13. N1GHTEYES

    Problem with Getobject in excel 2013, 64 bit version

    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...
  14. N1GHTEYES

    Problem with Getobject in excel 2013, 64 bit version

    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...
  15. N1GHTEYES

    Chart data source outline disappears

    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...
See more

Part and Inventory Search

Back
Top