Programming
in [Excel]
|
Error of "application-defined or object-defined error" in Goal Yes, that is correct! "aflatoon" wrote: Your code is unclear to me, but I think you mean: Code: -------------------- Sub GoalSeekTry() Set Source = Cells(8, 7) Source.GoalSeek Goal:=-800, ChangingCell:=ActiveSheet.Cells(7, 7) End Sub ---------------... 13 May 2010 13:50
help with a sub Hi, can anybody tell me why the following code fails at FormatConditions.Add Private Sub CommandButton1_Click() Dim Sh As Worksheet Dim lngLastRow As Long Set Sh = ActiveWorkbook.ActiveSheet lngLastRow = Sh.Cells(Cells.Rows.Count, "A").End(xlUp).Row Range("A4:E" & lngLastRow).Activate Selec... 14 May 2010 06:16
Combine 2 spreadsheets by parsing from one to the other I have one spreadsheet -a as follows: one column... A B C D I have another spreadsheet as follows: one column... 1 2 3 4 I want TO CREATE FROM THEM INTO ONE SPREADSHEET: A 1 A 2 A 3 A 4 B 1 B 2 B 3 B 4 C 1 C 2 C 3 C 4 D 1 D 2 D 3 D 4 Thanks for any directions. ... 13 May 2010 12:43
LOOKUP function help Hi everyone! I've been tackling excel for the past 2 days at work trying to format a spreadsheet I made that lists accounts associated with different people. I am trying to write up a lookup function that can look up a certain account code from a list of account codes and would ultimately return the people ... 13 May 2010 12:43
Before Cell Exit Thanks for taking the time to read my question. I want to write a function that is executed before the user exits a specific cell. The purpose is to check the format of the date that has been entered, and make the user correct it if it's wrong. The reason is I'm getting stuff like: Mar. 12-2010 12/Mar-10 10-... 13 May 2010 12:43
MAX Function in VBE hi all ! is there a way to use a MAX or MIN function in VBE ?? like this..TX ! if P5 > max (P9;P10;P11) THEN P5 = ZERO END IF ... 13 May 2010 11:37
2 spreadsheets - populating one by multiplys of another Example: In spreadsheet - ONE, it is populated in a column: A B C D In spreadsheet - TWO, it is populated in a column: 1 2 3 4 **************************************** Calculated Results desired in spreadsheet - ONE: A 1 A 2 A 3 A 4 B 1 B 2 B 3 B 4 C 1 C 2 C 3 C 4 D 1 D 2 D 3 D 4 T... 13 May 2010 16:03
MS Query problem After battling with this problem for 3 years I guess it's time to ask for help. I have an Excel 2003 workbook with 6 different queries embedded. Up to 3 years ago they all worked fine. My problems may coincide with the upgrade from 2000 to 2003, but it's too easy to blame that. The queries query the same wo... 13 May 2010 07:11
Copy data into multiple workbooks Within the QA Master workbook, the boss will have a list of questions (criteria) that will be mirrored in all employee workbooks and the QA Template. If the boss adds a criteria in the QA Master workbook, I need to add it to the QA Template workbook and all employee workbooks so he does not have to go through ... 13 May 2010 17:10 |