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