Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
alternative for =0 and =""
Hi, In the "worksheet_activate" code of a worksheet(1) I have a littl problem. I have a formula on the worksheet(1) which refers to a cell on anothe worksheet(2) and when the cell with the formula(1) contains no valu sometimes the code if cell.offset(0,7).value ="" works, and sometimes the code if cell.offset(0,7).value =0 works. Is there some way to combine these two (=0 and ="") so that it doesn' matter which of the two it is, the code will allways work? Thanks in advance for any help -- leonida ----------------------------------------------------------------------- leonidas's Profile: http://www.excelforum.com/member.php...fo&userid=3537 View this thread: http://www.excelforum.com/showthread.php?threadid=57411 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
alternative for =0 and =""
if cell.offset(0,7).value ="" AND cell.offset(0,7).value =0 THEN
........................... "leonidas" wrote: Hi, In the "worksheet_activate" code of a worksheet(1) I have a little problem. I have a formula on the worksheet(1) which refers to a cell on another worksheet(2) and when the cell with the formula(1) contains no value sometimes the code if cell.offset(0,7).value ="" works, and sometimes the code if cell.offset(0,7).value =0 works. Is there some way to combine these two (=0 and ="") so that it doesn't matter which of the two it is, the code will allways work? Thanks in advance for any help! -- leonidas ------------------------------------------------------------------------ leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375 View this thread: http://www.excelforum.com/showthread...hreadid=574115 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Using "--" as an array formula shortcut / alternative | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |