Shortcut Notation "[]" in VBA

[ccsmith]

Please Login or Register  to view this content.

The above command isn't working perfectly as a part of a macro . Could you find out that it is a mistake inside it?
I need to add the AND operation to the IF statement.
It would be perfect if you can rewrite this line to a VBA procedure.