Search:

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

Search: Search took 0.00 seconds.

  1. Re: If Chip Pearson's website ever helped you, please jot a note...

    I was delighted by the efforts by Bill Jelen to both do the needed research and engage in delicate and sensitive communication with Chip's family, to the benefit of all of us Excellers.

    I have...
  2. Re: formula for the best saturday in a two-way table

    Did you try following the basic instructions that any Google search shows?

    To change the country or region setting


    Open Region and Language by clicking the Start button , clicking Control...
  3. Replies
    2
    Views
    832

    Re: Macro code for Count If function

    Sanz, you used the terms "Selection" and "last active cell". Are you really talking about a selected range rather than all rows on the sheet? If so, that would be in conflict with the fact that you...
  4. Re: formula for the best saturday in a two-way table

    What if you temporarily change your windows settings to USA region, paste the formula, and then return your settings to normal?
  5. Re: How to preserve or regain the Id of my custom ribbon UI?

    When I tried to implement this in a class module, I found that the same kinds of thing that would cause my ribbon to lose state - were causing my class module to lose state, and therefore any methods...
  6. Re: VBA: "Evaluate" does not work with closed workbooks, but the same function does on sheet

    I don't see it that way. You can put in the fully qualified workbook path using that structure the OP used, and Excel will remove the path if the workbook is opened. It is a little unnerving.

    Say...
  7. Replies
    20
    Views
    2,282

    Re: Problem With VBA Sort Code...

    Thanks, resolved it with former post.

    Using this... with no need to select anything as far as I can tell.



    wTemp.Range(wTemp.Columns(1), wTemp.Columns(2)).Sort Key1:=wTemp.Cells(1, 2),...
  8. Replies
    20
    Views
    2,282

    Re: Problem With VBA Sort Code...

    Thanks much!
  9. Replies
    20
    Views
    2,282

    Re: Problem With VBA Sort Code...

    Hey I don't know if anyone is still following this thread a year later but I will jump in and hope for the best. I am getting the exact same error, and in fact I reduced my code to remove the SortOn...
Results 1 to 9 of 9