Hi, I have a list with 3000 addresses, and I'm trying to make envelope labels to mail all of those people. I started by just copying pand pasting all info cell...

I have recently started having problems with Excel, where hitting the tab key moves you to the first cell on the next screen width. For example, hitting the...

I have a spreadsheet with two tabs that I use for work, One tab is inbound quantities and the other tab is the order no of that quantity. What I would like to...

I'm running on windows xp prof 2002, need to open a damaged excel file with excel 2002 (size of file:680kb). I was going through the procedure of deleting all...

This is what I am using now. but it will only use is on worksheet(2). i have tried () ( ) but nothing seems to work. I would like to set the margins in all...

Actually, I have truly MERGED cells that contain LINKS to other workbooks. The merged cells were created exactly as you described and the data within them...

I have an Excel file that is doing something odd. First of all, Excel 97 SP2. Now when I open this file it has tons of formulas and it can both auto-update or...

hi i want to select a few sheets and move it before a sheet name total. i have to program as : Sheets(Array("Q1 2005", "Q2 2005", "Q3...

There are times when PASTE SPECIAL opens up a window to allow pasting of values/formulae/format/etc. At times, going to the same EDIT/PASTE SPECIAL menu,...

I got this message while trying to create a huge workbook. Basically I had an array of 33,000 rows and 60 columns. 50 of the columns were calculationg all...

Is there any way to print - front to back - 2 seperate worksheets?

Hi I am using Excel 97 & have set certain cells font as white, so they are hidden from printing. However when I select a large range of data, I cannot see the...

Why does the following block of code work when using a macro button on a custom toolbar but not work when using a control button on a worksheet??? I get a...

Excel 2002 - when I opened two different XLS files, two full copies of Excel would open and I could "resize" both so half fit on top of screen and the other on...

Object doesn't support this property or method: 'xlhhctrl_1.HHClick this error message comes up when trying to access How formulas calculate in the...

When I open a spreadsheet (saved on an earlier version of Excel) in Excel 2003, the "cell wrapped" cells lose most of the ending information, as if there were...

Is it possible to create an Excel file which will automatically fill cells with results from other cells of another excel file. Is it possible to automate...

Hi all, I need to concatenate a word and a number cell. eg, Concatenate("Limit = $",A1) where A1 = $100,000. It shows up like this: "Limit = $100000". However...

In the Microsoft newsgroups, the subject of postings and replies are displayed. But, when I click on the item to read the message, nothing happens. Do I have...

I tried to open an excel file, then a message popped up and said A Fatal Exception OE has occurred at 017F:BFF744FE. I reboot the computer several times. Now...