thanks, alok. i wrote something like this. to be clear, i declare
tricor and oos as ranges.


Code
-------------------
If radOverall Then

If chTricor Then
Set Tricor = Range("RankTricorAll")
TricorCount = 1
Else
Set Tricor = shRankings.Range("B3")
TricorCount = 0
End If

If chOOS Then
Set OOS = Range("RankOOSAll")
OOSCount = 1
Else
Set OOS = shRankings.Range("B3")
OOSCount = 0
End If

shRankings.Range("AverageAll").Formula = Tricor + OOS

End I
-------------------


and that didn't work. it said type mismatch error. what did i do wrong
(don't worry about the count stuff for now. i didn't include it in th
formula because i'm still testing it).


and it's not an entirely new question since it's just a problem
encountered when trying to implement the solution to this one. i don'
like creating multiple threads, as it seems like spam

--
dream
-----------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...fo&userid=2646
View this thread: http://www.excelforum.com/showthread.php?threadid=47994