Solved the problem with;


Code:
--------------------


If Range("C28").Value < "" Then
objWord.Application.PrintOut
End If


--------------------


Thanks for all help.:)






Alec H Wrote:
Bob,

Blank was to represent an empty cell. In essence I want to print a
document if there are contents (of any sort, text or numeric) in cell
C28 or just continue to the next line of code if cell C28 is completely
empty.

Alec.


--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=518204