Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

If the Range object consists of more than one cell, the Column property returns the column number of the first column in the range.t

Sub columnRange()     MsgBox Sheets("Sheet1").range("A:F3").column End Sub