Search:

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

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thread: Windows 9 ?

    by XPDiHard
    Replies
    2
    Views
    337

    Yep, saw that, Thanks

    Yep, saw that,

    Thanks
  2. Replies
    13
    Views
    527

    I was shown Record Macro in Excel in 1995, the...

    I was shown Record Macro in Excel in 1995, the things I did repetitively, mainly some book keeping for work-at-home budgets. I needed repetitive accuracy.

    Then Recorded a simple formula from one...
  3. Thread: Windows 9 ?

    by XPDiHard
    Replies
    2
    Views
    337

    Windows 9 ?

    Going to wait for it this time, I played around on a friends Win 7 PC, heard about Win 8 and was not impressed with either.

    Due for a major upgrade though after Win 9 happens;
    or as predictable...
  4. Solved

    Thanks to dguillett@gmail.com who suggested I try some codes.

    I believe it is SOLVED,
    but won't mark it yet from thread tools cos it closes the thread and further comments may be added..


    On...
  5. The first file is simply a example of a...

    The first file is simply a example of a continuous Loop, it will eventually freeze.

    The second file is from the temp file folder that gets sent to Microsoft if one chooses to send the error...
  6. here is the cvr error report file after the...

    here is the cvr error report file after the predictable crash.
    It's encrypted so there ain't a way that I know of to see exactly where the problem originates from or causes.


    Thanks

    had to be...
  7. Office 2010 ( 3 pc license for students ) Type...

    Office 2010 ( 3 pc license for students )

    Type of web query code.
    Initially it was a Record Macro and tweaked thereafter for the URL reference that comes from the Events list
    in, & Range("A2"),...
  8. Symptoms of Excel Freezing with "Send Error Report" option

    This "problem" is not new, and I don't blame Excel entirely.
    It's been the same since I started this project using Excel 2003, 2007, and now 2010 version.

    It only happens with the

    Do Until
    ...
  9. Replies
    5
    Views
    269

    [SOLVED] Thanks Maud Now I "see" it, it was this part I...

    Thanks Maud
    Now I "see" it, it was this part I missed C$30 : D$54,
    It crosses over between C & D


    I use the latter so the zeros don't show
    ...
  10. Replies
    5
    Views
    269

    [SOLVED] Thanks RG, firstly I just noticed a small ...

    Thanks RG,
    firstly I just noticed a small oversight in one of the formula range.
    between D56 and D80
    was
    =IFERROR(SMALL($D$30:$D$51,ROW(2:2)),"")
    Change to...
  11. Replies
    5
    Views
    269

    [SOLVED] Index match formula for point scoring

    I have tried many combinations, googled examples etc to get this INDEX MATCH formula to work right.

    The problem area is in the range of C56:C80
    All I get is 0's along the entire Range, the MATCH...
  12. Replies
    2
    Views
    168

    Thanks Maud, so obvious, = ActiveSheet.Name

    Thanks Maud,
    so obvious,
    = ActiveSheet.Name
  13. Replies
    2
    Views
    168

    Reversal of a, Add-Sheet-Name Function

    The current Function is: ( I don't remember who wrote it, was ages ago, much appreciated)

    Option Explicit


    Sub add_Sheet_name()
    Dim sShtName As String

    sShtName =...
  14. Replies
    68
    Views
    6,723

    Poll: This has gone 3 pages long, so took the hint and...

    This has gone 3 pages long, so took the hint and added a poll.
  15. Replies
    68
    Views
    6,723

    Poll: 2 box pc's and 1 notebook, all 3 eventually got...

    2 box pc's and 1 notebook, all 3 eventually got on/off switch breakdowns since my first pc in 1992.

    Only 1 pc had some sort of solder problem on the motherboard, where I had to place a full coffee...
  16. Replies
    68
    Views
    6,723

    Poll: Fact or myth: Never switch off computer

    Fact or Myth - never switch off Computer because ..,

    I was told many years ago to never completely switch off a notebook or a box computer because
    the expansion and contraction of the...
  17. Replies
    54
    Views
    3,371

    My wrong, was put there during the build making...

    My wrong, was put there during the build making sure the formulas lined up between sheets and columns. When I tried Split Screen at the time, I was not able to switch beteen sheet tabs, the split was...
  18. Replies
    54
    Views
    3,371

    Thanks, Yes, 5 is better. Ok, It...

    Thanks,



    Yes, 5 is better.



    Ok, It may take a week or so to test run using various scenarios. ( moving house, may be offline)
    The scenarios only differ in 2 ways.
  19. Replies
    54
    Views
    3,371

    Steve, it took me a while, ( work n stuff ), but...

    Steve, it took me a while, ( work n stuff ), but I finally got something I hope to get this progressive graph
    sorted.

    I tried to create a graph, plot the Values and Invert so the negative line go...
  20. Replies
    54
    Views
    3,371

    I need a few days to make a simulator to show the...

    I need a few days to make a simulator to show the progression and then point out with Msg Boxes where the graph begins and where it ends.

    The only question I have at this point with your graph is...
  21. Replies
    54
    Views
    3,371

    Steve, I have uploaded all the example screen...

    Steve, I have uploaded all the example screen shots from the DOS program.
    The DOS program uses 5 columns of manual data entry. ( back in 1993 )
    At that time there would be these numbers were viewed...
  22. Replies
    54
    Views
    3,371

    Steve, yes, getting there. -, The visual...

    Steve,

    yes, getting there.
    -,


    The visual display of the 3 on the DOS chart are part of more calculations on another part of the program.
    In that case it is the "preferred selection"....
  23. Replies
    54
    Views
    3,371

    Steve, thanks. I manually plotted the series....

    Steve, thanks.

    I manually plotted the series.

    Re: uploaded Excel file: June2014-graph 2.zip

    Sheets: Graph 2, is referenced from the Ascending sorted order in Sheets: SORTED.

    I have added...
  24. Replies
    54
    Views
    3,371

    Steve, There may have to be some transformation,...

    Steve, There may have to be some transformation, if that is the correct term.

    If I was to track 1 row at a time, the X would start at Cell F4 and track a Y range
    H4, J4, L4, N4, P4, R4, T4, V4,...
  25. Replies
    54
    Views
    3,371

    Ok, Steve The WkBook has 3 sheets Sheet 1 is...

    Ok, Steve

    The WkBook has 3 sheets
    Sheet 1 is named: "SEQUNCE with formula"
    P-Var stands for, Percent Variable.
    This sheet's entries/populates was created because of the VBA earlier in this...
Results 1 to 25 of 158
Page 1 of 7 1 2 3 4