Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting the values of a formula using vb
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting the values of a formula using vb
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting the values of a formula using vb
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Values and inserting Rows/Values | Excel Programming | |||
Inserting rows without changing formula values | Excel Worksheet Functions | |||
Inserting a cell changes my formula values | Excel Worksheet Functions | |||
Inserting values | Excel Programming | |||
Inserting values | Excel Programming |