Originally posted by: desteffy
Hi, Suppose I have a large matrix with either blank or nonzero entries and I want it to fill in all the blank entries with zeros, there has to be some simple way to do this, anyone know how?
I've got a Macro that will do it for the selected range...
To create the macro... from your worksheet:
- select Tools -> Macro -> Visual Basic Editor
- select Insert -> Module
- paste code into Module and save worksheet
To use the macro....
- select the range to fill with zeros
- select Tools -> Macro -> Macros
- select Fillblanks
- click Run
If there's a "built in" way, I haven't found it yet.