lundi 1 février 2016

How to highlight a random sample of rows in Excel using VBA

Good day all,

I have a report that generates that can contain a range of rows and typically 5-6 columns. I need a code that will allows me to highlight "n" rows in order to audit those particular rows for accuracy. N can always change for each client (and should be random), but I am happy to simply plug in a number each time. My current requirement is to audit 25 rows.




Aucun commentaire:

Enregistrer un commentaire