Type: Posts; User: XPDiHard; Keyword(s):
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...
Sure can, may take me a while, (new day job),
I"ll try to present something which is "uncharted territory" for me with graphs in Excel 2010.
Back to this project after a break n brainstorm, it's now for the next and final phase.
It's the graph, but it needs to be progressive line graph. I have no idea on how to VBA a progressive graph,...
3.93 Comodo Dragon (Chromium) https://www.comodo.com/home/browsers...rs/browser.php
The only browser I use and I don't install updates unless I have to.
The other browser, reluctantly because...
Not sure of correct terminology,
I would like all the data removed weather it has Linux, MS or any other OS, but not to compromise the basic boot-up, so it can still read a the A: ( if...
I'm fixing an old computer that does not have the A: Floppy disk drive.
What I usually do is use my old Win 3.11 disk 3.5" set, disks 1,2 and 3 to reformat and this leaves me with a plain DOS...
I disable Print Spooler in Services (Local).
If I need to print something, ( rarely do btw) then I manually enable Print Spooler to use printer, then disable again.
Don't ask me why, it frees up...
This is just arrow-key code for reference, you simply change the 1's to suit accordingly
Selection.Offset(0, 1).Select '*Right*
Selection.Offset(0, -1).Select '*Left*
No,I am still on XP Pro till it "ends". :eek:
I'll wait !
I do most of my questions and wk.book uploads in excel forum.
Sometimes it is not required to upload a workbook, but a section of a worksheet. I seen these in other posts, looks like a screen shot,...
Fixed, all calculating correctly.
For the record/reference is the workbook