Browse by Tags
Microsoft Office 2003
Microsoft Office 2007
Removing VBA Modules in Excel doesn't succeed.
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.
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...
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"...
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...
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...
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...
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...
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...
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....
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...
Page 1 of 64 (631 items) 1