Hi Brutus.

it takes a couple of minutes to act on a 1000 row spreadsheet.

On the face of it, that would seem excessively long. Post the code that you
are using.

I need to know if there is any way (other then VB code which I already use)

Consider using the built in autofilter feature.


---
Regards,
Norman



"brutus" wrote in message
k.net...
I need to know if there is any way (other then VB code which I already use)
to hide a row of a spreadsheet depending on the contents of a cell. I have
a spreadsheet that calculates commissions on data imported fromn Quick
Books. SOme employees do not get commissioned on all the items imported.
If a particular line item is non-commissionable I want that line to be
hidden before printing. I am presently using VB code to hide the rows but
it takes a couple of minutes to act on a 1000 row spreadsheet.

Dave