if you are trying to pull a 120 row sample from the data, insert a new column A

in A5 put in
=rand()
and drag fill down the column. sort on this column and select the first
120 rows.

--
Regards,
Tom Ogilvy


"jay dean" wrote:

Range(A5:K1000) contains characters.
The macro should randomly highlight 120 rows (entire rows, that is) in
the above range yellow.

Any help would be much appreciated !

Thanks
Jay Dean



*** Sent via Developersdex http://www.developersdex.com ***