Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    18
    Views
    156

    Fred, Sorry I forgot about the vba, but...

    Fred,

    Sorry I forgot about the vba, but there's a simple workaround !

    Make a copy of the Workbook and, in the copy, convert the relevant formulas to values. Then you can use this copy as the...
  2. Replies
    18
    Views
    156

    Fred, "The contents of what's being examined...

    Fred,

    "The contents of what's being examined are not changing based on other things, so the calculations done by the formula are done once." . . .
    . . . but of course it is all recalculated every...
  3. Replies
    28
    Views
    1,461

    Same non-sorting behaviour with files on an SD...

    Same non-sorting behaviour with files on an SD card.

    I'm not aware of a "better" way of "introducing volatility". A method I sometimes use is to capture the F9 key and insert some vba - in this...
  4. Thread: Battery issue

    by MartinM
    Replies
    10
    Views
    330

    Done, worked, thanks :rolleyes:

    Done, worked, thanks :rolleyes:
  5. [SOLVED] On your second point, Excel's base unit of time...

    On your second point, Excel's base unit of time is one DAY. So formatting alone cannot convert seconds into days - first you have to divide the seconds by 86,400 (the number of seconds in a day) then...
  6. Replies
    9
    Views
    225

    [SOLVED] Rory's explanation is the correct one. In one...

    Rory's explanation is the correct one.

    In one case you bet $1.00 and win 75c and get your stake back: a total of $1.75
    In the other case you bet $1.00 and win 55c and get your stake back: a...
  7. Replies
    9
    Views
    225

    [SOLVED] Looks to me more like the return for a given...

    Looks to me more like the return for a given stake (maybe $1 ?) in a horse race. Any taxes or other deductions could cause a complex relationship between the percentage shown and the two $ amounts.
    ...
  8. Replies
    9
    Views
    225

    [SOLVED] To answer your question we need to know what the...

    To answer your question we need to know what the $1.75 and $1.55 represent.
  9. Replies
    28
    Views
    1,461

    It really does seem to be just you ! I've...

    It really does seem to be just you !

    I've tried all combinations of sub and sub-sub directories I can think of, including foldernames at the beginning of the alphabetic list, in the middle and at...
  10. Replies
    28
    Views
    1,461

    As always, I learned a lot too, thanks. ...

    As always, I learned a lot too, thanks.

    Wouldn't it be better to have a named range rather than your "A:A" style whole column reference ? Otherwise there's always going to be a danger of...
  11. Replies
    28
    Views
    1,461

    RG, This is peripheral to Zeddy's original...

    RG,

    This is peripheral to Zeddy's original request and I suppose that the precise error shown is unimportant in the context of what he's doing.

    That said, there are no sub-directories and, even...
  12. Replies
    28
    Views
    1,461

    Our posts crossed. Curious about the odd...

    Our posts crossed.

    Curious about the odd scattering of #N/As . . . thinking . . .

    Got it: copy everything from row 11 down two columns to the right and all is well. "A:A" is picking up the...
  13. Replies
    28
    Views
    1,461

    Yes - I saw that. Are you sure that vba is using...

    Yes - I saw that. Are you sure that vba is using the Dir function when it executes Files() ? I'm not.

    I've now tried it on a W7 PC - same result: I can only get sorted results (alpha, ascending).
  14. Replies
    28
    Views
    1,461

    I can't - whatever I do it comes up in alpha...

    I can't - whatever I do it comes up in alpha order . . . still trying though.
  15. Replies
    28
    Views
    1,461

    I'm still working on trying to get the file list...

    I'm still working on trying to get the file list not sorted, which may yield a clue as to why your list isn't sorted.

    Changing the sort order in Windows (XP) Explorer makes no difference, neither...
  16. Replies
    28
    Views
    1,461

    I was playing around with your example Workbook...

    I was playing around with your example Workbook with some thoughts in mind to address your question and, curiously, I could only get files lists sorted alphabetically by filename.

    Try as I might -...
  17. Thread: Battery issue

    by MartinM
    Replies
    10
    Views
    330

    Update: the old battery peaks at 19% of its full...

    Update: the old battery peaks at 19% of its full capacity, so it certainly was "dead".

    Curiously, the taskbar meter is now very confused - it says 100% when the new battery is about 20% charged....
  18. I don't think that you can prioritise data access...

    I don't think that you can prioritise data access specifically, but storage transfers are executed via the CPU so setting the program's priority level in Task Manager will, albeit indirectly, achieve...
  19. Thread: Battery issue

    by MartinM
    Replies
    10
    Views
    330

    Well the new battery is fine, thank you very much...

    Well the new battery is fine, thank you very much for the clues the monitor gave me: 4 1/2 hours life now.

    I'll check the old battery tomorrow.
  20. Thread: Battery issue

    by MartinM
    Replies
    10
    Views
    330

    Thanks - I will give that a try Update: very...

    Thanks - I will give that a try

    Update: very interesting. The taskbar battery icon has been at 100% remaining (charging) for some time now. The HW Monitor shows a Designed Capacity of 86,580 mWh,...
  21. Thread: Battery issue

    by MartinM
    Replies
    10
    Views
    330

    Battery issue

    Windows XP SP3

    I think this may be a software (driver, whatever) issue hence posting here.

    The battery in my Inspiron 6400 only lasts for about 30 minutes so I have bought a new one - brand new...
  22. Replies
    9
    Views
    859

    You're right - I was talking about cell formats....

    You're right - I was talking about cell formats. I should have said that they are also a source of possible corruption, and much harder to track down as I can't see a means of tracking how many Excel...
  23. Replies
    9
    Views
    859

    Zeddy, Doesn't your macro only list those...

    Zeddy,

    Doesn't your macro only list those styles which are named ?

    I've run into the "excess number of styles" issue a couple of times in Excel 2003 and the problem hasn't been the styles which...
  24. Replies
    6
    Views
    384

    Is it possible that the keypress ESC has been...

    Is it possible that the keypress ESC has been captured in a macro, with an Application.OnKey statement ?
    It might be worth searching the whole project for "ESC".

    PS Lovely bells in St Bartholomews
  25. Or . . . Click on the source cell and click on...

    Or . . .
    Click on the source cell and click on Edit . . . Copy (or CTRL C).
    Click on the destination cell and click on Edit . . . Paste Special . . . Paste Link (Do not hit Return after clicking...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4