Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For | Next ...OR... Do | Loop
i have this code:
Sub CountProducts() Dim scol As String LastRow = ActiveSheet.UsedRange.Rows.Count Range("A" & LastRow + 3).Select scol = Chr$(ActiveCell.column + 64) ActiveCell.Formula = "=counta(" & scol & "2:" & scol & _ ActiveCell.Row - 1 & ")" End Sub and what i need is to either loop once from range A : S or just for each range do the code, then next until range is S... can anyone show me how please? --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
For | Next ...OR... Do | Loop
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find loop doesn't loop | Excel Discussion (Misc queries) | |||
For... Next Loop | Excel Discussion (Misc queries) | |||
Loop | Excel Discussion (Misc queries) | |||
getting out of a if loop | Excel Discussion (Misc queries) | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming |