Hi All,
I did post about this awhile ago and I am sorry to say my problem is still not resolved
A quick recap - I have varying list of values in a column and I wish to add an AutoSum calculation at the bottom whilst executing a macro.
I currently have the following .. (extract only) :
Application.CommandBars("Standard").Controls("&Autosum").Execute
Application.CommandBars("Standard").Controls("&Autosum").Execute
ActiveCell.Offset(2, 0).Select
Selection.Copy
Range("J60").Select
This code works well in Excel 2000 but 'falls down' in Excel 2002. I have tried a few variations on the AutoSum command but to no avail!
This is so frustrating! Any ideas?
Thanks
S
I did post about this awhile ago and I am sorry to say my problem is still not resolved
A quick recap - I have varying list of values in a column and I wish to add an AutoSum calculation at the bottom whilst executing a macro.
I currently have the following .. (extract only) :
Application.CommandBars("Standard").Controls("&Autosum").Execute
Application.CommandBars("Standard").Controls("&Autosum").Execute
ActiveCell.Offset(2, 0).Select
Selection.Copy
Range("J60").Select
This code works well in Excel 2000 but 'falls down' in Excel 2002. I have tried a few variations on the AutoSum command but to no avail!
This is so frustrating! Any ideas?
Thanks
S