Posted to microsoft.public.excel.programming

Ram

external usenet poster

Posts: 138

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extracting Values and inserting Rows/Values	VexedFist[_2_]	Excel Programming	3	April 22nd 08 02:37 PM
Inserting rows without changing formula values	Hook''em 2006	Excel Worksheet Functions	5	December 27th 06 09:45 PM
Inserting a cell changes my formula values	shallina	Excel Worksheet Functions	2	August 18th 06 05:42 PM
Inserting values	Tom Ogilvy	Excel Programming	0	September 7th 03 01:32 AM
Inserting values	Chip Pearson	Excel Programming	0	September 7th 03 01:20 AM

All times are GMT +1. The time now is 06:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us