In that case what you can do is, do not assign anything to variable in text file. Let us say the variable name is $Blank$ then in text file write like this like this: Blank=
The text format of command to check blank value will look something like this:
1) If $Clipboard$ Equal To $Blank$ Then
2) Message Box: "Done"
3) End If
Also, if you copy the cell in Excel using Ctrl + C then it also copies the ENTER key so it is not a blank value. To copy the content of the cell, you need to use the following key sequence
F2 + Home + Shift + End + Ctrl + c
Also I recommend you to clear the clipboard before you copy each cell. |