Hi Mr. or Ms. Anonymous,
I need the code in VBA to calculate the determinant value of a matrix.
Below, a code for calculation determinant value of 2X2 matrix.
Any suggestion?
Respectfully yours,
ASD
* * *
Private Function MyFunction_MDETERM(Range As Variant)
'function returns the matrix determ
Thanks for the reply.
But this method does not update page numbers automatically if any new page
or sheet is inserted. Can it be done by some other method
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of TIWARI
Sent: Monday, September 29, 2008 5:47 PM
To: excel-macros
I was suggesting taking advantage of the Excel function MDETERM rather
than writing your own. You can simply call the Excel function within
VBA by using "application.MDETERM". There is no doubt a clever way to
write your own procedure to do the determinent of a general nxn
matrix, but I have not
I need a macro that will add periods at specific locations in a cell
of text in Excel. My example is an item number f123456789 that I need
to look like f.123.456.789. Any suggestions? I have code written but
it is bulky and I know there is an easier way. Thanks for any and all
help.
--~--~---
On Sep 29, 3:57 pm, yogi_bear_79 <[EMAIL PROTECTED]> wrote:
> Our workbooks are protected. In order to use the workbooks you must
> enable macros. This worked fine until we started revamping for FY09.
> We have code in Thisworkbook that hides all sheets except for a
> warning page that states
Hi,
I am trying to parse data from notepad to excel using VBA macro.
A, B, C
Field4 = 8.2
Field5 = 6.7
Field6 = 59
Field7 = 5.6
A, E, F
Field4 = 7.2
Field5 = 6.9
Field6 = 60
Field7 = 5.8
I don't know how many datasets would be in a notepad.
But I want to parse this data as rows in excel sheets: