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.
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.