I recorded a macro to place a vlookup formula in four cells that are side by
side. When I run the macro it only performs the first task, it does not go on
to do the other three. I used the tab key to go to the next cell while
recording the macro, I don't know if that's why it's not working or if it's
something else.
The script looks like this:
Sub EERates()
'
' EERates Macro
' Macro recorded 3/4/2005 by BCBSOK
'

'
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Sheet1!R3C1:R102C2,2,0)"
Range("F15").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-3],Sheet1!R3C4:R102C5,2,0)"
Range("G15").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-4],Sheet1!R3C7:R102C8,2,0)"
Range("H15").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-5],Sheet1!R3C10:R102C11,2,0)"
Range("E16").Select
End Sub



Any help would be appreciated!

Thanks!