Hopefully easy answer

[tuxydoh]

I am using a sub I got from the internet that randomly highlights cells. what I need is to have the counter reference a cell instead of being set in the code (see below). I want to be able to put a value in cell H1 and that replace the 150 in the formula. This would make it easier as my sheets will have variable quantities for what I need to be highlighted.
For Counter = 1 To 150
Set Cell = RandCell(TargetRg)

 

[Fluff]

Replace the 150 with Range("H1").value

 

[tuxydoh]

thank you so much

 

[Fluff]

You're welcome & thanks for the feedback