I currently have a Range("A1:C3"). I need to be able to add rows and columns to this range. I have already developed the code for this.
I am currently using the following to autosum my columns. This updates correctly and effectively calculates my sum when I add in new rows.
Range("Sites").Select
Application.CommandBars.ExecuteMso ("AutoSum")
However, I cannot come up with any code to allow me to calculate my rows.
I was using R1C1 but I need the ability to enter an unlimited number of rows and still correctly autosum.
Any help/advice is appreciated.