Bob,
Blank was to represent an empty cell. In essence I want to print
document if there are contents (of any sort, text or numeric) in cel
C28 or just continue to the next line of code if cell C28 is completel
empty.
Alec.
Bob Phillips Wrote:
If ("C28") < Blank Then Goto JUMP
assuming Blank is a variable or you are using it illustratively.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Alec H" wrot
in
message ...
Hi,
Extremely simple one for a Thursday....
I have a line of code that currently reads;
Code:
--------------------
If ("C28") = Blank Then Goto JUMP
--------------------
I want to change it so that it prints a document if the field is NOT
blank. I think it should be something like this...
Code:
--------------------
If ("C28") = NotBlank Then objWord.Application.PrintOut
--------------------
Obviously I have tried the above with no success...
Thanks
--
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
--
Alec
-----------------------------------------------------------------------
Alec H's Profile:
http://www.excelforum.com/member.php...fo&userid=3104
View this thread:
http://www.excelforum.com/showthread.php?threadid=51820