General

how to make whole work sheet in to upper case
hi i could not convert upper case words or sentence to lower case or visa versa like.. if "how to make whole work sheet in to upper case" this to be made to upper case.. how could this be done.. plz help Regards Mahesh ... 5 Jul 2008 10:28

Unable to undo paste in Excel
I am using Excel 2003 professional and am unable to undo a paste when I have multiple worksheets selected. Does anyone know of a fix or work around for this? ... 3 Jul 2008 09:25

Sheet name list
The following macro (list links of worksheets of workbook) was posted by Mike H. It does not work if the sheet name contains a space. Is there any way I can change the macro to make it work. Thanks. Sub sonic() Sheets("Sheet1").Select For x = 1 To Worksheets.Count Cells(x, 1).Hyperlinks.Add Anchor:=Cells... 3 Jul 2008 08:23

Print many worksheets
Hi, I want to add a button that prints many, but not all, worksheets. How do I go about this? Thanks, Graeme ... 7 Jul 2008 04:18

VBA codes
I have created an excel file in excel 2007. It contains some VBA codes. I worked fine first time I have created. I saved it as macro-enabled excel file. Set the sceurity levels to the lowest level. But after I open the excel file the codes are not running. Also, they can't be run from Visual basic Editor immedi... 3 Jul 2008 10:27

Repeat header on each row until data change
I have a report that has a group header (Fund Name) beginning at C12. Transactions commence at row 14 starting in Col B. This repeats for each date (my example data ceases at B26). There is a gap of 4 blank rows before the next group header in C31. The transaction data commences again from B33. This repeat... 3 Jul 2008 06:21

Dependant lists using Combo Boxes
I want to create dependant dropdown lists using combo boxes from the Forms toolbar. I have created an exit survey form using check boxes and combo boxes from the Forms toolbar. Now my boss wants me to add an occupation category where the occupation is e.g. Information Technology, then within that occupation th... 5 Jul 2008 11:30

How can I replace text with a specific number?
Hi, I have two Excel spreadsheets and need to merge them together. One is a list of company assets and the email address of the user the asset is assigned to. The second is a list of email addresses and the personnel numbers that match them. The information I actually need is the company asset linked to... 3 Jul 2008 07:22

Pivot Refresh
I'm trying to write a macro to remove all of the fields that are in the layout area of my pivot table. I found a macro online that did something similar and I adapted it to look like this: Sub PivotRefresh() Dim pt As PivotTable Dim pf As PivotField Set pt = ActiveSheet.PivotTables(1) For Each pf In pt.Piv... 3 Jul 2008 11:28

Open CSV file auto delimites using space not comma
Hi, I have a standard CSV file which when opened Excel (2003 SP3) automatically uses the spaces as a delimiter rather then the commas. How do I ensure Excel automatically opens CSV files and used commas as a default rather then spaces as a delimiter. I have Excel 2007 which reads the file correctly. Cheers ... 11 Jul 2008 17:10