Recent content by Draig

Lisa In the Mail Merge Helper, Step 3:Merge, there is an option to "Don't print blank lines when data fields are empty". Try it! Barborne Worcester UK

Or action buttons, accessible from the Slide Show menu. Barborne Worcester UK

Hi To prevent Word from automatically creating styles based on your formatting, invoke Tools, AutoCorrect, AutoFormat As You Type and clear the checkbox 'Define styles based on your formatting'. I find that 'feature' a pain! Barborne Worcester UK

Put 1 in a cell; select it and any number of cells below it; fill in the Edit, Fill, Series command dialogue box. Barborne Worcester UK

Hi DannyDanny As I understand things, you can't straightforwardly print an entire workbook that has sheets with different orientation. The solution I use is to write a VBA macro that prints each sheet one at a time but specifying the orientation for each sheet in the print command. Not a lot...

Hi RookieSQL What you want can be done simply by using a variation on Copy & Paste. This works if your Excel graphs are embedded or are on separate chart sheets. 1. In PowerPoint prepare a new blank slide. 2. Switch to Excel. 3. Select your first chart and copy it to the Clipboard (Edit...

Here's another way. Invoke Tools, Options, Edit and check the Fixed decimal check box. Make sure the spinner box next to it shows 2. Now, whenever you enter a number, a decimal point will be inserted before the last two digits. Barborne Worcester UK

"Deleting" the tables from the Relationships screen does NOT delete the relationships. You should first delete the relationship LINES, then delete the TABLES to permanently remope them. Barborne Worcester UK

This is crude but it does copy the selection to the Clipboard and start Notepad. You can do what you like there, and then return to Excel. Sub CopyToNotePad() Dim RetVal Selection.Copy RetVal = Shell("C:\WINDOWS\NOTEPAD.EXE", 1) MsgBox "Returned to Excel&quot...

Why not use the field code {PAGE} in the document (Insert,Field,Numbering Category,Page)? Barborne Worcester UK

Hi Carol If you record yourself using the Data, Sort command, in its dialogue box you can specify upto 3 columns to sort on. That will give you the basic VBA code you need for what you want to do. Barborne Worcester UK

Alternatively, once you're at the last used cell, use the Offset() method to move down one row: Selection.Offset(1,0).Select Barborne Worcester UK

In each application (Excel, Word, etc.) look at Tools,Options and set the default file location for each. Barborne Worcester UK

Hi Seems to me that in your Excel97 you had a macro (possibly a global one stored in Personnal.xls) that was left behind when you opened the file in 2000 (on another machine?). If this is the case you will have to re-create that macro. Barborne Worcester UK

Hi Here's a possible solution. Assume that you have the month names Jan to Jun in cells B3:G3 and numeric entries in the row below (B4:G4). the following formula will tell you which month heads up the last non-zero entry ...