General

Macro to hide rows with zero in specifc column range
Hello I have a workbook with multiple sheets. I would like to put together a macro that will hide the rows in a given range on all sheets. For example, on Sheet 1 the range of cells I need to evaluate for zero are C9:63. If any of the cells in the range are zero, I want to hide the corresponding row. So ... 20 Apr 2010 16:32

making a correction in a row of excel?
please advise ... 20 Apr 2010 16:32

median standard deviation
Hi, Anybody can tell me which function or formula should I use in excel to calculate the median standard deviation? Thanks a lot. Omics ... 20 Apr 2010 19:42

Cell colour in relation to IF results
I want a cell to be coloured red if the result of a simple calculation is negative, and coloured green if the result is positive. Can anyone tell me how to do this? -- Thanks for your help Rob ... 20 Apr 2010 14:30

worksheet change question
As I scroll across a particular spreadsheet, I would like to have the following columns change width, and zoom, as shown in the code below. However, the results are erractic. The zoom only works on the last column, and all the widths are 20. How do I correct this situation so each column behaves as I want? Thank... 20 Apr 2010 14:30

Options saved with the worksheet?
Can we clarify this statement RE 2007, as I am having trouble with the prompt to update links (when opening a file). Have 2007 settings as; no automatic update, ask to update automatic links and have tried various combinations of let the user choose, however, not being prompted. This is an issue as macro link... 20 Apr 2010 13:26

PROTECTING CELLS
I am having trouble protecting some cells. I mark all the required cells to be locked, then apply the Protect to the spreadsheet. Some cells are locked and some are not. What's up? ... 20 Apr 2010 14:30

Excel - Run Macro on Cell Change
I am trying to have 1 of 8 different macro's run depending on the value of a specific cell. If I enter 1 in cell A3, I would like macro1 to run. If I change cell A3 to 2, I would like macro2 to run and so on all the way up to entering 8 and getting macro8 to run. I am unable to find any good examples of how to ... 20 Apr 2010 13:26

Left Function
I am trying to pull certain characters based on a criteria for the third position character. In Column A, I could have a code such as BB11 or a Code such as BMR2. If the third position character is a number then I only want to pull the first 2 digits BB but if the third position character is a letter, then ... 20 Apr 2010 13:26

Excell 2007 will not open XLSX
Has anyone run into this problem( excel will not open XLSX files on double click) the icon has changed into blank page with the excel ion in the middle of the page, i can open the file from excel ie: start/ Open/file path. any ideas? ... 20 Apr 2010 14:30