Locating variable range to copy
 

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

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/vba/beyond_the_macro_recorder/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

I need a VBA solution and get idea after reading your web page.
Thank a lot.
Eric C

--
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