I'm learning a painful lesson about how choosing to Select a range in Excel vba is sometimes a fatal error!
There seems to be no way around Selecting a range of cells in a column in order to:
Finde/Replace values in a range via Ctrl+H-type VBA (from '-1' to 'N/A' for example)
Reformat a range from one type to another (text to currency)
I've read through many solutions to this venomous error message but none of them quite fit exactly what I need. What's maddening is that sometimes Select works fine - but sometimes it doesn't! My client cannot afford to have his customers get an error message!!!