Copy a formula to specific number of cells to the right

[akabraha]

Hello,

I am trying to copy a formula to say 12 cells to the right of active cell - I tried to use the following code, but it's copying the formula to entire cells to the right.

Question is how to modify the code to copy the formula to only specific number (that I know) of cells to the right.

Please Login or Register  to view this content.

Appreciate your help in advance.

Thanks, DoubleA

[Ikaabod]

This should work. Just change the "12" to whatever number you want to copy over to.

Please Login or Register  to view this content.

If you wanted could do something like this:

Please Login or Register  to view this content.

or link myNumber to a cell value somewhere in your spreadsheet

Please Login or Register  to view this content.

[akabraha]

Thanks a lot, this is exactly what I wanted..