Autofit columns in a range

I've done this simple code. But I want it to execute automatically?

Please Login or Register  to view this content.

It's in the VBA code of a specific sheet.

Any suggestions (including improving existing code...I'm a new at this :-) )?

Regards,
Niklas

What do you mean by automatically? When do you want it to run?
You can shorten it to:

Please Login or Register  to view this content.

Note: I have added code tags to your post, but you must learn to use them in future when posting code.

That should happen anyway, but you can put this into the worksheet code module (right-click the sheet tab and choose View Code, then paste it in)

Please Login or Register  to view this content.