About Us

--
ve_2nd_at. Randburg, Gauteng, South Africa

"Tushar Mehta" wrote:

For a non-VBA solution, double-click the right-bottom corner of G11.
The later versions of XL will automatically fill G for as many rows as
there is data in F.

For a VBA solution, see example 4 in
Beyond Excel's recorder
http://www.tushar-mehta.com/excel/vb...rder/index.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I am an ordinary accountant but not familiar with macro & VBA. I have a
file, I need to copy a source formula to a certain range of which
starting position has fixed already and ending position would be
altered regarding to condition changed.
For example, say
source formula : locating at cell G11
conditions : range of row containing data in column F starting
from F11

Says now, there are 10 data starting from F11 to F20, therefore I need
to copy the source formula from G11 to G20.

Same as, when there are 100 data starting from F11 to F110, I need to
copy the source formula from G11 to G110.

Can someone advise me how to specify the range in performing a macro in
Excel v2002. Thank you very much.

Eric C

--
Eric C

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I edit a Named Range using macro's	behmer	Excel Worksheet Functions	2	July 26th 05 09:02 PM
How do you copy RANK w/o it changing the range?	jspan	Excel Worksheet Functions	1	June 21st 05 02:56 AM
Macro to copy range from Excel files in folder	nc	Excel Discussion (Misc queries)	1	June 15th 05 11:11 AM
Is it possible to set a variable range in a macro?	Mary	About this forum	0	June 12th 05 06:26 PM
Set Data Range by Variable	MJSlattery	Excel Discussion (Misc queries)	4	June 10th 05 07:48 AM

Menu

About Us