Posted to microsoft.public.excel.misc

orquidea

external usenet poster

Posts: 132

Networkdays formula in macro

Hi:
I want to write the statement ActiveCell = "=NETWORKDAYS(I2,O2)"
replacing I2 with ActiveCell.Offset(0,-9) and O2 with
(ActiveCell.Offset(0,-3). My string below gives me the error #NAME?

ActiveCell =
"=NETWORKDAYS((ActiveCell.Offset(0,-9)),(ActiveCell.Offset(0,-3))"

Could anyone help me please.

Thanks,
Orquidea

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
NETWORKDAYS formula	orquidea	Excel Discussion (Misc queries)	5	February 15th 08 07:43 PM
need help with networkdays formula	aashishtaneja	Excel Worksheet Functions	1	September 5th 07 01:06 PM
Networkdays formula	Silvie4	Excel Worksheet Functions	4	June 14th 06 09:14 PM
NETWORKDAYS FORMULA	Lichase	Excel Worksheet Functions	1	June 9th 05 09:24 PM
NETWORKDAYS help with the formula	Zoeb1979	Excel Discussion (Misc queries)	1	May 9th 05 03:13 PM

All times are GMT +1. The time now is 04:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us