macros!!

[Sarah_Lecturer]

Hi,

Please can you help me to do the following

Have figure in E2 and F2

Want to do the following

Insert column between F&G
Multiply E2 by G2
Copy formula to bottom of table (this changes length)

Thanks

Sarah xx

 

[Tom Ogilvy]

Dim rng as Range
Column("G").Insert
set rng = Range(cells(2,"F"),Cells(2,"F").End(xldown))
rng.offset(0,1).Formula = "=E2*H2"

I assume when you say multiply E2 by G2, it is really H2 after inserting a
column Before column G (that column becomes the new G).

 

[Sarah_Lecturer]

You are correct Tom - of course!!!

Thanks very much - great help!

Sarah xx