## Font colours disappear when pasting to Powerpoint as Metafile/Enhanced metafile

MS EXCEL

### Next

• 1. Run-time error '6' Overflow
The following code is giving me the Run-time error '6' Overflow, and specifically at the code "ans = var1 * var2". And I don't understand why, when stepping through this code, it keeps jumping in and out of the procedure. I obviously don't know what I'm doing. FYI, cells D3 and F3 have the following code in them: =RANDBETWEEN (1,9) I hope someone can explain... Private Sub Worksheet_Change(ByVal Target As Range) Dim var1, var2, ans, tgt If Target.Column = 8 Then tgt = Target.Value var1 = Range("D3").Value var2 = Range("F3").Value ans = var1 * var2 Range("D4").Value = var1 Range("F4").Value = var2 Range("H4").Value = tgt If tgt = var1 * var2 Then Range("I4").Value = "Correct" Else Range("I4").Value = "Wrong" End If End If Calculate End Sub
• 2. Incorrect formula
Would appreciate help with my formula. I only want the 1 to be added to L28 and L29 if they have a value greater than 0. this formula produces 2 even if all the cells have nothing in them, but I need there to be nothing in the cell if no values are in any cells. If the value of every cell in the formula was 1 then my answer should be 14 but if cell L28 is 0 then the answer should be 12, and if neither L28 or L29 has a value then the answer should be 10, but because of the =1 in my formula I get an answer that is 12.(or 2 greater than I want if values are in other cells) Help appreciated. =((L24+L25)*3)+(L26+L27)+(L36*2)+(L28+1)+(L29+1)
• 3. Using Subtotals
I have a spreadsheet (table) that I plan to use sub-totals. Is it possible to have a calculated column to the right of the table on each subtotal row (e.g. Column B:99 / Column A:99)? What if a data refresh adds a new grouping?
• 4. Building a summary page
Example: Vendor Sales Cost Sheet1: Walk-in sales abc 1.00 .50 def 1.00 .50 ghi 1.00 .50 Sheet2: Drive-thru sales abc 1.00 .50 ggg 1.00 .75 ghi 1.00 .50 Sheet3: Mailorder sales ggg 1.00 .45 klm 2.00 .80 frt 1.00 .90 How can I build a summary page as follows: Total Sales: abc 2.00 1.00 def 1.00 .50 ghi 2.00 1.00 ggg 2.00 1.20 klm 2.00 .80 frt 1.00 .90
• 5. Excel 2007, unknown name appears on Move or Copy...
I have always used Excel 97 to track and record my investments. Recently I started using Excel 2007 with my old Excel worksheets. What I do is use Move or Copy... to copy the previous day's worksheet for the current day, so I can update my positions and prices. Now when I do this with Excel 2007, I always get this message: "A formula or sheet you want to move or copy contains the name 'Print_Area_MI', which already exists on the destination worksheet. Do you want to use this version of the name?" I have no idea what that's about since I have never used any such name on anything. I just click Yes and that takes care of it, but is there some way I can stop this pesky message from reappearing every time I do this?

### Font colours disappear when pasting to Powerpoint as Metafile/Enhanced metafile

```When using copy/paste special to take a range from Excel 2002 to Powerpoint
2002 all is fine on my PCs - i.e. all formats are kept as expected.

However, my client has 2 of his own machines and 2 of his clients that lose
the font colour only - all text is black (background colours etc are fine).
Colour is retained in HTML and Bitmap formats but not Metafile or Enahnced
Metafile.

```

```When using copy/paste special to take a range from Excel 2002 to Powerpoint
2002 all is fine on my PCs - i.e. all formats are kept as expected.

However, my client has 2 of his own machines and 2 of his clients that lose
the font colour only - all text is black (background colours etc are fine).
Colour is retained in HTML and Bitmap formats but not Metafile or Enahnced
Metafile.

```

```I have tried and failed to record a macro that performs the function of
Edit/Paste Special/Enhanced Metafile picture.  My recorded macros come up as
empty 'subs'. Can I get around this limitation with VBA code? I can't seem
to...help. Thanks. Same question as another guy, but I do have 2003

```

```Since upgrading to Office 2003, I am unable to
successfully paste Graphs made in Excel as enhanced
metafiles into my office's Microsoft Word report template.

When I paste special, as an enhanced metafile, I am only
able to see the very bottom piece of the graph.  I can
move the graph around and resize it, but it will not show
up on screen.  Nor does it show up in print preview.  BUT
it comes out just fine when I print a hard copy.

This issue is unique to our report template, as I can
paste Excel graphs into a blank Word document with no
trouble.

But it is also unique to Excel, as I can successfully
paste graphs made in Power Point into our report template.

I've tried re-creating the template in 2003 but that did
not help.  I've also tried every combination of Office
2000 and 2003 pastes (i.e. graphs made in Excel 2003 into
the 2000 template, graphs made in Excel 2000 into the 2003
template, etc).  Nothing seems to work.

Has anyone seen this problem before?  Any suggestions on
how to get aorund it?

```

```To tailor all our charts we past/special/metafile line charts into
Powerpoint, then ungroup twice to be able to move/chop/change elements of the
chart. When I ungroup the second time the line (representing data) actually
breaks into a huge number of invidual lines (according to the underlying
source data), as opposed to one single line. As a result, things are much
more tedious/complicated. Any way to ungroup a chart in Powerpoint and have
the line stay as a line, and not a ton of individual lines?
--
Ben
```