Two questions.

1. How do you increase the width of an excel column to match the length of the longest piece of data put into it. Have tried using len from within vb but this still doesn't seem to increase the width to the widest required.

2. How do you insert a heading into Row 0, and then centre it over the columns in the worksheet, once again from within code in vb.

Have tried recording macros etc in Excel with no success.