|
|
Name
|
Description |
| | |
| PlaceGraphicInHeader | This code demonstrates how to incorporate a graphic into a header (or footer) of a spreadsheet.
The code also shows how set the text values for headers if required. In this case it sets the title to be bold and underlined. The font size is also set to 32.
Link to information page click here. |
|
| RemoveDuplicateRows | This code demonstrates how to delete duplicate rows in VBA quickly and easily with one instruction.
Link to information page click here. |
|
| SplitDateAndTime | Excel often stores the date and time in a cell as a combined field. Many times, we need to separate the date, or the time and this code will do that.
Link to information page click here. |
|
| TestingTimeValues | This code demonstrates how to test a time value from a value extracted using our SplitDateAndTime example.
Also, there are two additional lines of code demonstrating how to drop off the seconds or round to the nearest second.
Link to information page click here. |
|
| WhichSheet | This code sample will ask the user for the name of the worksheet that they want to use.
If the worksheet doesn't exist, then the code will create it.
If the name specified does exist then the sheet is selected.
Link to information page click here. |
| Page # First Previous 1 2 | |
