Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |