How to adjust macro to format different worksheets?

On both sections you are missing a . infront of Columns, it should be

Please Login or Register  to view this content.

otherwise those 2 lines will work on the active sheet

Thanks, that fixed the autofit part but the

HTML Code: 

section still doesn't format properly for either tab.

Also any ideas on how to automatically sum all of column C in the incoming and outgoing tabs? The range changes.

Try

Please Login or Register  to view this content.

Note I've moved the Next i & end with.

I get an error "Compile error: For without Next". See attachment and run.

You've deleted the

Please Login or Register  to view this content.

Not moved them

That was it! Sorry I read it the first time you posted but I didn't catch it.

Thank you

Glad to help & thanks for the feedback