Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Line insert
Hi Frank
Thanks for the suggestion but I realy need to put the total at the bottom so if you could help I would be grateful. Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Line insert
iLastRow = Cells(Rows.Count,"A").End(xlUp).Row Cells(iLastRow+2,"A").FormulaR1C1= "=SUM(R1C:R[-2]C)" change the column "A" to suit. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "benosc" wrote in message ... Hi Frank Thanks for the suggestion but I realy need to put the total at the bottom so if you could help I would be grateful. Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need VBA script to auto-insert value upon row insert | Excel Worksheet Functions | |||
Auto-Insert Line Break (Alt+Enter)? | Excel Discussion (Misc queries) | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
Auto Insert/Auto Formula? | Excel Worksheet Functions | |||
auto insert blank line | Excel Discussion (Misc queries) |