Programming

Excel not opening properly when exported from Sharepoint
Hi, From the sharepoint site, i will have data. When i do actions-export to spreadsheet after all clicks i dont save but open the file It does export by some of the columns dont appear at all. y is this so i am using excel 2003. please advise max ... 4 Mar 2010 02:21

Worksheet_Calculate
I need to use comboboxes to update several pivot tables. What event should i use to loop thru the changes to the comboboex and update the respective fields of the different pivot tables? I'm trying Worksheet calculate but it will keep going even though if i turn the diableevents to false Thanks in advance ... 5 Mar 2010 07:14

conditional formatting
I want to establish conditional formatting of cells in one column based on content in a neighboring cell. The formatting options are going have about six options which mean I need to use VBA instead of the conditional formatting function directly in the worksheet. My question is once I establish the syntax to d... 3 Mar 2010 18:41

Copy Data From Varying Lines to One Sheet
I have a small compilation of data in cells A10:I24, same set up, but different data on 6 sheets. In A10:A24 on each sheet are vendor names. I have a 7th sheet that is a "summary" of the data associated with each row by vendor. On each sheet these vendors are in a different order (On a different line) and m... 3 Mar 2010 18:41

Stop macro
Excel 2007- I can't stop a macro from running. I have pressed Shift when opening, changed Macro Security to disable all macros and Unchecked Trust access to VBA but it still executes the Auto_open macro. ... 3 Mar 2010 18:41

IIF statement to hide a graphic
How can I use IIF statement to display or hide a graphic? ... 3 Mar 2010 20:55

VB Excel Macro
I have a VB Macro in an Excel spreadsheet that I want to use in other spreadsheets. What is the most efficient way to do this without copying the macro code from sheet to sheet. ... 4 Mar 2010 13:32

view list of named ranges
How can I view a list of all the named ranges in a workbook ? ... 3 Mar 2010 16:26

Input box to update combo box
Does this solution add the new text to the drop down menu? so that next time you use the combobox that value will be present? "HFB" wrote: BEAUTIFUL! Thanks heaps Tom :) "Tom Ogilvy" wrote: Private Sub Combobox1_Click() if Combobox1.Value = "Other" then res = Inputbox("enter s... 3 Mar 2010 16:26

add years to a cell
Hi, I have a formula to which I need to add 5, 10, 15, and 20 years to cell H5. Hope someone can help me our as I can't figure it out. Thanks much! =ROUND(IF(AND(EmployeeData!$H5<G$4,EmployeeData!$H5>=F$4),IF(YEAR(G$4)-YEAR(EmployeeData!$F5)=5,EmployeeData!$O5*EmployeeData!AM5*ProgramOverview!$AR5,IF(YEAR(G$4)... 3 Mar 2010 14:10