| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count rows in a column for looping
I was using this code
RwsCnt = ActiveSheet.UsedRange.Rows.Count for i = 1 to RwsCnt 'Code Next i it works correctly but the value of the row count increases as the macro goes along how can I get this to count just the rows in column B? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| looping through rows and columns | Excel Discussion (Misc queries) | |||
| Count the number of rows where more than one column meets set crit | Excel Worksheet Functions | |||
| Looping a selection of rows | Excel Discussion (Misc queries) | |||
| Count rows that match criteria in 2 different column cell ranges | New Users to Excel | |||
| Looping until empty column | Excel Discussion (Misc queries) | |||
Threaded Mode
