Prev: Programmatically Adding a Worksheet_Change Event Procedure to a Pr
Next: Insert comment into cell
From: ram on 22 Apr 2010 10:28
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
From: ram on 22 Apr 2010 10:49
HI I found the error. I needed to add R1C1

"ram" wrote:

> 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
From: Mike H on 22 Apr 2010 10:49
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.


"ram" wrote:

> 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
From: Dave Peterson on 22 Apr 2010 10:55
If you're going to use that R1C1 reference style, then make sure you use:
.formulaR1C1 =

Not
.formula =



ram wrote:
>
> 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

--

Dave Peterson
 | 
Pages: 1
Prev: Programmatically Adding a Worksheet_Change Event Procedure to a Pr
Next: Insert comment into cell