Cells 1, 1 , LookIn: Can anyone help?
View the most recent newsletter. Regarding the second point: I1000 results in a circular reference, and if I change the RC ref to -250 it flips the sum range where there are less than 250 rows above the activecell.
You may leave a space or two if you wish. You can find a version of this tip for the ribbon interface of Excel Excel 2007 and later here: But all the functions that are available through the main Excel screen can also be accessed using VBA code. Hot Network Questions.Learn VBA Code Sum a Column In Excel
I hope you find this to be useful. Go back to your spreadsheet and you should see this:.
Hi Tim, Are you using. R[-1]C " 'Col J Which works well as long as there are only 10 rows.
Thanks so much man. I6 " it works OK.
Author Bio. If you want to sum values then use the following: What happens instead?
Learn more about Allen... Related 537. I hope that I have been of some help. Welcome to the forum.
Mohamed Khairt Mohamed Khairt 11 1. Click anywhere inside of Sub and End Sub. CaBieberach CaBieberach 1,503 2 15 24.