View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ram Ram is offline
external usenet poster
 
Posts: 138
Default Inserting the values of a formula using vb

HI All,

Do you know where the error is below

Thanks for any help

With Worksheets("tblFaxMailBox").Range("F2:F" & LASTROW)
.Formula=
"= NETWORKDAYS(RC[-2],RC[-4],Holiday!R2C[-4]:R11C[-4])"
.Value = .Value
End With