Search results for query: *

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

Skip, I hope the retirement is suiting you. It seems like you are far from retired from TT though! As for tables, I've barely used them - to be honest I'm not really clear on what advantages they have. If I need to chart flexible data I usually just set up some dynamically defined, named...

There is no specific task involved, I just find that functionality useful. I find it is the easiest way to adapt and adjust exactly what data to display when , say, trying to decide which sub-set of data is most effective at extracting the required information. The issue though, is not so much...

Recently my version of excel at work has started to have an annoying quirk with chart data highlighting. Normally, in excel, If you create a multi-series XY chart from a simple rectangular data range, for example: X values in cells A2:A5, series labels in cells B1:D1, Y1 values in B2:B5, Y2...

Thanks Skip. It works a treat in '97. Though I had to replace the line: Charts(1).ChartObjects(1).Chart with: Worksheets(1).ChartObjects("Chart 1").Chart because the global charts object was empty - despite having created a chart. It also needed me to name the class "EventClassModule"...

Mintjulep - sorry, it looked like my post was responding to yours, but actually it was in response to Skip's. Yours had not arrived on my screen when I replied. I guess we overlapped. I think it might help if I gave a better example of the kind of thing I'm trying to do. The following is NOT...