Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another varible range address question
I get a runtime error on the countif code line can you help with the proper
cell referance thanks ' Where lastrow_in_col = 1500th row, changes ' Where z begins in Column B and ends in column AA For z = 1 To 26 ActiveCell.Value = Application.WorksheetFunction.CountIf _ (Range(Cells(2, z + 1) & ":" & Cells(lastrow_in_col, z + 1)), "<=5000") ActiveCell.Offset(0, 1).Select ' move right by one col Next z |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another varible range address question
For z = 1 To 26
ActiveCell.Value = Application.WorksheetFunction.CountIf _ (Range(Cells(2, z + 1), Cells(lastrow_in_col, z + 1)), "<=5000") ActiveCell.Offset(0, 1).Select ' move right by one col Next z HTH, Bernie MS Excel MVP "miek" wrote in message ... I get a runtime error on the countif code line can you help with the proper cell referance thanks ' Where lastrow_in_col = 1500th row, changes ' Where z begins in Column B and ends in column AA For z = 1 To 26 ActiveCell.Value = Application.WorksheetFunction.CountIf _ (Range(Cells(2, z + 1) & ":" & Cells(lastrow_in_col, z + 1)), "<=5000") ActiveCell.Offset(0, 1).Select ' move right by one col Next z |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another varible range address question | Excel Programming | |||
How to create a range address with ADDRESS function? | Excel Worksheet Functions | |||
Range name as varible | Excel Programming | |||
Varible in a Range | Excel Programming | |||
Using a Varible inside of a proper address | Excel Programming |