Formula for moving target in macro

[Michel]

Hi
I am very used to making macros with Lotus123 ... yes, the oldie one.
But now i am lost with Excel.

Lets say i am in a column F for ex.
The number of lines is not constant.
I want to copy the formula in F9 to cells frim F10 to the end of the
ciolumn.
In Lotus i would go to the {end}{bottom}
How do i do in Excel ? I am really lost with this VB language.

Help is very welcome.
Michel

 

[Harlan Grove]

I am very used to making macros with Lotus123 ... yes, the oldie one.
But now i am lost with Excel.

Lets say i am in a column F for ex.
The number of lines is not constant.
I want to copy the formula in F9 to cells frim F10 to the end of the
ciolumn.
In Lotus i would go to the {end}{bottom}
How do i do in Excel ? I am really lost with this VB language.

It would be {end}{down}, but I'm assuming you were using a French version of
123 and are trying to translate 123 classic macro statements into English.

Anyway,

Range("F9").Copy Destination:=Range("F10", Range("F10").End(xlDown))

This is precisely equivalent to

/c_{esc}F9~_{esc}F10.{end}{down}~

 

[Michel]

It would be {end}{down}, but I'm assuming you were using a French version of
123 and are trying to translate 123 classic macro statements into English.

Anyway,

Range("F9").Copy Destination:=Range("F10", Range("F10").End(xlDown))

This is precisely equivalent to

/c_{esc}F9~_{esc}F10.{end}{down}~

Thanks.
Michel