Looking for a faster way to find and replace

[Twollaston]

Hello there,

I have a worksheet with about 120,000 lines with probably 50 columns and I run the following code to change all the #'s to blank cells. I was wondering if there is a faster way to do this, because this takes a long time to complete.

Sub NtoBlank()


             Cells.Replace What:="#", Replacement:=""

End Sub

 

[Fluff]

Do any cells contain formulaic errors?

 

[Twollaston]

Yes, Thank you sir that was exactly the problem

 

[Fluff]

You're welcome