Remove Interior.Color from a Range in Excel VBA
.Interior.ColorIndex = xlNone
Split first and last names in Excel VBA
When data is formatted like this: Colbert, Mike test@test.com BAIS IS And you want it like this: Mike Colbert test@test.com BAIS IS Sub dataCleanUp() Dim name As String Dim email As String Dim major As String Dim track As String Dim i As Integer ‘ loop counter Dim nStudents As Integer ‘ row counter Dim … Read more
Reset Identity Seed in Microsoft SQL
After you delete records from a table, if you want to set the Identity Seed back to zero: DBCC CHECKIDENT(‘msci3025_f14.dbo.msci3025_surveyData’, RESEED, 0)
Delete all rows from a Microsoft SQL table
To delete all rows from a table: DELETE FROM msci3025_f14.dbo.msci3025_surveyData
MS SQL script to create database and add data
This Microsoft SQL script was used to create a database table named colbert_stateFacts with fields stID, state_name, state_capital, state_code, state_bird and state_flower. The script then inserted records into the new table. CREATE TABLE [dbo].[colbert_stateFacts] ( [stID] [int] IDENTITY(1,1) NOT NULL, [state_name] [nvarchar](50) NOT NULL, [state_capital] [nvarchar](50) NOT NULL, [state_code] [nvarchar](2) NOT NULL, [state_bird] [nvarchar](50) NULL, … Read more
Workbook_Open Event Handler
Open the ThisWorkbook code window: Private Sub Workbook_Open() wsInstructions.Activate End Sub
Add A New Worksheet Using Excel VBA
Add a new worksheet named “Mike”… Worksheets.Add.Name = “Mike” Add a new worksheet named “Mike” as the first worksheet, before all the other worksheet tabs… Worksheets.Add(Before:=Worksheets(1).Name = “Mike” Add a new worksheet named “Mike” as the last worksheet, after all the other worksheet tabs… Worksheets.Add(Before:=Worksheets(Worksheets.Count).Name = “Mike”
Add Today’s Date To A Range And Format It
With Range(“A1”) .Value = Date ‘use today’s date ‘format it, you can also use yyyy for a four digit year. .NumberFormat = “mm/dd/yy” End With
Configure Syslogging On A Cisco Device
Configure a syslog server, then enter the following commands on the device you want to monitor… config t logging ‘ip address of syslog server’ logging trap informational
Markdown Code Block Sample
Test to see if Markdown works: Some text before the code block. <%@ Page Title=”” Language=”VB” MasterPageFile=”~/msci3025.master” AutoEventWireup=”false” CodeFile=”ThankYou.aspx.vb” Inherits=”ThankYou” %> <asp:Content ID=”Content1″ ContentPlaceHolderID=”head” Runat=”Server”> </asp:Content> <asp:Content ID=”Content2″ ContentPlaceHolderID=”ContentPlaceHolder1″ Runat=”Server”> Thank you for participating in our survey! </asp:Content> Some text after the code block.