in
All Tags » VBA » excel (RSS)

Browse by Tags

  • Find Maximum

    1: MValue = Large((Abs(rValue), Abs(lValue), Abs(dValue), Abs(uValue)),1) Hope you get the idea. I want to find the maximum of four (abs)values (r,l,d,u Value) and have that equal MValue. They are all integers.
    Posted to Visual Interdev (Forum) by microsoft on 06-05-2010

  • runtime error 1004 in excel vba

    Would anyone have even the slightest idea what might be going wrong with the following code? Sometimes it works fine, but most of the time I get a 'runtime 1004: application-defined or object-defined error' NOTES: -When stepping through application, runtime 1004 error is raised on the 'End...
    Posted to Miscellaneous (Forum) by microsoft on 05-28-2010

  • Excel VBA to Evaluate and Protect Sheets

    I have a workbook that will always have 2 worksheets. One called "New" and one called "variables". The workbook may contain 1 or more other worksheets and if it does I want to use an on open event to protect any sheet(s) that is not "New" and is not the "variables"...
    Posted to Visual Interdev (Forum) by microsoft on 05-27-2010

  • VBA constants generating compile error in Windows 7

    Experts: I have programmed an Excel 2007 Add-in using VBA. It uses automation to control PowerPoint. I wrote it on a Windows XP machine. Yesterday I tested it on a Windows 7 machine which also has Office 2007 installed. Most of my macros work, but I'm getting a bunch of "Compile Error. Cannot...
    Posted to Automation (Forum) by microsoft on 05-24-2010

  • VBA lookup function to return multiple values

    There was a post with a solution at the following link http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_24237627.html?sfQueryTermInfo=1+from+lookup+multipl+return+valu+vba but I cannot get that to work. Can someone else verify that this code works? I always...
    Posted to Excel (Forum) by microsoft on 05-24-2010

  • Disable CheckBox on UserForm in Excel depending on selections

    Hi Experts! I have a Userform in Excel (2007) with several check-boxes on it. For example, there are 2 categories, each with 5 check-boxes under it. The user needs to check one from checkbox 1-5 (category 1) and one from checkbox 6-10. Upon selection from any of the checkboxes 1-5, say number 2, then...
    Posted to Excel (Forum) by microsoft on 05-23-2010

  • bugs within subs

    Can anyone help me to fix the bugs through these subs? The sub CountSales asks the user for a state and a sales rep, and then count the number of sales by this sales rep in this state. The TotalSales1 sub asks the user for a date. Then the total of all sales in all states up to(and including) this date...
    Posted to Excel (Forum) by microsoft on 05-23-2010

  • Redim array

    Hi I hope you can help. I'm also hoping that this will be quite simple....:-) I have a macro which stores data into an array. The array is (?,8). For various reasons, I don't want to count the potential number of entries before dimensioning the array, so I need to store the data into it and then...
    Posted to Excel (Forum) by microsoft on 05-23-2010

  • Replace special characters in VBA

    Hi, I'm writing a bit of code in VBA to convert a table into excel into an HTML formatted table. It's working fine except I need it to pick up certain special characters and replace them with their equivalent HTML notation. The one I'm having trouble with at the moment is the Omega sign....
    Posted to Excel (Forum) by microsoft on 05-23-2010

  • Highlight cells in Range without Conditional Formatting in VBA

    The macro below adds Conditonal Formatting (two conditions) to a range, but I want to just set the colors permanently rather than using the CF. The CF formulas (bottom half of macro) work fine, but I don't know how to convert that into something like: For Each cell In Selection If AA2 <> E2...
    Posted to Excel (Forum) by microsoft on 05-22-2010
Page 1 of 64 (631 items) 1 2 3 4 5 Next > ... Last ยป