Excel VBA Training

INT function returns the integer portion of a number.

Syntax =INT(expression)

www.ExcelCareer.com

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

Exact formula or =?

Trend Line using line chart

Unhide Column Shortcut

Loop through all sheets:

Sub ShowWorkSheets()
Dim mySheet As Worksheet

For Each mySheet In Worksheets
MsgBox mySheet.Name
Next mySheet

End Sub

This will be very helpful for the beginners.......
Keep Sharing....
Join us for Excel VBA Training......
Excel VBA Training

The For Each Loop

The For Each loop is similar to the For ... Next loop but, instead of running through a set of values for a variable, the For Each loop runs through every object within a set of objects. For example, the following code shows the For Each loop used to list every Worksheet in the current Excel Workbook:

Dim wSheet As Worksheet
For Each wSheet in Worksheets
MsgBox "Found Worksheet: " & wSheet.Name
Next wSheet

Triple Loop
You can use a triple loop to loop through two-dimensional ranges on multiple Excel worksheets.

Dim c As Integer, i As Integer, j As Integer

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

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