Im trying to use:

VB Code:
  1. Sub highlite()
  2.  
  3.     If Range("V" & Int(Rnd * "10000")).Select Then
  4.     Rows(Int(Rnd * "10000") & ":" & Int(Rnd * "10000")).Select
  5.     Range("F" & Int(Rnd * "10000")).Activate
  6.     With Selection.Interior
  7.         .ColorIndex = 39
  8.         .Pattern = xlSolid
  9.     End With
  10.     End If
  11.    
  12. End Sub

in excel, to highlight a whole row, if i click on a cell in that row, then if I click on another row, it de-highlits back to how it was originally and highlights the new row! what am I ding wrong and is there a solution?