hi
i was wondering if it was possibel to declare the countif function w/o
using the Range function before it..
range(something).select
"=countif(R[" & unknown & "]C[-3]:RC[-3],""SEARCH"")"
in the previous post there was the word indirect.. i' m not sure what
that does but when i took it out ..my countif worked! ..so..i'm not
sure whether the "indirect" is essential for what i need to do
is it possible instead of declaring a range (because i'm using a LOOP
already w/ a specified range already) to insert a set of coodinates
instead..i.e. the countif function needs somewhere to start LOOKING
somewhere
thanks
--
narutard
------------------------------------------------------------------------
narutard's Profile:
http://www.excelforum.com/member.php...o&userid=25111
View this thread:
http://www.excelforum.com/showthread...hreadid=386432