I have the following sub (Excel 2007):
ActiveSheet.PasteSpecial Format:="Text"

It fails if there is no text to paste. I'd like a MsgBox to prompt the user
if there is no text. How do I do this?

Also, is there some way I can warn if the text will paste to more than one
cell?

Thanks