Getting rid of "#VALUE!"

  • Thread starter Thread starter cardioblack
  • Start date Start date
C

cardioblack

I have 2 columns: (the first column is user defined while the second is
returned through the macro)

Last Login | Days Since Last Login
1/1/2007 11
N/A #Value!


I get the # value after running this macro

Macro

'Populates the Days Since column with data
Set rng = Range(Cells(2, 2), Cells(2, 2).End(xlDown))
rng.Offset(0, 5).Formula = "=Networkdays(F2,today())"




How do I get rid of the #Value! ? I can't do a Find and Replace since
#Value! isn't text but an error message.
 
=IF(ISERROR("=Networkdays(F2,today()),"","=Networkdays(F2,today())

Not quite right. Try

=IF(ISERROR(NETWORKDAYS(F2,TODAY())),"",NETWORKDAYS(F2,TODAY()))

In Excel 2007, you can use the new IFERROR function.

=IFERROR(NETWORKDAYS(F2,TODAY()),"")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
Back
Top