I am trying to use the Gauss/Jordan method as a subrouting in my code.
This is code that lets you put linear equations into a matrix and then
finds the values for the variables in the equations. I am concerned
that my rewrite has made the count off so I am not getting the answers
I expect. Can anyb
As one who tries to convert code from old programs to new, here is my
experience. If you are switching to Excel with VBA macros the inputs
and outputs become different. You can now set up a spread sheet for
inputing data. Since the data is visible you don't need to run a sub
routine to check your i
The following macro should activate worksheet Matrix Table then print
out some text and then print out the values in the Nstep_tran array.
Since I don't have a row counter, I am in the process of working out
the formula for the Else case. What follows Else is a place holder.
I cannot get the init
witch. Should I try select sheet?
On Jul 9, 2:22 pm, larry wrote:
> The following macro should activate worksheet Matrix Table then print
> out some text and then print out the values in the Nstep_tran array.
> Since I don't have a row counter, I am in the process of working out
&g
I have a macro where I copy data into an array from one sheet and then
post it in another sheet and there is something odd. .8 becomes ,
79, .15 becomes .1501. The other way around this would be
rounding. It only changes the values in the first column. Any ideas on
what is going on?
--
--
tuart Redmann wrote:
> On 20 Jul., 14:26, larry wrote:
>
> > I have a macro where I copy data into an array from one sheet and then
> > post it in another sheet and there is something odd. .8 becomes ,
> > 79, .15 becomes .1501. The other way around this would be
I think that explains it. Thanks.
On Jul 21, 11:08 am, Stuart Redmann wrote:
> On 20 Jul., larry wrote:
>
> > > > I have a macro where I copy data into an array from one sheet and then
> > > > post it in another sheet and there is something odd. .8 becomes ,
> &g
I am working through Excel for Scientists and Engineers (Numerical
methods) by E. Joseph Billo. It has several sections on the basics of
VBA
On Sep 15, 9:23 pm, SilvergunSuperman <[EMAIL PROTECTED]> wrote:
> Would anyone be able to recommend a good book to purchase wrt to
> Macros and VBA?
>
> T
I should of posted the functions. Apparently I was causing a
disconnect because the functions even though (marginally) acceptable
code in VBA were giving me !value# in Excel. Once I gave up on the
functions and just coded the formulas, the program ran correctly.
Munson, Herb wrote:
> If there is
The functions were three lines- function, equation, function end.
Since the equations did not use functions there was no typical
recursion. However, I believe since the functions= !value# for some
reason, this resulted in the stack error.
AJIT NAVRE wrote:
> Could you please mail the file. Need t
If you are doing macro coding an array can be a variable that is a
collection of values. It can be one or more dimensions depending on
how it is set up. Check your Visual Basic reference on Dim or
dimension for more info.
It can also be a set of selected values in the EXCEL spread sheet. You
will
I am trying to creat a code for caculating the number of days between
two dates. N=A-N causes a type mismacth run time error. Also looking
for any other improvements. Nested if may need to be cleared up.
Thanks for any help.
Option Explicit
Public M1 As Integer, M2 As Integer, D1 As Integer, D2
test problems.
On Dec 5, 2:13 am, lohith <[EMAIL PROTECTED]> wrote:
> Hi Larry,
>
> Try Using this formula instead.
>
> =DATE(B4,B3,B2)-DATE(D4,D3,D2)
>
> Cheers,
> Lohith
>
> On Dec 5, 12:51 am, larry <[EMAIL PROTECTED]> wrote:
>
>
>
> > I am
x27;t need to worry about an error I did not
know about.
On Dec 17, 6:19 am, "Ajay Varshney"
wrote:
> Why dont you use formula =DAYS360("Start Date","End Date")
>
> You dont need to code anything for this.
>
>
>
> On Fri, Dec 5, 2008 at 1:21
Any idea why the second case triggers run time error 1004, application
defined or object defined error. this should be standard cell input.
Thanks for the help.
Select Case Crit_Value
Case Crit_Value = 0
Cells(25, 1).Text = "No Order"
Case Crit_Value < 0
Cells(25, 1).Text = "Error
> Regards
> *Ashish **Jain*
> Analyst, CSC
> Microsoft Certified Application (Excel) Specialist
> Excel and VBA Trainer
> Author ->www.excelitems.com
> +91--40-48-43
> -----
Try making the cell text format. The prorgam is converting to
scientific notation which is why you are getting the different values.
On May 11, 1:14 pm, "2008ra...@gmail.com" <2008ra...@gmail.com> wrote:
> Hi
>
> I have a problem with my goods's code.my goods's code is that bellow
> codes and tha
I am talking about the format cells command. If you select a cell or
cells and right click you will see a format cell option. Select text
and your problem may be solved.
On May 12, 10:29 am, "2008ra...@gmail.com" <2008ra...@gmail.com>
wrote:
> i was try the cell text format.but that value is chan
I am working on a macro where I would like the program to run the main
subroutine and then run the output subroutine once and end the
program. Instead, it appears to be returning to the main program and
doing more calculations and coming back to the output again. Any ideas
on what I am missing? I
- 1
For I = 1 To Num
Prod = 0#
For J = 1 To K_degree - 1
Prod = Prod + B(J + 1) * X(I) ^ J
Next J
Y_Hat = B(I) + Prod
Diff = Y(I) - Y_Hat
Cells(I + 1, 7).Value = Y_Hat
Cells(I + 1, 8).Value = Diff
Next I
Application.EnableEvents = True
End Sub
On Jul 1, 10:59 pm, Dave Bonallack wrote:
> Hi La
integers. Real numbers may be a bit off
but at least initial numbers are close to the values I had for the
original test problem. Doing a check of my results showed that I
solved the related problem so I accept the results.
On Jul 2, 9:46 am, larry wrote:
> Thanks for the idea but it doesn't
Any idea why the code gets stuck in this function? I debug using step
into and it just starts looping.
Public Function C_D(X As Integer, T As Integer) As Variant
C_D(X, T) = Exp(-((X - T) / Sqr(10#)) ^ 2 / 2) / Sqr(20# *
Application.WorksheetFunction.Pi())
End Function
--~--~-~--~~-
t; > -Message d'origine-
> > De : excel-macros@googlegroups.com [mailto:excel-
> > mac...@googlegroups.com] De la part de larry
> > Envoyé : vendredi 10 juillet 2009 21:22
> > À : MS EXCEL AND VBA MACROS
> > Objet : [Norton AntiSpam] $$Excel-Macros$$ stuck in functi
Is there a problem changing the test value in the case code?
Example
Do
Select A-B
Case <0
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(V
Is there a proble changing the test value inside the case code?
Example
Do
Select A-B
Case <0
New A
Case 0
New A
New B
Case>0
New B
End select
Loop
--~--~-~--~~~---~--~~
--
Some impor
mand: Select Case A-B
> is valid at the time it executes,
> then changes made afterward do not affect
> previous statements.
>
> (be sure you put some kind of loop counter
> on you Do..Loop to make sure that it doesn't
> get stuck in an infinite loop...)
>
> Paul
>
I cannot recall thje exact format, but if you type something like
application or worksheet function followed by a period and then the
excel function name, it will then use the excel function
On Nov 4, 7:49 am, Howie wrote:
> I am developing an application which imports data from Excel. A few
> c
I have a series of if then statements that trigger different
instructions, numbered by Phase. Ideally, I only need the first one
that applies. If I get a second true if then stement that changes the
path and the program goes off track.
Is there a better way to write the following:
Phase=6
If No_As
Do you mean gannt chart?
On Nov 28, 1:50 am, Brajesh Kumar Porwal
wrote:
> Hi Expert,
>
> I have some activity. i want to create grant chart on this activity.
> How's make it. for help see enclose file.
> give me best solution.
>
> Regards,
> Brajesh
>
> Activity.xlsx
> 15KViewDownload
--
FORU
Another possibility- check all your loops with counters. One of them
may be exceeding the limits set up by the dimensions of the variable
you are using.
On Jan 17, 6:28 am, Secret Shot wrote:
> Dear Group,
>
> I have design a VBA tool to capture data on Excel sheet. In this tool we
> fill a VBA F
Reliable supplier of chemical research products world
wide. Our shipping and delivery is 100% safe and convenient. We are ready
to sell minimum quantities and large supplies of our product worldwide.
our products include ;
DIAZEPAM
TEAMADOL
ZOPLICONE
OXYCODONE
XANAX
VIAGRA
KETAMINE
AND MORE..
On Tuesday, 25 August 2020 01:55:59 UTC+1, larry rawlins wrote:
>
> Reliable supplier of chemical research products world
> wide. Our shipping and delivery is 100% safe and convenient. We are ready
> to sell minimum quantities and large supplies of our product worldwide.
> our p
32 matches
Mail list logo
