Posted to microsoft.public.excel.programming

Richard[_20_] Richard[_20_] is offline

external usenet poster

Posts: 16

Nesting a formula in a macro

I have the following at the beginning of a macro:

R = Range("L1").Value

Is there a way to replace "L1" by the formula used in L1
itself.

Before excecuting the macro I put the following formula in
L1: =COUNT(I2:I100).

Basically, is it safe to directly replace ("L1") by its
formula?

Thanks for any help.

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
Can you help nesting a formula?	Da Bossman	Excel Worksheet Functions	7	August 13th 07 10:00 AM
NESTING FORMULA	Tonya	Excel Worksheet Functions	1	August 29th 06 09:21 PM
Nesting Formula	DSCAVOTTO	Excel Discussion (Misc queries)	4	May 22nd 06 05:36 PM
Formula nesting	BSantos	Excel Worksheet Functions	6	January 19th 06 06:20 PM
nesting another formula	BSantos	Excel Worksheet Functions	3	January 18th 06 09:22 PM

All times are GMT +1. The time now is 05:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us