Modifying VB Code:Excell Macro and Visal Basic Programming

[aero777]

Hello All.

I am very new to using Excell Macros, infact just a few hours of use till now.I need a quick help on Macros.
I have a formula in cell B4, which I would normally drag all the way to another cell,B14 .So I created the macro , by pushing the record Macro option. Here it is below.

Please Login or Register  to view this content.

Question : How can I change this script so that the Macro is executed from cell B4 to BX , the number X , would be decided by a value in cell B2. If the value is 10 ,
then the macro should execute from "Cell:B4" till "Cell:Address of B4 + 10"

[DonkeyOte]

Without knowing the actual formula in B4 I would opt for something along the lines of:

Please Login or Register  to view this content.

[aero777]

Hello,

Thank you for your reply....

WoW!

That works... Thank you again..

Untill my next querry!
My Best Regards,
Aero777

[DonkeyOte]

re: the formula... INDEX should suffice and has the added advantage of being non-volatile unlike the existing formula

Please Login or Register  to view this content.

In code terms just apply the formula in one go (including B4 itself)

Please Login or Register  to view this content.

Where B2 contains how many extra formulae are required in addition to that in B4.