General

forgot to attach doc sent via email, original's not saved. canit.
On 4/26/2010 6:46 AM, AVS wrote: Someone was meant to send an important document to me via email but they forgot to attach the document, and do not have it saved on their system. Is there anyway for us to retrieve the document with the amendents included? Thanks "Someone" certainly isn't paying attention... 26 Apr 2010 13:48

Excel vba autofilter code
I have some code to filter a result set to a list of unique names - is there something I can add that will also remove 'blank' entries ? Range("AP1:AP" & LastRowNewData).AdvancedFilter _ Action:=xlFilterCopy, _ CopyToRange:=Range("A44"), _ Unique:=True Thanks ... 26 Apr 2010 13:48

Excel VBA AutoFilter code
I am using; Action:=xlFilterCopy, _ CopyToRange:=Range("A44"), _ Unique:=True to copy unique names to a list - is there something I can add to this code to strip out 'blank' entries at the same time ? Thanks ... 26 Apr 2010 12:38

lookup or match?
on tab: Weeks NQCQ I have a table as follows Col A Col B Col C Week CQ Week NQ Week wk2 1Q10 Wk-12 Week 2 wk3 1Q10 Wk-11 Week 3 wk4 1Q10 Wk-10 Week 4 wk5 1Q10 Wk-9 Week 5 wk6 1Q10 Wk-8 Week 6 wk7 1Q10 Wk-7 Week 7 wk8 1Q10 Wk-6 Week 8 wk9 1Q10 Wk-5 Week 9 wk10... 26 Apr 2010 13:48

Fill/Expand Selection adding placeholders to Decimals
Hi, I set up a worksheet for a Lookup Function that contains numbers increasing by 0.1 from 100.0 to 50.0. I used the drag and fill to set up the numbers. I noticed some incorrect entries in the results from the look up and found that on certain numbers it added many decimal spots to the number for example ... 26 Apr 2010 13:48

Missing Excel option
Somehow the "View" option in Excel went missing. Now there's a thin white line where the word use to be. So the it reads: File Edit (white bar) Favorites Tools Help. Does anyone know how to fix this? Thanks. ... 27 Apr 2010 04:20

Viewing Tabs
Is it possible to view the info on 2 Tabs sheets vertically side by side at the same time from the same worksheet. I know how to view 2 worksheets next to each other, but not about tabs on the same worksheet. ... 26 Apr 2010 12:38

Visual Basic Protection and Delete Modules
I have in my visual basic the following code ' Deletes Modules Set vbCom = Application.VBE.ActiveVBProject.VBComponents vbCom.Remove VBComponent:= _ vbCom.Item("Module1") vbCom.Remove VBComponent:= _ vbCom.Item("Module2") vbCom.Remove VBComponent:= _ vbCom.Item("Module3") vb... 27 Apr 2010 09:55

Using Formatted Text with AutoCorrect in Excel
Is there anyway to use formatted text within AutoCorrect in Excel or Powerpoint? I would like to use the AutoCorrect feature to superscript numbers when using Excel and Powerpoint and the AutoCorrect feature does not seem to allow for formatted text. Can anyone help? ... 26 Apr 2010 12:38

Some recalcitrant custom cell styles
Hi, I had a problem with multiple custom cell styles that don't allow me to convert an excel 2007 file to excel 2003. I found a VBA example to delete all those custom cell styles easily: Sub style_remove() On Error Resume Next Dim mpStyle As Style For Each mpStyle In ActiveWorkbook.Styles ... 26 Apr 2010 11:24