Inserting the values of a formula using vb

  • Thread starter Thread starter ram
  • Start date Start date
R

ram

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
 
Hi,

There's nothing wrong with the code so you should look at how your setting a
value for LastRow. It should be something like

LastRow = Cells(Cells.Rows.Count, "B").End(xlUp).Row

or you may choose to use column D


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
If you're going to use that R1C1 reference style, then make sure you use:
.formulaR1C1 =

Not
.formula =


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
Click to expand...
 
Back
Top