I have a list of people that is currently linked to a combo box. I was wondering if it were possible to have the combo box range change automatically with new...

In the last few days, none of my comments have appeared on these forums. I have been using the MS Office Communities interface rather than a separate...

I'm new to macros and trying to write one that will move the contents of say 50 sheets all onto the 1st one. I decided to start simple and got as far as the...

When using the PMT function to calculate a loan payment, the result I'm getting is a negative number with more than 2 decimal places. -327.4347167 I am then...

I have the following sample information in one column. I would like to eliminate the three digit number at the beginning (and the space after the number) and I...

Im trying to right a look up which does the following Looks in an array which consists of 3 columns. If it finds two specifed values in the 1st two columns,...

Is there a way to strip the html in an entire column? I do it using regular expressions in access but not sure how to do it here. I guess if I knoew how to...

Is it possible to change positive to negative balances through formatting? I have around 3000 cells that need to be changed to negative from positive.

I know how to change a file location in Excel for the default location on the general tab. My problem is that location no longer exists, so I need to change...

Using Conditional Formatting I was trying to do an end of the month check on a preceding cell date entry to control whether or not the cell after that one...

Hello all, new to this forum, hope someone can help me. Have used query within Excel for a long time to extract data from various SQL databases and tables,...

I have upgraded laptop and Office software but cannot find the add in for Report Manager on this latest version. On 2000 it came on the disc, on 2002 I...

How do I cause a count to increment when the spreadsheet recalculates (F9)? Every time I recalc the count gets reset back to 0. I have tried several of the...

I want to have a way to print the sheet tabs only... If one has a number of sheets .. and each sheet tab a "label".. and you want to print them only or get...

Hi, I want that when i launch my userform the activesheet saved location is shown in a text box (textbox1) How can this be done? cheers steve

Can somebody help me to make a formula for following? X a 45 b 15 c 40 d 35 e 60 f 100 g ...

when rent+late fee = total amount paid so far, I want "paid in full" to equal "yes" This is pretty easy with if functions, but the next day my late fee goes...

Guys Can you tell me if it is possible to filter rows identified by colour plz? If so, how do you do this?? Any help would be most welcome Thanks Dave

Is it possible to disable the Save button automatically on the Excel toolbar only when a particular workbook is opened? I have problems with my forms being...

I want to do some kind of look up of a named range that will be equal to the name of the name the user selects. For example: if somebody chooses red from the...