| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for blank arguments WITHIN Macro - how?
I need to check WITHIN a macro if an argument is blank. A cell, used a argument, which has no value entered is in my case undefined, Exce makes it zero, and I cannot find any way to test it. I know I can do it BEFORE I pass an argument to the macro [e.g. IF(A1="","whatever",A1)], but I like to do it inside the macro. Is there a way? How? Thanks in advance for any help / ideas. Juerge -- Juergen ----------------------------------------------------------------------- JuergenL's Profile: http://www.excelforum.com/member.php...fo&userid=2181 View this thread: http://www.excelforum.com/showthread.php?threadid=51835 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check for Non Blank and Blank Cells Before Save | Excel Discussion (Misc queries) | |||
| Macro to check if clipboard is blank. | Excel Discussion (Misc queries) | |||
| passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
| Macro to check for blank responses | Excel Programming | |||
| Seeking an alternative to blank ("") cell in IF arguments | Excel Discussion (Misc queries) | |||
Threaded Mode
