Dim?

DIM is short for Dimension, you use it to declare variables.

Also, by declaring Option Explicit at the top of each module, you will be forced to declare variables, which helps a lot. For instance, with the same code as the previous post:

Option Explicit

Sub SeeDim()
    Dim aRng As Range, oC As Range
    Dim aInt As Integer
    Dim aLong As Long
    Dim aWorksheet As Worksheet

    aInt = 5
    aLong = 10
    Set aWorksheet = Worksheets("Sheet1")
    Set aRng = aWorksheet.Range("B1:B5")
    For Each oC In aRng
        oC.Value = aLong
        oC.Offset(0, 1).Value = aInt
    Next oC
End Sub

The following code declares variables

Sub SeeDim()
    Dim aRng As Range, oC As Range
    Dim aInt As Integer
    Dim aLong As Long
    Dim aWorksheet As Worksheet

    aInt = 5
    aLong = 10
    Set aWorksheet = Worksheets("Sheet1")
    Set aRng = aWorksheet.Range("B1:B5")
    For Each oC In aRng
        oC.Value = aLong
        oC.Offset(0, 1).Value = aInt
    Next oC
End Sub

What I find to be most valuable about declaring variables is that it helps to enable the intellisense while coding. If you want to test the intellisense, re-write the code I gave line by line and you'll see what i mean.

There's some notes that I put together here

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save