small macro running v slow?

Hi

Does anyone know what I am doing wrong - macro takes an excessive amt of time to run ?XL_Export.xlsb

I include the file required to make it run through

Thanks

Please Login or Register  to view this content.

Your code doesn't work. There is no Sheet4 in the attached workbook.

Resale Ordering.xlsmXL_Export.xlsbHi

Sorry I didn't realise a response had been received. I attach the macro worksheet and export file for macro - its runs through for me. Let me know if you are still having problems. I just don' t understand why its taking so long to run through

appreciate your help with this.
Kind regards
Leanne

Please Login or Register  to view this content.

I have used this code in two parts - the bit where I don't need "If rcell.Value >= 0 Then" I was able to replace with your code and it appears to run a bit quicker. Is it possible to do the same for the second part - I just don't know how to include the "If rcell.Value >= 0 Then" ?

Many thanks for your help
Leanne

Thanks very much for your help - absolutely perfect and has sped the macro up !