| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check for blank arguments WITHIN Macro - how?
if isempty(cell) then
or if len(trim(cell)) = 0 then if it must be a number if not isnumeric(cell) then -- Regards, Tom Ogilvy "JuergenL" wrote in message ... I need to check WITHIN a macro if an argument is blank. A cell, used as argument, which has no value entered is in my case undefined, Excel 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. Juergen -- JuergenL ------------------------------------------------------------------------ JuergenL's Profile: http://www.excelforum.com/member.php...o&userid=21816 View this thread: http://www.excelforum.com/showthread...hreadid=518350 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check for blank arguments WITHIN Macro - how?
Thanks for the quick answer, I tried 'em all and but none work WITHIN the macro. By that time the blank cell is already converted to zero, it seems. Juergen -- JuergenL ------------------------------------------------------------------------ JuergenL's Profile: http://www.excelforum.com/member.php...o&userid=21816 View this thread: http://www.excelforum.com/showthread...hreadid=518350 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check for blank arguments WITHIN Macro - how?
What can I say. Perhaps someone who is psychic can help.
-- Regards, Tom Ogilvy "JuergenL" wrote in message ... Thanks for the quick answer, I tried 'em all and but none work WITHIN the macro. By that time the blank cell is already converted to zero, it seems. Juergen -- JuergenL ------------------------------------------------------------------------ JuergenL's Profile: http://www.excelforum.com/member.php...o&userid=21816 View this thread: http://www.excelforum.com/showthread...hreadid=518350 |
| Reply |
| 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) | |||
Linear Mode
