clear contents of cells that are merged using a macro

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - how do i choose which file should open when I start an office app. When I start MS WORD application, a certain file opens every time. Is there any way I can change it to some other file or a new doccument? Tag: clear contents of cells that are merged using a macro Tag: 293280
  - 2
    - Microsoft Office XP Professional Here is the problem. After installing Microsoft Office 2007, everytime I open anything on my computer, i.i. IE, Outlook Express, Microsoft Outlook, the Windows installer activates and tries to look for Microsoft Office XP professional PRO.msi on my CD and can't find it. It's their but it says that it's not the disk???? I tried to uninstall it but I get the same message. I can't seem to uninstall any office xp software without getting the same message. I'm at my whit's end. please email here or at htallett@att.net. Thanks. Tag: clear contents of cells that are merged using a macro Tag: 293279
  - 3
    - How do I merge 2 pictures as one (sandwiching)? I am attempting to take a picture where I deleted the background thur "paint" and use a different background, but everytime I just do a simple copy and paste, the white of the background I deleted is still there and the new one I want to use is no longer. can anyone help me? Tag: clear contents of cells that are merged using a macro Tag: 293278
  - 4
    - Formatting Options Within Charts in MS Word? Hi folks, I'm working on a document with charts throughout, and my editor has made a request that I'm not sure I can comply with given MS Word's capabilities. Legends in charts; I have chart legends with 5-6 labels where some labels occupy a single line and some are longer and hence occupy 2 lines. Word appears to automatically space chart legends so that the legend keys (the little colored squares) are equidistant. This means that there looks like there's a line space below the one-line entries. Is there any way to shift the legend entries around so that this illusion disappears? Any and all suggestions welcome. :) -- Fruzzle ------------------------------------------------------------------------ Fruzzle's Profile: http://forums.techarena.in/member.php?userid=48537 View this thread: http://forums.techarena.in/showthread.php?t=963786 http://forums.techarena.in Tag: clear contents of cells that are merged using a macro Tag: 293275
  - 5
    - Office Standard 2007 update question This is a multi-part message in MIME format. ------=_NextPart_000_001C_01C8B049.35DDD210 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a new computer, desktop, and in the process of installing all the = basic software programs I that usually use. One of those is Office = Standard 2007, ( Word 2007; Excel 2007; PowerPoint,2007 and Outlook = 2007). I installed it did not check to see if all working okay as I have = nothing to view. I when to update office and after jumping through = different hoops end up at this WEB page to update = https://www.microsoft.com/downloads/thankyou.aspx?familyId=3D9ec51594-992= c-4165-a997-25da01f388f5&displayLang=3Den# on this page it has the = update listed office2007sp1-kb936982-fullfile-en-us.exe to click on to = do the down load and I noted that the file size was listed as 218.3 MB. = Now I am on a dialup modem at 50.6 kbps so it take some time enough, so = a couple of time my connection got drop, but was able to resume the = download process. After two plus days the update was downloaded (speed = of download was about 26 kbps, I have two other computers sharing the = same access) , but the file size was only 168 MB (176,454,317 bytes) = that is about 50 MB short so the question is what give here is this = normal or not. One option I have is to take my laptop out to town to a = high speed connection and try to redownload the updating file to see if = I get the full file size, which may have unknown conquests as the laptop = has Office 2001 on installed. I normally save files to a folder then run = the update. ------=_NextPart_000_001C_01C8B049.35DDD210 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.6000.16640" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I have a new computer, = desktop, and in the=20 process of installing all the basic software programs I that usually = use. One of=20 those is <FONT size=3D2>Office Standard 2007, ( Word 2007; Excel 2007;=20 PowerPoint,2007 and Outlook 2007). I installed it did not check to see = if all=20 working okay as I have nothing to view. I when to update office and = after=20 jumping through different hoops end up at this WEB page to update <A=20 href=3D"https://www.microsoft.com/downloads/thankyou.aspx?familyId=3D9ec5= 1594-992c-4165-a997-25da01f388f5&displayLang=3Den">https://www.micros= oft.com/downloads/thankyou.aspx?familyId=3D9ec51594-992c-4165-a997-25da01= f388f5&displayLang=3Den</A>#=20 on this page it has the update listed=20 <U>office2007sp1-kb936982-fullfile-en-us.exe</U> to click on to do the = down load=20 and I noted that the file size was listed as 218.3 MB. Now I am on a = dialup=20 modem at 50.6 kbps so it take some time enough, so a couple of time my=20 connection got drop, but was able to resume the download process. After = two plus=20 days the update was downloaded (speed of download was about 26 kbps, I = have two=20 other computers sharing the same access) , but the file size was = only 168=20 MB (176,454,317 bytes) that is about 50 MB short so the question is what = give=20 here is this normal or not. One option I have is to take my laptop out = to town=20 to a high speed connection and try to redownload the updating file to = see if I=20 get the full file size, which may have unknown conquests as the laptop = has=20 Office 2001 on installed. I normally save files to a folder then run the = update.</FONT></FONT></DIV></BODY></HTML> ------=_NextPart_000_001C_01C8B049.35DDD210-- Tag: clear contents of cells that are merged using a macro Tag: 293262
  - 6
    - How to permantently hide clipboard pane on the right side of Word/Excel 2003? Whenever I cut or copy text from/into a Word/Excel 2003 doc then on the right side a clipboard overview appears showing all previous clipboard snippets. How can I permanently (!) hide this pane? Currently I have always to click the "close" button. But after the next clipboard operation the clipboard pane re-appears. Goran Tag: clear contents of cells that are merged using a macro Tag: 293261
  - 7
    - Why are my Office programs stalling? When I use Word, Office and Excel, every few minutes my cursor turns into the hourglass and just hangs there for about 10 seconds. I think this started after I installed Acrobat Professional 8, so I uninstalled it to download some Office updates, etc. The hang ups didn't occur while Acrobat wasn't running, and started again when I reinstalled it (I think). However, uninstalling Acrobat a second time didn't fix the stalling, so I've reinstalled it and am trying not to get too annoyed at the constant stalling. Doesn't happen when I'm using Explorer or Acrobat. Any brilliant solutions out there? Tag: clear contents of cells that are merged using a macro Tag: 293260
  - 8
    - Wildcard characters for instant search There are apparently no wildcard search characters for instant search in Office 2007. It would be nice to have some wildcards available for more flexible searches. Furthermore, searching for items that include custom fields, for numeric reference or index numbers, can be difficult without wildcards due to anomalies in searching for numbers with character separators. For example, the user may use a custom genealogical field for Outlook Contacts to sort relatives according to relationship. In such a case, â??Smith 51-10-00-00-00" up to â??Smith 51-19-99-99-99" might represent a specific branch of the family including children, grandchildren, etcetera in proper birth order. As such, searching for â??Smith 51-1" would presumably include everyone in that family line shown above, unfortunately, the actual search returns zero results. Perhaps, the search engine is interpreting numbers and delimiters in a way we do not understand. Nevertheless, we suspect that wildcard search characters ( "?" for character or "*" for multiple characters) would help with this type of a search, not to mention with many other more common searches! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=77e51cbf-cd6e-45ee-be0c-6f982cb1a1bd&dg=microsoft.public.office.misc Tag: clear contents of cells that are merged using a macro Tag: 293246
  - 9
    - Office Professional - Work at Home purchase - laptop and desktop I purchased a version of Office Professional through my compnay for the work at home program. Can I install that on my home laptop and home desktop - both of which are mine? Or do I need to keep it on one or the other? Licensing is hard to decipher! Tag: clear contents of cells that are merged using a macro Tag: 293245
  - 10
    - Job aids with quick tips for PowerPoint, Excel and Word? Wondering if anyone knows of any job aids that provide quick tips for PowerPoint, Excel and Word that I could purchase? Tag: clear contents of cells that are merged using a macro Tag: 293244
  - 11
    - Playing movie in Powerpoint Slide When we get to the slide that is playing a movie you have to click the movie for it to start. Is there a way for it to just Play when the slide comes up. No user action needed? Also - when the clip is over is there any way to automatically bring up the next slide? Thanks, Tag: clear contents of cells that are merged using a macro Tag: 293242
  - 12
    - PowerPoint hyperlinks and action buttons I have a hyperlink action button to another PPT file?. I am using a button on the screen that the user can mouse over or click. Is there any way for the hyperlink to be executed by hitting 'next' on a slide and for that command to open the new PPT file? So the presenter can just hit next the whole time. Here is you hit next without executing the action button it will go to the next slide, skiping the hyperlinked presentation that should come up. I am trying to avoid this. We use Powerpoint 07 and 03. Thanks, Tag: clear contents of cells that are merged using a macro Tag: 293241
  - 13
    - Sending e-mails from Word and IE I'm running Word 2002, sp3 and IE 7 with all current updates. About a month ago I began to find that attempting to send an e-mail message from either of these programs consistently results in a time out of the message attempt. I get the notice that my mail server has been contacted but that's where it all stops. As a result I have to hit the Stop and Hide buttons, bring up my Outlook Express (I don't use Office Outlook) and hit the Send and Receive button. This will connect and send the message each time. Has something changed as a result of the updates over the past couple of months that would prevent messages from being sent from Word 2002 and IE7? Thanks. Tag: clear contents of cells that are merged using a macro Tag: 293239
  - 14
    - Job Manifest I run a small fleet of trucks, delivering the same equipment multiple times to the same customer, I need a manifest, or job ticket that can easily reflect the equipment moved for the entire "job". Each job has 12 loads which are moved from one location to the next. Tag: clear contents of cells that are merged using a macro Tag: 293238
  - 15
    - Change Office 2003 installed on Vista default "baby Blue" color Hi, For specific reasons I needed to install Office 2003 on my Vista Ultimate laptop.( I have Office 2007 but needed 2003 to help a client). Is there a way to change that hideous "baby blue" default color of Office to something more palatable? Like silver or black? Jeff Tag: clear contents of cells that are merged using a macro Tag: 293236
  - 16
    - Passing Visio drawings to Excel I am working in an environment where I am creating documents using Visio 2007. The problem is that not many people in the office have Visio, but they need to be able to edit the documents every so often. I want to know if I can embed the Visio 2007 drawing into an Excel 2003 document with limited editing capabilities - such as entering text or inserting shapes/pictures. The goal is for someone with Visio to create the document, embed it in an Excel file, and send it out. The recipient (who does not have Visio) needs to be able to fill in information in that document and save the changes. Is this even possible for someone without Visio? Is there an easy way to do it, or do I need to write a macro? Any insight is greatly appreciated. Tag: clear contents of cells that are merged using a macro Tag: 293230
  - 17
    - Windows installer keeps popping up in Outlook 2003 [2008-5-7] I bought a new powerful laptop with Vista Business and trial Office 2007. First, I installed Office 2003 side-by-side with Office 2007. Many problems. So I uninstalled both Office 2003 and 2007, deleted the office folder in "c:\program files" and the registry, and re-installed Office 2003. Problem still there: any operation in Outlook will launch Windows installer to configure Office 2003. ANY OPERATION. Receiving an email, delete an email, copying some contacts from one pst folder to another... On my 6-year-old laptop, copying 200 contacts takes 5 seconds, while now on the brand-new laptop it takes half an hour, with the launching of windows installer sessions one after another. Please help! Tag: clear contents of cells that are merged using a macro Tag: 293227
  - 18
    - Cisco Wants You Back! As a networking professional whose certification has lapsed, you are probably asking yourself the following questions: * Should I get recertified? * I have a new role, do certifications matter? * Do employers value Cisco certifications? We believe the answer to these questions is a resounding, "Yes!" Recertification ensure competency. Here is why: Cisco Career Certifications are one of the highest ranking certifications in the IT industry. In fact, many IT professionals and managers believe Cisco certifications bring them more value than their university or technical school diploma! What is more, Cisco is employing new security measures designed to safeguard the integrity of your certification ? and protect its value with employers. A Cisco certification lets the world know you are prepared for what is next in networking ? the next company, the next promotion and the next challenge. So, what is holding you back? Cisco exams can be rewarding and challenging at the same time ? that is another reason they are so highly valued by IT professionals and employers alike, and now is the time to reinvest in your future. For a limited time, Cisco is inviting those whose certifications have lapsed to "Come Back" with a special offer. Register and take any Cisco certification exam at the regular price, and ? if you don it succeed on your first try ? you will get a free second opportunity to pass the exam and Come Back! * Come back to Cisco Career Certifications ? For details on this special offer or to schedule your Cisco certification exam at a Pearson VUE test center today, visitwww.pearsonvue.com/cisco/comeback Click here to view the Cisco recertification policy. Wishing you the best on your career investment. Cisco Career Certifications * Both the full price and free "Come Back" exams must be taken between April 21, 2008, and October 15, 2008. The free exam must be the same exam number as the exam you failed. This article comes from: http://www.killtest.com -- killtestcom Tag: clear contents of cells that are merged using a macro Tag: 293226
  - 19
    - How can I make Office 2003 look like Office 2000? At work I've just had an upgrade to Office 2003. The toolbars and menus are no longer in line with the personalised settings as set by my control panel. My display settings had been set up specially to prevent me getting eyestrain and since the upgrade, with these setting not being followed, I am getting quite severe eyestrain again. Is there any way I can get Office 2003 work with my personalised display settings? My IT colleagues are suggesting this may not be possible. Tag: clear contents of cells that are merged using a macro Tag: 293225
  - 20
    - EXCEL 2007 I use MS Office 2007 on my work PC and 2003 on my home PC?. I want to upgrade just Excel to 2007 at home. If I purchase it, will it work on my home PC if I am using the older Office version? My home PC is running Windows XP Tag: clear contents of cells that are merged using a macro Tag: 293224
  - 21
    - Korean Office 2007 to English My family purchased Office 2007 in Korean, and was wondering how we can change the Korean language to English on all settings where Korean is no longer shown. Do I have to purchase an update to change it? Please help!!! Tag: clear contents of cells that are merged using a macro Tag: 293222
  - 22
    - Microsoft Publisher 2007 I am designing a webpage using microsoft publisher 2007. I want to publish my webpage and I have a domain that I own. I need to find out how I can publish my webpage using my domain. Not using the suggested ideas that they suggest. Thank you for any help that this may result in. -- Wayne M. Heffner Tag: clear contents of cells that are merged using a macro Tag: 293219
  - 23
    - office ultimate 2007 upgrade what's up everybody, I just purchased office 2007 ultimate. I currently have office xp for students and teachers intalled. Is it recommended to uninstall the xp before installing the 2007, or can I just install it over xp? thank you, L PS I am running vista home premium. Tag: clear contents of cells that are merged using a macro Tag: 293218
  - 24
    - suggestions in outlook 2k3 Hello all, Is there a way in Outlook 2003 to edit the suggestions that Outlook offers you after typing in the first couple of letters of someone's email address? Thanks, Tag: clear contents of cells that are merged using a macro Tag: 293208
  - 25
    - Powerpoint Show stalls stops Office 2007 powerpoint on MCE, 2 monitors, Program runs on main monitor and displays on 2nd monitor. Click on resume show and it seems to work but will stop later. This presentation runs 24/7 unattended. Any ideas on why it stops running or is there a better way to do this? Tag: clear contents of cells that are merged using a macro Tag: 293207
- Next
  - 1
    - Bubble Charts in PowerPoint 2007 I am trying to create a bubble chart design template that I can apply to multple slides. I am able to get this concept to work with bar charts, etc, but am having trouble with the bubble charts. I can create and save the templates fine. I will then add a new slide and apply the design template. Once I try to import new data from an exsiting excel spreadsheet (it is already in the correct format). Nothing appears on my chart area. I have checked and the scales are not changing. I can copy and paste the same data into a bubble chart when I create a new chart without applying a template and there are no problems. Can anyone help? Thanks Tag: clear contents of cells that are merged using a macro Tag: 293206
  - 2
    - Restrict Deletion of mails We use a group mailbox where access to all the team members is given by Active Directory Group WE wnat to restrict the deletion of mails only, they should be allowed to modify the mails or create subfolders Please advise how i can do this Tag: clear contents of cells that are merged using a macro Tag: 293205
  - 3
    - unable to connect to server... error 0x800ccc0e Running XP pro, SP2 with all updates. Office 2000 with all office updates applied. I have 7 mail accounts setup, all sending and receiving, POP3..some ports configured outside the default values as outliend by the respective ISP's, and server tineouts set to 2 minutes. Each day, one of the 7 mail accounts will stop sending/receveing with the popup dialog error of "unable to connect to server... error 0x800ccc0e". The fix is to delete the mail account and re-add. I have run the Norton removal utility to remove all prior Norton/Symantec products version. There is no anti-virus running currently. I have un-installed and re-installed Office 2000 but same condition exists. There is no one specific mail account that has a problem it seems to randomly pick one of the 7 each day. Help????????? Tag: clear contents of cells that are merged using a macro Tag: 293199
  - 4
    - How to permanently remove toolbars in Outlook 2007? or at least Lock them? Everytime I click Mail, Calendar, or Contacts in Outlook I get a new standard toolbar. I end up with about 15-20 before I know it! I can right click and turn them off but they keep coming back. I can't figure out how to lock toolbar or delete all of them. I reinstalled Outlook and it didn't help. Even when they are turned off I still have hundreds of instances of the standard toolbar to select on or off in the customize toolbar menu. I can see where the delete button is but it is grayed out. Anyone know of a reg key or file I can manipulate? Or at least a hack to lock toolbar in Outlook 2007 so they don't turn keeping coming up? Thanks! Barbie -- project109x ------------------------------------------------------------------------ project109x's Profile: http://forums.techarena.in/member.php?userid=48384 View this thread: http://forums.techarena.in/showthread.php?t=962935 http://forums.techarena.in Tag: clear contents of cells that are merged using a macro Tag: 293198
  - 5
    - duvidas gostaria de saber como add uma musica que estÃ¡ em minhas pasta "musicas" em um slide em pps, alguem pode me ajudar? Tag: clear contents of cells that are merged using a macro Tag: 293195
  - 6
    - Normal.dot & Normal.dotm Hi Can Normal.dot & Normal.dotm be deployed to all users Via Group Policy ?? I've created a cutom Normal.dot & Normal.dotm and need to deploy this all users profile !! Tag: clear contents of cells that are merged using a macro Tag: 293192
  - 7
    - scanner I have a dell all in one scanner setup on my PC. It scans pictures great but I want to scan a printed excell sheet and then use it. How do I do this? I opened Office Imaging but it does not see my scanner. How do I set up Office to recognize the scanner? Tag: clear contents of cells that are merged using a macro Tag: 293185
  - 8
    - Is the 'free' Office 2007 transferrable? I've got a 'free' version of Office 2007 from the Vista/Office 2007 rollout event (I received a valid Product Key from MS at the event), and it's time to get a new computer (I've been spending 25% of my time just trying to keep this one working!). I guess that this isn't technically a 'Retail' version as I didn't purchase it, but it's not OEM either as it wasn't on the machine when I bought it. Anyone know if this 'free' version of Office 2007 is transferrable to the new machine? If I don't have to purchase a new copy, it's always nice to save money...otherwise, I'll order a copy with the new machine. Thanks, Steve Tag: clear contents of cells that are merged using a macro Tag: 293184
  - 9
    - Power Together ... I participated in the power together program . I recived my code key by mail with it was a link to download my copy of office. I keeped putting off downloading it ..I went to downloading it the other day and it did not work ..I found out that they changed sites to this)( this web site no longer works also.... What should I do ..is there someone at micriosft that will send be a direct download link or even a disk :) a friend of mine has the enterprise disk ..if I borrow his disk to install and use my code ???? thanks in advance for your help !!! Tag: clear contents of cells that are merged using a macro Tag: 293176
  - 10
    - Wrong Date format I am trying to merge data from an excel spreadsheet with publisher and am getting the wrong date format produced for example the excel spreadsheet contains a date format 24/05/08 and the result i get is 05/24/08. I have checked all the obvious and with regional, keyboard and locale all being okay -- Thanks and regards Tony Tag: clear contents of cells that are merged using a macro Tag: 293170
  - 11
    - Equations in Office 2007 cause errors Hello, I'm using equations in MS Office Word 2007 often. But many themes, usually as I use more in one document, Office seems to be unable to save my documents. How to reproduce: - Create a new document and save it. - Insert a few equations (formulas). - Try to save the document. - Office prompts to choose a filename (Weird because it's already saved). - OK, you pick a filename and then you get the errro: A file error has occured. And the box closes after clicking OK. In Office I cannot align (center/left/right) anything after a certain point (same point when you can't save anymore). Very annoying error. I did install MS Office SP1. I get this error on every PC (Win XP Pro). Anyone knows a fix? Tag: clear contents of cells that are merged using a macro Tag: 293168
  - 12
    - word 2003 readonly file Good Morning, Iâ??m Italian so excuse me if my English is not clear as expected. Iâ??m writing this technical support request because one of my customers has a very very strange problem with Microsoft Word upon saving. Hereâ??s the configuration of the PC: - Microsoft Windows XP Professional SP2, with all the latest updates installed; - Microsoft Office 2003 SP3 Professional Edition; - NOD32 Antivirus System; - Spybot Search and Destroy; - Autocad 2007; - PDF Creator; - Some DWG Viewers; - IBM Client Access for AS/400 My user works with some Word documents, of about 20 Megs-size, with some pics included. I searched over various forums in Internet, and I found that Word allows a maximum of 32 Megs-per-file size, wich is referred to text only. So, my user should not oversize this limit with her documents. These documents are all written in different languages, the user is Italian and the docs are one in Spanish, one in Deutch, one in Portoguese and so on. The problem is described as follows: - the user opens the document, works in it in editing mode normally - then she updates the summary which is placed at the top of the document, selecting-it all and the choosing â??update fieldâ?? - since this step no errors occurs; - when saving, totally randomly, word says that is not possible to save the document because it is in read-only mode, and the user is prompted to save with another file name. This is a very strange error. I tried everything: - installed Office 2007 with the latest Service Pack 1, same result; - disabled and uninstalled the Antivirus system, same result; - copied the files locally, checked the file permissions, everythingâ??s right but the problem persists; - searched the web for any possible solutionâ?¦ I tried everything I caught but the problem persists. After all these steps I prepared a new computer, and the problem remains also with the new PC. So I got no idea about the way to solve the problem. Is there any fix? Any procedure to be followed? Thanks in advance. Tag: clear contents of cells that are merged using a macro Tag: 293166
  - 13
    - Office documents open read-only with WebFolders Hi, all documents opened from within a WebFolder (WebDAV) open READ-ONLY with Vista and Office 2007. Windows XP is fine... Can anyone help? Thanks, Matthias Tag: clear contents of cells that are merged using a macro Tag: 293165
  - 14
    - Move autotext from Word 2003 to 2007 Building Blocks I have tried in vain to move my old autotext entries from Word 2003 to Word 2007 following advice MVP Beth Melton gave on 1/2/2007 to a question by Mike Kuch: renaming the old Normal.dot to AutoText.dot and placing it into user â?? App.Data â?? Roaming â?? Microsoft â?? DocumentBuildingBlock â?? 1031. Then I have moved BuildingBlocks.dotx out of this folder, so that there is only one folder left in the 1031, namely Autotext.dot (which is the renamed file from normal.dot from Office XP). It doesnâ??t work with me. To give an example, I write in Word 2007 NYT and add F3, there will be no reaction, where under Word 2003 it would roduce "New York Times". Where is my fault? I would be grateful for help. Mollius@Online.de Tag: clear contents of cells that are merged using a macro Tag: 293164
  - 15
    - What is the save thumbnail option appear in the save as pop up? What is the "save thumbnail" option appear in the bottom left of the "save as" pop up? Is it suppose to let the file appear as a thumbnail instead of just an icon? If this is the case, how come it only appear in Word and Excel but not Powerpoint? This is because the Powerpoint files always appear as a thumbnail in my desktop and I wish to be able to choose whether I want it to appear as an icon or as a thumbnail. Thanks. :) Tag: clear contents of cells that are merged using a macro Tag: 293163
  - 16
    - Trying to install an IME (input method editor) for Chinese I am really frustrated. I have re-installed Office several times (not recently). My daughter attended Indiana University and purchased Office XP and installed it on our home computer. Now I am trying to enable Chinese in Word. Microsoft's insructions tell me to run the Office Tool. Every time I do, it says, "This action is only valid for products that are currently installed." And it had the nerve to tell me this RIGHT AFTER I RAN OFFICE'S DETECT AND REPAIR. I'm so frustrated. Can anyone help? Tag: clear contents of cells that are merged using a macro Tag: 293160
  - 17
    - show non true type fonts -- Y. Tag: clear contents of cells that are merged using a macro Tag: 293157
  - 18
    - How do you display other than True Type fonts? In Office 2007, specifically Publisher, how do you display fonts other than True Type? -- Tag: clear contents of cells that are merged using a macro Tag: 293149
  - 19
    - How to make an envelope font change in Word 2007 for all systems I've got over 500 installation of Office 2007 and I want to change the default font for envelopes. How can I do this? There doesn't appear to be a Group Policy for this. -- Sandy Wood Orange County District Attorney Tag: clear contents of cells that are merged using a macro Tag: 293143
  - 20
    - damaged media My MS Office 2003 CD is cracked. How can I get a replacement copy of the CD media? Tag: clear contents of cells that are merged using a macro Tag: 293140
  - 21
    - Help I deleted my whole workout journal. I thought I was just deleting a entry and now I cant find my journal. Where can I find it? Tag: clear contents of cells that are merged using a macro Tag: 293133
  - 22
    - Office 2007 dictionary incompatible with MSN Apparently, I need just the dictionary from Office 2003 to work with MSN mail. I have Office 2007. How can I download the 2003 dictionary? Or is there another fix? -- Kathleen Tag: clear contents of cells that are merged using a macro Tag: 293124
  - 23
    - MS Office 2007 Vista I have a new Dell computer running Vista. I am having a problem with my MS Office 2007 that was installed in the computer when I bought it. When I open it, everything is H U G E and blurry. I have tried the zoom, with no help. Also, while it is open all other programs become HUGE and blurry. Do you think I might need to change some settings/resolution? Mine is at 1280 by 720 pixels, 32 bit. Hope this makes sense. -- Computer granny in Oregon -- Computer granny in Oregon Tag: clear contents of cells that are merged using a macro Tag: 293123
  - 24
    - Toolbars in Office 2007 Has anyone come up with an add-in that will give us back the ability to create custom "toolbars" (I guess they are called ribbon groups now) without having to learn XML? Point-and-click, drag-and-drop functinality would be nice. I've created Macro's (VBA) in nearly all of the office applications to perform repetitve tasks and assigned them to custom toolbars using buttons with custome images. Loss of this cabability represents a serious loss in productivity. Most of the other "improvements" Microsoft has made to Office are tolerable, but they really missed the mark in not providing this functionality. Tag: clear contents of cells that are merged using a macro Tag: 293116
  - 25
    - i have office vista. i can't drag my mouse on a text to select it have office vista. i can't drag my mouse on a text to select it even thought the drag aption is on. it will only allow me to triple click and select the whole paragraph or ctrl and click and select a whole sentance.HELP! Tag: clear contents of cells that are merged using a macro Tag: 293115

i can only clear contents of a cell if they are not merged ,i would like to
be able to clear if they are merged

Re: clear contents of cells that are merged using a macro by Bob

Bob
Thu May 08 05:53:28 PDT 2008

That's just another reason merged cells should be avoided like the plague.

Anthony wrote:

> i can only clear contents of a cell if they are not merged ,i would like to
> be able to clear if they are merged

Top