Sandy, You shouldn't need to change any of it. You'll need to run it as you would a macro whenever you want it to happen, though, and before you do, select the merged cell. Ray _____________ This email is from Ray Blake, Head of Software Design, GR Business Process Solutions. It is confidential and intended for the addressee only. The contents are private and may be legally privileged. If you receive this email in error we would be grateful if you would advise the sender and delete the email from your system. For more information on the services that we offer please visit us at our website: - www.grbps.com -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Sandy Crowley Sent: 30 September 2003 16:53 To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Excel question Ray, Thanks so much for the info!!!! Because I'm not fluent in VBA (yet), which parts of the code will I change for my document? Also, another puzzlement: I have told the text to wrap in the same pesky cells that don't expand. When I type in them, the text wraps (as it should) but when another user types in it, it doesn't wrap. AAAAGGGGHHHH!!!!! : ^) Sandy Crowley, SDA, CDT Director of Administration | Senior Associate Little Diversified Architectural Consulting 5815 Westpark Drive | Charlotte, NC 28217 D:704.561.5135 | M:704.408.0458 | F:704.561.8734 www.littleonline.com <http://www.littleonline.com/> ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************