Elegant bit of code Steve.
Type: Posts; User: wdwells; Keyword(s):
Elegant bit of code Steve.
I saw an argument some time back professing that if not dealing with whole numbers, there was no advantage to using single over double when declaring a number. Do you have any thoughts...
I suspect that you do not wish numbers repeated within the range of interest. I suspect that the solutions shown to date will allow this situation if the user enters anything but the...
Be cautious; the first sixty days in the Excel calendar are in error. Lotus123 mistakenly calculated that the year 1900 was a leap year. When Excel first launched, they advertised 100%...
Thank you Jefferson and Andrew
In another forum, Hans V offered me the following advice which nicely did the trick.
I have a png file in grayscale. I would like to change all of the whitish areas to transparent, allowing me to overlay it on another image. Any ideas?
What is the situation when attempting to print the blank worksheet immediately after launching Excel?
Do you have a problem when printing a Word document?
Does anyone have any recommendations/experience (good or bad) with respect to AVG PC Tuneup?
My daughter has just informed me that my great-grandson (age 2 +) has discovered the first name of God.
It was composed in 2003, I believe that Hans has run it in 2007. It should work in all versions. http://windowssecrets.com/forums/images/smilies/unsure.gif...
I have always found the UI for Formula Auditing to be too mouse intensive. The attached Add-In (Selective_Auditing.xla), is my humble attempt to improve the situation. When attached, it will add the...
I will certainly give this a workout,
Thank you Jefferson and Retiree
Is there anyway to have an event within the active workbook fire the associated procedure in an Add-In? This needs to happen without any code within the active workbook being used.
I have been advised to NOT attempt modifying existing menu bar items. They aren't mine to modify.
I am thinking of a new Add-In that will require a pop-up with subordinate pop-ups and command buttons to be placed in one of the existing menu bar menus at the second or third subordinate level.
Here is a second example using VBA,
Have you considered using a Pivot Table/Chart as shown in the attached sample?
I was surprised to find that although your preferred approach appears to be taking an extra step; it consistently runs 2% faster than the shorter version which I identified.
I think that Corden's request is satisfied with the attached.
[attachment=90859:Test Rev C.xls]
Thank you for that Rory. http://windowssecrets.com/forums/images/smilies/cheers.gif
Is there any advantage to either of the following snippets over the other?
The following modified code will repair that.
Function SubTotalIf(rngRange As Range, crit As Variant, rngVal As Range)
Dim Subt As Double
Dim rcell As Range
Dim vcell As Range
The same question has baffled me. I suspect that it is a consequence of my entering the formula (poorly typed), prior to generating the function. However I am not certain of my sequence...
The attached workbook shows 3 approaches to solving your problem.
If Mr. Gates & Co won't provide, we do it ourselves. Here is a UDF solution.