| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy question: Have macro ignore #N/A
How do you ignore #n/A values with macros? Can I have it only look at numbers? I just need a quick way to tell it to move along, and not worry about the line with an #N/A value. TIA Paul -- Paul987 ------------------------------------------------------------------------ Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850 View this thread: http://www.excelforum.com/showthread...hreadid=526860 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Easy question: Have macro ignore #N/A
If IsError(ActiveCell.Value) Then
MsgBox "error" End If -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Paul987" wrote in message ... How do you ignore #n/A values with macros? Can I have it only look at numbers? I just need a quick way to tell it to move along, and not worry about the line with an #N/A value. TIA Paul -- Paul987 ------------------------------------------------------------------------ Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850 View this thread: http://www.excelforum.com/showthread...hreadid=526860 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Easy question: Have macro ignore #N/A
set rng = columns(1).Specialcells(Formulas,xlNumbers)
for each cell in rng or for each cell in selection if not iserror(cell) then end if Next -- Regards, Tom Ogilvy "Paul987" wrote: How do you ignore #n/A values with macros? Can I have it only look at numbers? I just need a quick way to tell it to move along, and not worry about the line with an #N/A value. TIA Paul -- Paul987 ------------------------------------------------------------------------ Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850 View this thread: http://www.excelforum.com/showthread...hreadid=526860 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy Question - Please help | Excel Discussion (Misc queries) | |||
| Ignore this question | Excel Discussion (Misc queries) | |||
| new user with easy question? not easy for me | New Users to Excel | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
| Easy question: macro to move cursor one to the right | Excel Programming | |||
![Paul987[_19_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
