Excel Macro - Find Cells & Insert 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)

 

[SkipVought]

Hi,

John already directed you to postings that suggest methods of locating the last cell.

My tip is in regard to the subtotal.

Does the Data/Subtotal... FEATURE (not FUNCTION) not meet this requirement?

Do you have multiple subtotals or one total?

If the answer is ONE, then my question is, why stick it at the bottom, where the user has to search for the important piece of information. Putting totals BELOW a table is a sad vestage of paper, pencil and adding machine. With the advent of spreadsheets, it's possible to put these aggregations anywhere, like right at the top! On a multi-page report (printed or not) I put my totals and subtotals at the top, where they are visible, using Window/Freeze Panes, at all times.

Think about it.

Skip,
[sub]
[red][/red]
[/sub]

 

[newworld51]

Thanks Skip,

I guess what I'm really trying to do, In my macro I need to go the cell above the last value in a column and the Macro puts in a formula in that cell.
The same thing for the cell below the last value in that column.

Many Thanks,

Alan

 

[SkipVought]

Did you check out John's suggestion? If so, what code did you use in your workbook?

Skip,
[sub]
[red][/red]
[/sub]

 

[CarmenWilliams]

I need to insert a formula on my subtotal row after the data has been refreshed in excel 2003. does anyone know how?

 

[SkipVought]

CarmenWilliams,

Please post in a NEW THREAD.

Skip,
[sub]
[red][/red]
[/sub]