Thanks for your quick response, but if I try the code, it doesn't give me an error message anymore... but it also doesn't work for what I needed.

I need all the text in columns A from 2 worksheets converted to a number. I still have little green icons in all cells showing that it's text.

Have you run into this same error message before, and do you know how can you bypass it or "unhide" this range?