I have just started using VBA so this may be easy to do but I cannot find it in the help and I don't have a book.
I am trying to check cells in a table to see if it is empty but everytime I use Selection = Empty or "" the selection contains some unusual characters and so it always returns false. I have tried using IsNull() and Selection.Text but it always returns these strange characters (Looks like a bold ||) and so I can never get it to be true.
Thanks !!!
I am trying to check cells in a table to see if it is empty but everytime I use Selection = Empty or "" the selection contains some unusual characters and so it always returns false. I have tried using IsNull() and Selection.Text but it always returns these strange characters (Looks like a bold ||) and so I can never get it to be true.
Thanks !!!