Excel VBA Training

Interview Question>>>>>>>>>>
What is the difference between
Option Explicit and Option Base??????
Answer will be posted tomorrow.....
www.ExcelCareer.com

Unhide Column Shortcut

You can use a double loop to loop through a two-dimensional range of cells.

Dim i As Integer, j As Integer

For i = 1 To 6
For j = 1 To 2
Cells(i, j).Value = 100
Next j
Next i