Programming

loop VBA request
I post below earlier on but I couldnt see the thread, if duplicated please exscute me. I have 3 columns contain names(unknown, may duplicated and dynamic row), date and amount; I am looking a way to get a sum and count on data that: 1) date is equal to or greater than today, then 2) loop thru name and subtotal... 25 Apr 2010 14:25

loop VBA request
I have 3 columns contain names(unknown, may duplicated and dynamic row), date and amount; I am looking a way to get a sum and count on data that: 1) date is equal to or greater than today, then 2) loop thru name and subtotal on each customer 3) sum subtotal if value is equal or above 10k 3) count 2) with same nam... 25 Apr 2010 03:19

calculate number of days formula
hi, Can someone please help me with a formula to calculate number of days, excluding weekend days? A1 B1 C1 Start date End date Total days (excluding weekend) ... 26 Apr 2010 02:37

slection change to make the selection go down 1 cell
i need a macro that will move the selection down 1 row if certain cells are selected. the cells are e13, e15, e17, e19, etc. If e13 is selected, i want the selection to go down 1 row, so that if e13 is selected, the selection changes to e14, and if e15 is slected, it changes to e16, etc. thanks! Tonso ... 24 Apr 2010 15:02

Graphing a bounded region with a twist?
HI, Can someone give me an idea of how to plot a bounded region of data? I have series plotted. Two of the series are basically 1/x plots (google 'plot 1/x') which are offset along the x-axis. The other two series are a fixed y-value along the entire x-axis, again offset. What is created is a region bound by t... 25 Apr 2010 16:44

protect macro from a different users access
I am working on a excel vba program where I'm utilizing a Userform with command, combo-list... buttons. The program basically asks for a patient's information (gender, height, weight..). Upon the 'run' command, all the data is calculated for respiratory-type research on the patient data. The results are a grap... 24 Apr 2010 22:44

Code in a macro to branch to another macro?
I wonder if someone can help me with a little code for inclusion in a macro? It needs to do the following: “If cell in column D on this row = "Sunday", perform Macro “Sunday”, otherwise execute macro “Weekday”” Background info: I run an accounting system on a series of worksheets. The Cash Journal dynami... 24 Apr 2010 11:40

Unexpected internal error or not enough memory
Hello Öregjani I am just learning the Solver business. Past exchange on the subject says that your statement should be: Application.Run "solver.xla!solverok", "B10",3,0,"B11" meaning: set cell:B10 MaxMinVal=3 valueOf=0 byChange:B11 the next two statements: Result=Application.Run("solver.xla!solversolve",... 24 Apr 2010 09:26

how to brake a excel sheet passward
I have a parsonal data in excel sheet, but now i forget the passward. So plz help me to solve this problem. If any one can help me, plz inform me how it is possible, its very urgent to me. Plz mail me tusshar14312(a)gmail.com, tusshar14312(a)rediffmail.com, tusshar14312(a)yahoo.com. Plz help me................. ... 24 Apr 2010 06:07

Floating Text Box in Excel 2K3/2K7
I am wanting to create a floating text box in Excel 2003/2007 but am currently stuck. The idea is that I will be able lock a text box with a few bullet points in the top right of the screen and that it will remain visible in that position regardless of where I scroll in the worksheet. Locking cells instead, or ... 24 Apr 2010 00:28