Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting cell above a #N/A
Hi
How can I select a cell which resides above a cell containing a #N/A, I have tried ISERROR without success. Thanks leshik |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting cell above a #N/A
Application.WorksheetFunction.IsNA("A1") returns True/False
"leshik" wrote in message ... Hi How can I select a cell which resides above a cell containing a #N/A, I have tried ISERROR without success. Thanks leshik |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting cell above a #N/A
The Iserror should work, but you need to then offset the
cell back one row. Try the following replacing the Activesheet.range("C5") with whatever range you are checking. If you are looking for the #N/A only then you need to check for returnval = error2042 and then offset. Dim ReturnVal, MyCheck ReturnVal = ActiveSheet.Range("C5") MyCheck = IsError(ReturnVal) ' Returns True. If MyCheck = True Then ActiveCell.Offset(-1, 0).Select Else End If Best of luck DavidC -----Original Message----- Hi How can I select a cell which resides above a cell containing a #N/A, I have tried ISERROR without success. Thanks leshik . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 single cell selecting muliple cell | Excel Worksheet Functions | |||
Selecting a cell entry based on cell validation selection | Excel Worksheet Functions | |||
Transfer cell values to another cell by selecting button. | Excel Worksheet Functions | |||
Selecting cell next to a value | Excel Programming | |||
Selecting the first cell of a row | Excel Programming |