Hi All,


I have a question about Macros.

I want to make sure that every cell in Tel No have values so i want to create a Macro to detect
which cell contains NULL values and if it does,insert a number "1" in there to instead of null values

1.PNG


Can anyone help me with that? Thanks in advanced!!