Programming
in [Excel]
|
I need to use the last row of data in a formula I'm writing a macro to calculate the coefficient and intercept of a log curve the following is what the equation should look like in the cell: =INDEX(LINEST('Expect Database Search'!$Q$3:$Q$90,LN('Expect Database Search'!$G$3:$G$90)),1,1) however in VB I have to write it in this format: Range("B2").Formula = ... 3 Jun 2010 13:26
Copy and paste to other worksheets I have 4 worksheets within 1 workbook that I track issues by area. Currently I fill out a main worksheet first and then copy and paste the specific range to another worksheet based on that area. Does anyone know of a code that I could use to copy a range and paste it to the designated worksheet based on specifi... 3 Jun 2010 12:18
nXn matrix creation Hi All, I have a need to create a matrix based on some user choices. The requirement is described below: User Inputs 5 options Opt1, Opt2, Opt3, Opt4, Opt5. Then runs the macro to generate the matrix. The matrix should look like below Opt1 Opt2 Opt3 Opt4 Opt5 ... 5 Jun 2010 00:39
How to deliver an Excel tool training Hi, sorry if this is not the right place to post this question... I have a tool in Excel that will be used by 1.000 people. I need to deliver some self-training for all this users, like a demo. Ideally, I would like to show how to use the tool (data entry, functions, user forms usage, etc) and talk on the back expl... 3 Jun 2010 23:26
Run-time error 1004 I am using the following to retreive the name of a file that i wish to open. If i select 'Cancel' rather than a file name and 'Open', i would receive a Run-time error 1004. I am handling this potential error using the ErrorClose routine to allow me to 'Retry'. If i select the option to retry and then elect not ... 4 Jun 2010 03:47
What equation that i need to use to group in vba Hi, I need to put group no in column 2 (each group contain 6 no), how to do in vba? Ex. Col A Column B 1 1 2 1 3 1 4 1 5 1 6 1 7 2 8 ... 3 Jun 2010 08:57
A Sub in another Sub... Hi, I have a rather basic question: I have made two macros in vb that works out just fine one by one. Now I need to include one macro into another. I need the macro called Sub EnterMonthYear to be included at the very end of the Sub Table I'm sure there's a simple code to trigger the Sub EnterMonthYear, bu... 3 Jun 2010 08:57
How to assign unit for TimeValue? I would like to input the number of minutes in cell A1 to set the Time Value, as shown below there is 30 in cell A1 (Unit - minute). Does anyone have any suggestions on how to the value retrieve from cell A1 is under minute unit? Thanks in advance for any suggestions Eric Sheets("Date").Range(A1).Value, Ti... 3 Jun 2010 12:18
select and paste data based on creteria on previous cells I have a worksheet running to 700 pages. At various cells, description "cable No" is written. in the next cell the cable number is found and on the cell below the type of cable is found. i have to copy and paste all the cable numbers and corresponding cable types in the next worksheet one below the other.... 3 Jun 2010 02:25
Find Min and Max in variable length arrays I have a spreadsheet of 1,247,000 rows displaying prices (Date, Time,Open,High,Low,Close). I would like to find the lowest Low and the highest High in various daily time slots (like 937am thru 1017am) to then test against buying above the highest High and selling below the lowest Low in the time range selected... 3 Jun 2010 02:25 |