While changing from xlBar into xlStackedBar the chart changes very strange. If I change back all is OK again. Task Start Finish Task...

I have a two page spreadsheet, how do I delete the second page?

Is there any way to draw on top of embedded objects in Excel 2007?

I rarely use count in my pivot tables, is there a setting I can change in excel so that when I select my values, which is usually 5 or more, I have to reset...

Hi, i need a macro to display a message, first time i open workbook in new month. If today is 01.11.2009, and i open my workbook, then, the macro to display...

I want to have a macro that's goes to a specific part of the spreadsheet - for example BB1. But I want BB1 to be in the left corner of the window. If I just...

when downloading data from websites using select all, copy, paste into Excel, I receive symbols and characters some of which can be cut and pasted away....

I am trying to move multiple rows of data to columns. For example, I have multiples rows of different data for employee A and want one row for employee A...

I have the following error, when I am requesting help Cannot open file mk@MSITStore Can anyone please tell me what to do?? -- Tanya

I am using the following statements Sheets("WAN").select If (Range("K2:K974").Find(What:="RTR23so-5/0/3", LookAt:=xlWhole).Select) = True...

I have a field called "Case#" used to capture a number that represents a support case number. Simple enough. I would like to have this field hyperlinked to...

Help!! I made changes to an Excel file, and saved. I meant to save as a new file, so i could keep old file. Is there any way to retrieve the original...

When i downloaded the detailed suppliers invoices from my accounting software, the layout is: Supplier name in column B (only shown once on top of all the...

Hello again, i have found a bright macro so quick to handle and i like it to perform basically with one last finishing criteria. In myWorkbook, every sheets...

Hi, i need a macro to delete all sheets except 4 or 5 sheets. Can this be done? Thanks!

I have data in the following columns: a b c d e f trans date name unit start ...

I have to "duplicate" a section of my spreadsheet to another section. I want to data to appear in the destination cell(s) only if the source cells actually...

I need to average ranges of cells in a column, only if they greater than a certain value. For instance, in the following column, I need to average only the...

Office 2003 Excel. I've hidden certain rows from an excel sheet, but when I print, the printout has large gaps where the hidden rows should be! I have tried...

I have created a drop down menu & would like to total the responses by fruit. For example, i have the drop down options being: apple orange banana peach I...