Hi...

I have 3000 records. In column B, some cells are reading #N/A. I need some
code that will delete the rows where the #N/A occours and leave no gaps. So
by the time I'm through I have say 2800 records with no gaps in the rows? Is
this possible?

Thanks

Gordon