Autosum VBA: formating the Total

**mr_mango81** · 04-19-2013, 02:45 AM

I've got the following code from a thread which works very well. It places an autosum at the base of number ranges. I would like to know how to add a format change to this code to change the format of each cell to "Calculation".

I would like to also the cell adjacent to the autosum total to display the text "Total" and be in the same format as the autosum.

Please Login or Register  to view this content.

Help would be greatly appreciated

**:) Sixthsense :)** · 04-19-2013, 03:04 AM

change the format of each cell to "Calculation"
autosum total to display the text "Total"

Not clear about your above requirement

can you please explain it in brief for better understanding?

**mr_mango81** · 04-21-2013, 06:02 PM

I've attached a example of what I'm trying to acheive. If you run the macro "Monthly_Fuel_Report" it sorts the data from columns A:F into summary by Plant/Job No in the columns H:M and O:T respectivly and gives a total for amount of fuel used for each item. I'm trying to format the total to look like the second worksheet "Weekly Fuel Summary(after)"

Thanks again for your help!