I developed a simple program using Microsoft Excel and Visual Basic Editor. In the worksheet, I have specified 10 cells according to their own formula. All the cells contain #N/A sign as to show that the cells contain their own formula ( I guess!)
After executing the program only 6 cells were automatically fill-in with data. What can I do if I want the program to consider the other 4 cells as empty? (eventhough they actually have formulas)
This is because I want the program to automatically hide the empty cells.(cells with no data)
Anyone can help me?
Thank you in advanced
After executing the program only 6 cells were automatically fill-in with data. What can I do if I want the program to consider the other 4 cells as empty? (eventhough they actually have formulas)
This is because I want the program to automatically hide the empty cells.(cells with no data)
Anyone can help me?
Thank you in advanced