General

Naming Ranges
I received an error while importing to Outlook. It said that my spreadsheet has no name ranges and to use Excel to name the range of data. I tried using help and am now thouroughly confused. Do I have to name each column? I tried and it did not work. I tried creating a name with the name box at nuxt the t... 8 Jul 2008 15:10

Move selected Text/Numbers from Col D to Col A/B
newbee to vbscript could pls explain me how to use the same in my workbook. Thanks Rupesh "Ron Rosenfeld" wrote: On Sun, 18 May 2008 16:02:10 -0700, Gord Dibben <gorddibbATshawDOTca> wrote: Copy/paste these two functions to a general module in your workbook. Function RemAlphas(ByVal sStr... 8 Jul 2008 15:10

Excel 2007 Autorecover
I am currently running MS Excel 2007 and have run into an issue. Excel crashed on me and when I reopened it, the autorecover feature prompted me to save the files that were open at the time of the crash. I have since saved them and then deleted them after they weren't needed anymore. However, everytime that Exc... 8 Jul 2008 18:15

How do I enter a "Tick" symbol in Word or Excel?
Although there are masses of Symbols in all of Microsoft Office 2007 I haven't found one which can be used as a "Tick" meaning "that is correct". Any ideas out there? ... 9 Jul 2008 17:50

Page numbers across multiple tabs - one sequence
Hello, MS Excel 2003 on XP PRo. I have an excel document that has several tabs. Printing all (or a subset) of those tabs forms a single handout. I would like to rig it so that they are all page numbered, but with the same order. Tab A has 3 pages, B has 5 and C has 6 Instead of numbering them A-1, A-2,... 8 Jul 2008 15:10

Conditional Format
I would appreciate help with the following. I need to enter a conditional format in Cell H8: The amount in cell H8 needs to be the sum of the amounts in Column F IF what is in Column B is the letter D. (Another formula is needed for Cell H9 which would be the same except for what is in Column B is the letter ... 8 Jul 2008 13:06

Excel 2003 Control Toolbox
I get an error message that states "Microsoft Map no longer supported in Microsoft Excel" when I try to drag a control to a spreadsheet. Any thoughts? ... 8 Jul 2008 14:08

Selecting a cell for fill-in by previous cells
I have values entered into a column. In the next columns over I'd like to be able to simply enter X or another marking value so that the numbers from that row carry over without me having to enter in the number every time I want to use it. Example: A B C D 1 X ... 8 Jul 2008 12:04

Assign a macro so I can just single click it to run it
... 8 Jul 2008 14:08

Opening file in Excel
When I open a file from outside of Excel (Excel is not yet running), the file doesn't open unless I do something else, like click on the colorful Office button at upper left. Anyone know anything about this unrequested feature? If Excel is running, opening a file from the desktop or other folder works fine. ... 8 Jul 2008 12:04