-
Dec 13th, 1999, 10:06 AM
#1
Thread Starter
Addicted Member
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|