Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
cells(r+1,"af").formula= "= countif(" & rngbas.address & "," & cells(r+1,
"AE").address & ")" I think this means that a formula is being inserted in cell (r+1,af). The formula is counting all of the occurrences of the contents of cell(r+1, ae) that can be found in a particular range. I know that rngbas is a range. I do not understand the rngbas.address or the second mention of .address. Please interpret for me. TIA Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Explain THIS ... | Excel Discussion (Misc queries) | |||
explain this one to me.... | Excel Discussion (Misc queries) | |||
Let me see if I can explain this... | Excel Worksheet Functions | |||
Can someone explain to me? Pls? | Excel Programming | |||
Please explain syntax needed | Excel Programming |