Freedom Computers

Count Columns or Rows


Coun
t Columns

A
ctivesheet.UsedRange.Select
LastCol=Selection.Columns.Count

Count Rows
Act
ivesheet.UsedRange.Select
Lastrow=Selection.Rows.Count

EXCEL