Thursday, March 26, 2020

The Lincoln-Douglas Debates free essay sample

He believed in minority rights, meaning that he though that the minority group in the U. S. Should have the same or similar rights as the majority. He became the sixteenth president of The United States of America. President Abraham Lincoln is well known for issuing the Emancipation Proclamation that declared slaves free forever, on January 1, 1863. Abraham Lincoln won re-election in 1864 after gaining the support of northern democrats. On April 14, 1 865, the sixteenth president of the United States of America, Abraham Lincoln, was assassinated at Fords Theatre inWashington by John Wilkes Booth. Senator Stephen A. Douglas was born in Brandon, Vermont. Unlike Abraham Lincoln, he did not have to work as hard to get an education. In 1833, he began to study law under a local lawyer, but quit and moved to Jacksonville, Illinois 6 months later. In 1834 he was admitted to the Illinois Bar. Douglas was a leader in the Illinois Democratic Party. We will write a custom essay sample on The Lincoln-Douglas Debates or any similar topic specifically for you Do Not WasteYour Time HIRE WRITER Only 13.90 / page Shortly before he turned 22 he was elected to be the states attorney. In 1836 Douglas he was elected to the House of Representatives, and in 1840 he became the Illinois Secretary of State. In 1846 he served three consecutive terms in the U. S. Senate. In 1858 Senator Douglas once again, ran for U. S. Senate. This time his challenger was Abraham Lincoln a republican from Illinois. Lincoln and Douglas held a series of 7 debates in the seven congressional districts of Illinois. These debates were known as The Lincoln-Douglas Debates. He won the election for senate. Stephen A. Douglas died in June 1861 in Illinois after being severely weakened by a life of overwork and excessive drinking. The Lincoln-Douglas Debates took place in the seven different congressional strict of Illinois.The first debate took place in Ottawa, Illinois on August 21, 1858. This district would be the district that Chicago would be located in. The second Debate took place in Freeport, Illinois on August 27, 1858. Freeport was the northernmost congressional district in Illinois. The third debate took place in Joneses, Illinois on September 15, 1858. Joneses was the southernmost congressional district in Illinois. The fourth debate took place in Charleston, Illinois on September 18, 1858. The fifth debate took place in Eagleburger, Illinois on October 7, 1858. The sixth debate took place in Quince, Illinois on October 13, 1858. The seventh and final debate in the Lincoln- Douglas debate series took place in Alton, Illinois on October 15, 1858. During the Lincoln-Douglas debates many issues were discussed. The main issue of the Debates was slavery. They also discussed the issue of majority rule and minority right. Senator Douglas believed in majority rule, while Lincoln was supportive of minority rights. Because Senator Douglas was well known the Lincoln-Douglas Debates received national coverage.

Friday, March 6, 2020

How to Copy a Row in Excel VBA

How to Copy a Row in Excel VBA Using VBA to program Excel isnt as popular as it once was. However, there are still plenty of programmers who prefer it when working with Excel. If you are one of those people, this article is for you.​ Copying a row in Excel VBA is the kind of thing that Excel VBA is really useful for. For example, you may want to have one file of all your receipts with date, account, category, provider, product/service, and cost entered one line at a time, as they occur- an instance of evolving accounting rather than static accounting. To do this, you need to be able to copy a row from one worksheet to another. A sample Excel VBA program that copies a row from one worksheet to another- using only three columns for simplicity- contains: An alpha column for textA numeric column - an automatic sum is created on the target worksheetA date column - the current date and time is filled in automatically Considerations for Writing Excel VBA Code To trigger an event that copies the row, go with the standard- a Button form control. In Excel, click Insert on the Developer tab. Then, select the Button form control and draw the button where you want it. Excel automatically displays a dialog to give you a chance to select a macro triggered by the click event of the button  or to create a new one. There are several ways to find the last row in the target worksheet so the program can copy a row at the bottom. This example chooses to maintain the number of the last row in the worksheet. To maintain the number of the last row, you have to store that number somewhere. This might be a problem because the user might change or delete the number. To get around this, place it in the cell directly underneath the form button. That way, its inaccessible to the user. (The easiest thing to do is enter a value in the cell and then move the button over it.) Code to Copy a Row Using Excel VBA Sub Add_The_Line() Dim currentRow As Integer Sheets(Sheet1).Select currentRow Range(C2).Value Rows(7).Select Selection.Copy Sheets(Sheet2).Select Rows(currentRow).Select ActiveSheet.Paste Dim theDate As Date theDate Now() Cells(currentRow, 4).Value CStr(theDate) Cells(currentRow 1, 3).Activate Dim rTotalCell As Range Set rTotalCell _ Sheets(Sheet2).Cells(Rows.Count, C).End(xlUp).Offset(1, 0) rTotalCell WorksheetFunction.Sum _ (Range(C7, rTotalCell.Offset(-1, 0))) Sheets(Sheet1).Range(C2).Value currentRow 1 End Sub This code uses xlUp, a magic number, or more technically an enumerated constant, which is recognized by the End method. Offset(1,0) simply  moves up one row in the same column, so the net effect is to select the last cell in column C. In words, the statement says: Go to the last cell in column C (equivalent to EndDown Arrow).Then, go back up to the last unused cell (equivalent to the EndUp Arrow).Then, go up one more cell. The last statement updates the location of the last row. VBA is probably harder than VB.NET because you have to know both VB and Excel VBA objects. Using xlUP is a good example of the kind of specialized knowledge that is critical to being able to write VBA macros without looking up three different things for every statement you code. Microsoft has made great progress in upgrading the Visual Studio editor to help you figure out the correct syntax, but the VBA editor hasnt changed much.