You don't need to use RandBetween, you can use VBA's Rnd.
randno = Int(Rnd()*100) + 1