XL2000 I have a macro that cuts and past special. is there a code that I can add to this macro that will go to the next line down if the first one is...

Hi I am trying to link a worksheet to a ne work sheet but with rows and columns transposed. Problem is that the worksheet contains cellreferences not data...

I recently received an Excel file that I am unable to open. I get the message: Invalid format. I have version 7.0 of Excel. New I need to upgrade to the...

Hello: One worksheet will contain more than one table holding lookup values (prices, CPU speed, etc.). They will be located one on top of another,...

Hi all, I am hoping someone can help me with the following problem. I have an excel spreadsheet with 5 columns. Column A - Date Column B - Number Column C -...

I am copying data from one sheet, closing it, pasting it to another, then opening a new sheet, copying data, and pasting it again to the other sheet...this...

I have an Excel 2003 spreadsheet that has a form in it that has XML fields in it. I need to launch the spreadsheet from a command line and have it load...

I'm under the impression I can use Outlook Express to view this forum as a newsgroup. I'm not familiar with newsgroups and how to view their content. How do...

HI I've got a column full of filenames (around 100 at the moment), but without the .xls suffix. I want to add a fixed path and the .xls suffix to each. I...

Hi, I hope someone can help with this. This is probably really obvious, but I've got the following code held on Sheet 2 of a 3 sheet document. The cells...

I've created a spreadsheet which is really a design of a electronic relay. When I print the spreadsheet a very short green line is printed on the border of an...

In a spreadsheet I created to diagram the wiring of an electronic relay I've created many text boxes of varying lengths. All use the same font size but there...

Hi all, i have a excel form which i can see all the contents when it's in the normal page break view but when i preview the form, the right part of the...

Hi, I am still unable to open the file from explorer/shortcut after trying these (by the way - thanks) ================================================== Mj...

Hi We have the following code that filters a range in database(no problem) this code is looking at column A which is a week number(11) what we now need to do...

Hi all, I have a cell that contain a drop down list via validation. Is there any way to make input into this cell autocomplete, so I only need to enter a few...

Greetings. Last week I found out how to add lines of code to a module while the program is running, but there is a catch. Every time I do this my variables...

I'm an independent developer and my client maintains financial models in Excel spreadsheets. They currently have 1500+ workbooks, of which 200 are active at...

Hi folks, Justrecently my right mouse button stopped workng as normal - meaning that when you right click a spreadshett row you normally have a number of...

If I have a list in a column, for example: Arthur, Arthur, Arthur, Bert, Bert, Charlie, Charlie, Charlie, Charlie, Derek, Eric, Eric How can I summarise this...