Hello,
Can anyone recommend the simplest method of
"setting up" the file opening environment in Excel 2000 in such a way that everytime any Excel or Text file is opened in it that if there are any "#N/A" in the workbook or worksheet that they are replaced automatically by either blanks or a letter denoting this fact.
So I'm really looking for something that would be in the "Excel 2000" memory everytime Excel is run.
I hope someone call help !
Can anyone recommend the simplest method of
"setting up" the file opening environment in Excel 2000 in such a way that everytime any Excel or Text file is opened in it that if there are any "#N/A" in the workbook or worksheet that they are replaced automatically by either blanks or a letter denoting this fact.
So I'm really looking for something that would be in the "Excel 2000" memory everytime Excel is run.
I hope someone call help !