Excel Macro - Go to Cell below formula

[newworld51]

I've been trying to record a Macro and this part has me stuck.

Need to insert formulas (F5 & F7) above and below the Subtotal formula.

Since the data table changes with each update, the reference changes.

Thanks for any help!!!!

Colm F
1 x
2 x
3 x
4 x
5 =A7
6 Subtotal Formula
7 =(SUMIF(A2:A7),"L",F2:F7)

 

[AnotherHiggins]

Please repost this VBA/Macro specific question in forum707, the VBA Visual Basic for Applications (Microsoft) Forum.

You may also want to have a look at FAQ707-2112 or FAQ707-2115 for tips on how to find the last row.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.