If...Then...query
 

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

If...Then...query
 

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" wrote 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

If...Then...query
 

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

If...Then...query
 

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