Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with this function
Function info(x)
If Worksheets("General INFO").Range(x).Value = 0 Then info = "" Else: info = Worksheets("General INFO").Range(x).Value End If End Function i want to check the specified cell, if it is blank, give me blank, otherwise give me the value |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with this function
If it is blank you want when blank, why not just use
Function info(x) info = Worksheets("General INFO").Range(x).Value End If or better still, why not use ='General INFO'!A99 in the cell, or whatever c ell you pass in x. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "steve" wrote in message ... Function info(x) If Worksheets("General INFO").Range(x).Value = 0 Then info = "" Else: info = Worksheets("General INFO").Range(x).Value End If End Function i want to check the specified cell, if it is blank, give me blank, otherwise give me the value |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |