Hello,
Using the code below I was able to sucessfully merge the given cells but I am now unable without any such luck to Center the Range A1:P1
Any ideas as to what the code would be to center text in the specified row given the code below?
Thanks for everyones help in advance,
Cheers,
Jay
Please Login or Register to view this content.
Try replacing
WithPlease Login or Register to view this content.
Additional items available (among others) for manipulation should you need them (and would be placed within the With/End With) include:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by AlvaroSiza; 05-07-2012 at 01:43 AM.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks