Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    7
    Views
    89

    As an alternate to Zeddys code, you could use...

    As an alternate to Zeddys code, you could use unclehewie" code with a few modifications, You do not want to remove all formatting such as bold. As I understand it that you want to remove just the...
  2. Here is some code from Microsoft's web site that...

    Here is some code from Microsoft's web site that I modified from a function to a subroutine and added the capability of copying a selection of cells and appending into one value ready for pasting. I...
  3. Antediluvian, A real dirty but easy way to do...

    Antediluvian,

    A real dirty but easy way to do this is to send the copied text to a cell on a hidden sheet. The hidden sheet essentially is your clipboard, however using this method, you can store...
  4. Replies
    6
    Views
    81

    Mike, As a workaround until you find a...

    Mike,

    As a workaround until you find a permanent solution, you could use VBA to resize the chart.

    41403

    Place in a standard module


    Public Sub Smaller()
  5. Replies
    10
    Views
    744

    Microsoft Just rolled out some updates which may...

    Microsoft Just rolled out some updates which may have a fix. If the updates do not correct it, do a system restore to a restore point to somewhere in mid-December.
  6. SA, I could not find any issues with Zeddy's...

    SA,

    I could not find any issues with Zeddy's code except for one very minor flaw. The named range countUnexcused points to AI5 instead of AH5 which gives a garbled message in the status bar.......
  7. Replies
    6
    Views
    81

    Try a system restore to a point prior to the mal...

    Try a system restore to a point prior to the mal behavior
  8. Something to consider to augment Zeddy's nice...

    Something to consider to augment Zeddy's nice piece of code would be to indicate if an email was previously sent along with being time stamped with a date and time. If a comment is inserted in the...
  9. Replies
    8
    Views
    175

    The 12"-20" that was forecasted turned out to be...

    The 12"-20" that was forecasted turned out to be a bust. We ended up with about an inch and a little bit more on the way. Must be nice on the southern west coast.

    Let me know if I can be of any...
  10. Thread: Bus service

    by Maudibe
    Replies
    14
    Views
    295

    We're here waiting in the wild!

    We're here waiting in the wild!
  11. Replies
    10
    Views
    744

    6rtury, You must block the update by hiding it...

    6rtury,

    You must block the update by hiding it or it will auto reinstall again if your updates are set to auto.
  12. Replies
    8
    Views
    175

    KW, Here is a sample worksheet that has 3...

    KW,

    Here is a sample worksheet that has 3 sheets with specialties in columns B and associated data on the rows. The code will create a list of unique sorted specialties and open a new workbook...
  13. Replies
    18
    Views
    411

    Perhaps, formatting the dates in those lines...

    Perhaps, formatting the dates in those lines along with the date criteria may be a workaround. Since the op is not obviously using that format, it is really not an issue
    is it?
  14. Replies
    18
    Views
    411

    RG, Could you change the line Qtrs(1, 1) =...

    RG,
    Could you change the line Qtrs(1, 1) = #1/1/2014# to Format(#1/1/2014#, "dd/mm/yyyy")

    Not tested
  15. Replies
    1
    Views
    62

    [SOLVED] nephlim, You can set up the sheet like the...

    nephlim,

    You can set up the sheet like the example in the images using data validation in the drivers column, and the following formula in the Value column.

    Cell B2...
  16. Replies
    18
    Views
    411

    Zeddy, Just following the date format that the...

    Zeddy,

    Just following the date format that the OP used. You may need to adjust the date formatting in the code for your region.

    Maud
  17. Replies
    18
    Views
    411

    RG, Yes, that does make it more versatile....

    RG,

    Yes, that does make it more versatile. Nicely done! My other thought was to use optional parameters in the function to allow the entry of either a range or an actual date for the criteria.
    ...
  18. Replies
    18
    Views
    411

    MBHighes, You could also use a User Defined...

    MBHighes,

    You could also use a User Defined Function (UDF) for simplicity. Enter the formula:

    =CountQtr("H",A2) in the cell where you want the calculated result.

    This formula will have...
  19. Replies
    1
    Views
    75

    Jaccanuck When you say the download changes,...

    Jaccanuck

    When you say the download changes, are you indicating that the players names and stats will be placed in different cells throughout the sheet (different cols and rows) or that they will...
  20. Replies
    15
    Views
    288

    Good point Zeddy! Adding the line (in blue)...

    Good point Zeddy!

    Adding the line (in blue) should resolve that issue of allowing changes to be made directly in the grid.



    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    ...
  21. Replies
    8
    Views
    485

    Z, Here is the revised file reflects the...

    Z,

    Here is the revised file reflects the changes you specified.

    HTH,
    Maud

    41228

    Addendum: Change cell H1 to the path of the folder where the XML files are located. This will be used in...
  22. Replies
    10
    Views
    300

    Skipro When I write a piece of code, I always...

    Skipro

    When I write a piece of code, I always invite someone to add, change, or recommend modifications to improve the code. I have honed my skills from other member's inputs, especially Zeddy,...
  23. Replies
    2
    Views
    112

    you may find something here: ...

    you may find something here:

    http://windows.podnova.com/trends/excel_for_duplicate_bridge_scoring.html
    http://www.filebuzz.com/findsoftware/Bridge_Score_Sheet_Template/1.html
  24. Replies
    8
    Views
    485

    Z, Couple of quick questions: 1. Will the...

    Z,

    Couple of quick questions:

    1. Will the XML files always be in the same folder?
    2. If so, will the source folder for the XML files always be the same?
    3. Will the folder have any other...
  25. Replies
    18
    Views
    555

    Fred, FYI.... As you are probably aware, if...

    Fred,

    FYI.... As you are probably aware, if you decide to keep the Match formulas, they can be moved off the current sheet and just reference the data from the another sheet. Contrary to belief,...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4