I tried opening different workbooks on my PC and the alignment all seemed to 'overflow' from the A4 size setting. I had opened the same workbooks on a few...

I'm just learning my way around Excel. I'd like to see how to program a Turing Machine in Excel. I Googled: microsoft excel "turing machine" and got over 700...

I can't figure out how to format numbers so that when you type 3220 it will look like 32.20 kinda like how you can enter numbers on an adding machine. I would...

Hi, I need a formula to return in cell A2 cell A1 if cell A1 has more than just one letter: "Bob" for example but if cell A1 only has letter "B" or is blank, I...

-- After searching Google.groups.com and finding no answer, Bob Vance asked: Can "CopyFormat" be added to this code Sub MonthPlus() With...

Is it possible to use a macro to format Excel? I have a number of sets of data under headings e.g. Heading1 Data 1 Data 2 Data 3 Data 1 Data 2 Data...

I am trying to do a correlation analysis but I have missing data, how can I deal with this, is there a way of coding missing data like a . in SAS?

I've set up a bi-weekly timesheet in XL2K for a two-week pay period. D4:D17 contains the calculated time worked each day Overtime is paid for hours worked...

I have worked with 2 to 3 Excel files that have the designation of "" in them. Does anybody know what the relevance of this and if it is known to cause...

When I copy data where the column width and the row heights have been changed why doesn't it keep the column width and row heights?

I have seven sheets same setup for all seven sheets. It is a bank register, each sheet is for a diffrent bank. I would like to get info filtered from all...

I currently have a lookup field in my spreadsheet that looks up the price of a product by product number. Although the lookup usually works there are...

I recently got this code from Bob and just today tested the check boxes. Problem is when I try to check any box beyond the first column, it will automatically...

I have a workbook with 21 worksheet. How can I have the same margin setting for all the worksheets? Thanks in advance.

I'm working in Excel 2003, and have run into an issue I'm not sure there is a solution. If there is I don't know. I have a several responces for 15k+...

Hi How can I covert dates to days of week eg 30/07/04 = Fri without converting blank cells at the end of the column. Obviously, I can specify the column...

I have created a very simple schedule for my employee's with the projects listed to the left in one column, each column to the right has employee's listed...

I have created a Pivot table with the following fields: Customer; Product; Actual; Budget; Variance where 'Variance' is a calculated Item within field name...

Hi, As mentioned in the subject please note this is a repost. I tried the solution given by Bob P but couldnt get it to work.( I might have misinterpreted...

how can i unhide rows and columns. this doenst work: Rows("1:2000").EntireRow.AutoFit Columns("F:H").EntireColumn.AutoFit thanks in advance