Hi All, Your assistance is required. How would I progmatically save an excel file to a folder that doesn't yet exist. I'm writing an attachment to a code...

OK Folks, Monday morning and my brain is not functioning properly so I am turning to you guys for help. I have a table of exchange rates that looks something...

Hi all, I have gone through all the previous posts and tried several different variations but still can`t get it. Can anyone help? I have 2 columns, one has...

I want to add text to certain rows of my worksheet which are visible only at Print Preview/Print modes only. I want these details to hide or preferablly to...

Not familiar with SUMIFS in 2007. Are SUMIFS and SUMPRODUCT the same? If not what is the difference? Thanks

I am unable to enter an array formula into Excel using Ctrl+Shift+Enter. I have ensured that it is in edit mode. Nothing happens when I try to enter it. Is...

At a point in the way we work we copy the whole worksheet and start using this one to preserve the information we were at. When copying we get the...

On page 1 of a workbook in cell A1 I have the formula =A723. The dollar amount that appears in A723 is displayed. On page 2 of the same workbook in cell A1 I...

How can I replace the 7th item in each cell of the examples below to say 5? 30-02220.900.LAU should be changed to say 30-02250.900.LAU 40-02430.000.FIN should...

Formula in cell J10- =IF(G10=0,"There are no more copies, please ask students to return their books or buy more stock","") I have entered this to J10...

Im trying to filter a data set on 3 criteria project name, start date, end date the project name part is fine the problem im having is that im getting dates...

I've been having this annoying problem with color pallettes where one file will inherit the color palette scheme if I open any other file after it. That is,...

Can any one tell me what each of these mean Locking & unlocking Protecting & unprotecting Hide & unhide (I know what it is, but just checking to make...

I wanted to create a form using Excel. The form example that I have seen shows the Excel Spreadsheet in the background. Is it possible to create a form that...

Hi, Can anybody recommend a tool which monitors links in Excel? I'm want to know which files are links to a certain file. Sort of trace dependants but then...

Hello Below is the code for a command button I Have. I have sevaral of these command buttons in the file. Private Sub CommandButton1_Click() Dim myRng...

I need the correct formula for the following propblem... If(c21=dog then f21+g21) or if (c21=cat then 0,0)

When I press "Ctrl + C" the delete menu pops up, instead of copying the contens of the cell. Why??? In fact "Ctrl + any letter key" does this. How do I turn...

Hallo! I have two workbooks: Source and Destination. When I select and copy a cell range in Source, activate Destination and paste the range - everything...

Hello I would like to have a code that transforms 2 or more columns in rows. The special thing here is that if I change the values in the same columns and run...