Worksheet calculations VBA

[wrightyrx7]

Hi all,

I have a workbook with with 10 worksheets.

Can anyone create a macro that will do the following on worksheet(2) to worksheet(10)

1. Autofit column widths
2.Sum columns H and I on each row into column J with the header Total
3.Change column J to VALUES

If you need anymore information please ask.

Thanks in advance
Chris

 

[HalfAce]

I would reverse the above two statements so that AutoFit would apply to the totals generated by the SUM formula.

Yep, that would be the way to go.
(That's what I get for just slappin' a quick answer in there...)