I would like some help to see if I can total one column of numbers where the last row will always vary. The 1st row is headers (i.e. Order Number, Customer, Date Requested, etc), columns are A - Z & are constant. My header in J1 will be a word (qty) and the rest of the column will be numbers. Can I total the numbers via vba and put the answer in the cell after the last row in column J? I would like to do this w/ vba and using a command button.