Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
this will find the last cell in col M with data
Sub countm() MsgBox Cells(Rows.Count, "M").End(xlUp).Row End Sub -- Don Guillett SalesAid Software "VK" wrote in message ... Hi, all! There is an option in Excel to count all used rows in active sheet: ActiveSheet.UsedRange.Rows.Count I would like to count rows in one column, that is shorter then other. How do I specify certain column to count? Something like: Columns("M:M").UsedRange.Rows.Count Reg. VK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count NonBlank Rows with Criteria in another column | Excel Worksheet Functions | |||
Count all rows in column with data, Except rows 1-5 | Excel Worksheet Functions | |||
count rows in a column for looping | Excel Discussion (Misc queries) | |||
Rows Count of a particular column | Excel Programming | |||
Rows Count of a particular column | Excel Programming |