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'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...

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 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...

when i send an excel spreadsheet to myself i can open it but if i send it to someone else by email when they go to open it says more than 64 unable to open. i...

I find the single worst thing about the VBA editor in Excel (I use Excel 2000) is that my mouse scroll wheel doesn't work on the source window. Is this normal...

Good day; I am creating a template that requests the user to assign a text value (L,M,H). I need to convert this text value in multiple cells to a numeric...

I have a single column of values, invoice numbers. I would like to sort the column by the last digit of the invoice number. Is this possible, and if so,...

Hi! I have been given a database of names, addresses and website addresses in an Excel spreadsheet. The website addresses do not appear as a hyperlink. Is...

Hello -- A workbook I was given shows 2 worksheet tabs. Cells in each of these worksheets reference 2 other worksheets, as in (H33) ='cannot see...

I have an application that requores that I use COUNTA over a column range that varies from spreadsheet to spreadsheet. Is there any way that I can incorporate...

Hi All, I have a pivot table which has a "Sum of Amount Authorised" in the data area which is formatted as a number with 2 decimal places. When I double...

Two questions, 1st: Is there a way to auto refresh a pivot table other than "on open" when opening the worksheet? 2nd: Is there a way to change the layout such...

I am working on huge spreadsheet. From time to time when I open the file it tries to recalculate. This file takes about 2 hours to recalc. I know I have...

Dear readers out there, A colleage of me made some excel sheets. They are very slow with scrolling. Even when i clear all the info and tekst in the sheet; so...

Dropping the security level on my workbook will do this right? excel says it's not reccomended because of viruses, is there another way? I have macros in my...

I would like to: test the code or button that I inserted with code on spreadsheet. allow the user to launch the spreadsheet in run mode. (newbie) how to do?

I have set up a spreadsheet in Excel on my desktop to be able to enter in lab data and it works great. I have recently purchased a Compaq I Piq h3650 with...

Hi I have an excel sheet with dialog box having default values.I want particular records from the sheet when I click any value in the dialob box.Like when I...

I have a password secured Access 97/2000 database that I'm trying to attach to via Excel 97/2000 to make pivot tables, but I can't use any of the database's...