Formula for moving target in macro

  • Thread starter Thread starter Michel
  • Start date Start date
M

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
 
Michel said:
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.
Click to expand...

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}~
 
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}~
Click to expand...
Thanks.
Michel
 
Back
Top