Hi
Just in case you all thought I had left, forgive me - husband has been in hospital so things have been a bit hectic.
I have now officially given up and am pleading for help, before I go totally insane. I cannot get a line in my macro to work - and I have tried almost every combination known to mankind, (except obviously for the right one)!
Scenario - worksheet will always remain constant in name - Col E will always be the relevant column. Col E will be populated with numbers and the amount of rows populated will continually differ after each population.
Required - I need a line that will go to the next empty cell in Col e after the populated data - then I want to put in a "SUM" function that will add all the populated data in Col E and obviously give the result in the empty cell immediately under the data. Dead Easy - but do you think I can get it right - I have tried FormulaArray, FormulaR1C1 and ActiveCell, Offset etc etc - not a chance.
This is my latest attempt - no laughing guys pls!!
[VBA]Sub summing()
'
' summing Macro
' Macro recorded 2005/12/04
'
'
Range("E1").Select
Selection.End(xlDown).Offset(1, 0).Select
ActiveCell.FormulaArray = "=Sum(Offset(ActiveCell,-1,0))"
End Sub [/VBA]
It is bringing me back a "NAME" error - you will all obviously know why, but I am clueless. I need to do it via script because recording it just puts the actual cell address in and of course that will change every time data is populated, which is daily.
Please give me a hint - then I'll kick myself.
Thanks & take care
Amanda