Yep, saw that,
Type: Posts; User: XPDiHard; Keyword(s):
Yep, saw that,
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...
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...
Thanks to email@example.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..
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...
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.
had to be...
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"),...
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
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
firstly I just noticed a small oversight in one of the formula range.
between D56 and D80
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...
The current Function is: ( I don't remember who wrote it, was ages ago, much appreciated)
Dim sShtName As String
This has gone 3 pages long, so took the hint and added a poll.
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...
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...
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...
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.
Steve, it took me a while, ( work n stuff ), but I finally got something I hope to get this progressive graph
I tried to create a graph, plot the Values and Invert so the negative line go...
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...
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...
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"....
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...
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,...
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...