Search:

Type: Posts; User: wdwells; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.05 seconds.

  1. Elegant bit of code Steve.

    Elegant bit of code Steve.
  2. Replies
    10
    Views
    1,329

    Hello RG I saw an argument some time back...

    Hello RG

    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...
  3. Replies
    7
    Views
    1,807

    Hi Wassim I suspect that you do not wish...

    Hi Wassim

    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...
  4. A cautionary Tale

    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%...
  5. Replies
    4
    Views
    3,873

    Thank you both

    Thank you Jefferson and Andrew

    In another forum, Hans V offered me the following advice which nicely did the trick.
  6. Replies
    4
    Views
    3,873

    Change White to Transparent

    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?

    T.I.A.
  7. What is the situation when attempting to print...

    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?
  8. Thread: AVG PC Tuneup

    by wdwells
    Replies
    2
    Views
    1,275

    Does anyone have any recommendations/experience...

    Does anyone have any recommendations/experience (good or bad) with respect to AVG PC Tuneup?
  9. My daughter has just informed me that my...

    My daughter has just informed me that my great-grandson (age 2 +) has discovered the first name of God.

    .
  10. Replies
    2
    Views
    439

    It was composed in 2003, I believe that Hans has...

    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...
  11. Replies
    2
    Views
    439

    I have always found the UI for Formula Auditing...

    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...
  12. Thread: Excel Add-In

    by wdwells
    Replies
    2
    Views
    578

    Thank you. I will certainly give this a...

    Thank you.

    I will certainly give this a workout,
  13. Replies
    4
    Views
    1,313

    Thank you Jefferson and Retiree

    Thank you Jefferson and Retiree
  14. Thread: Excel Add-In

    by wdwells
    Replies
    2
    Views
    578

    Is there anyway to have an event within the...

    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.
  15. Replies
    4
    Views
    1,313

    FWIW I have been advised to NOT attempt...

    FWIW

    I have been advised to NOT attempt modifying existing menu bar items. They aren't mine to modify.
  16. Replies
    4
    Views
    1,313

    I am thinking of a new Add-In that will require a...

    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.
    ...
  17. Replies
    4
    Views
    856

    Hi Corden Here is a second example using VBA,...

    Hi Corden

    Here is a second example using VBA,

    HTH

    [attachment=90870:Sample_r2.xlsm]
  18. Replies
    4
    Views
    856

    Hello Corden Have you considered using a Pivot...

    Hello Corden

    Have you considered using a Pivot Table/Chart as shown in the attached sample?

    Regards
    Don

    [attachment=90867:Sample_r1.xlsx]
  19. Replies
    22
    Views
    4,294

    I was surprised to find that although your...

    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.
    Go figure....
  20. I think that Corden's request is satisfied with...

    I think that Corden's request is satisfied with the attached.
    [attachment=90859:Test Rev C.xls]
  21. Replies
    22
    Views
    4,294

    Thank you for that Rory. ...

    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?


    varFormulas =...
  22. Replies
    12
    Views
    2,453

    Martin The following modified code will repair...

    Martin

    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
    Dim...
  23. Replies
    12
    Views
    2,453

    Martin The same question has baffled me. I...

    Martin

    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...
  24. Replies
    2
    Views
    517

    Hello Baiju The attached workbook shows 3...

    Hello Baiju

    The attached workbook shows 3 approaches to solving your problem.

    H.T.H.

    [attachment=90853:FY_in_Weeks.xls]
  25. Replies
    12
    Views
    2,453

    If Mr. Gates & Co won't provide, we do it...

    If Mr. Gates & Co won't provide, we do it ourselves. Here is a UDF solution.

    [attachment=90852:Example_r1.xls]
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4