View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] cardioblack@gmail.com is offline
external usenet poster
 
Posts: 3
Default Getting rid of "#VALUE!"

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.