$$Excel-Macros$$ Re: MDETERM function

2008-09-29 Thread rcl2884
If I understand the question right, this is easy... Define a matrix as an array of doubles for example Dim M(2,2) as double This will be a 3X3 matrix. You can fill in the values any way you want. The determinant of this matrix is found by calling x = application.MDETERM(m) On Sep 29, 6:2

$$Excel-Macros$$ Excel Bypass Encrypted Macro Scan Options

2008-09-29 Thread yogi_bear_79
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 " you must enable macros". I found that I could make the following r

$$Excel-Macros$$ Page numbering in excel

2008-09-29 Thread vivek jain
Dear All, I prepare project reports for my clients wherein I prepare the theory part in MS Word & financials in MS Excel. In word I am able to give continuous page numbers. But in excel when I use different sheets is there any possibility to give continuous page numbers automatically. The number

$$Excel-Macros$$ MDETERM function

2008-09-29 Thread ASD
Hi All, In Excel, the "Mdeterm" function returns the matrix determinant of an array. I have a program which I needs the capability to combine the algorithm of the MDETERM function. Does anyone have any ideas about the VBA code of this? Regards, Asd --~--~-~--~~~---

$$Excel-Macros$$ Re: Excel Macros Book?

2008-09-29 Thread ASD
Wiley - Excel 2003 Power Programming With Vba - John Walkenbach On Sep 16, 4:23 am, SilvergunSuperman <[EMAIL PROTECTED]> wrote: > Would anyone be able to recommend a good book to purchase wrt to > Macros and VBA? > > Thanks in advance!!  : ) --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Page numbering in excel

2008-09-29 Thread ASD
To print your Excel worksheets in a specific order: Open the File menu. Click Page Setup. Click the Sheet tab. Under page order, you can select the way your worksheets will be printed. ASD On Sep 29, 5:32 am, "vivek jain" <[EMAIL PROTECTED]> wrote: > Dear All, > > I prepare project reports for

$$Excel-Macros$$ Re: Page numbering in excel

2008-09-29 Thread TIWARI
Hello sir, First of all to to page preview and setup then go to page u write down on first page number remove auto and write down where u are starting the numbering of page for this sheet , then u go hearder or footer choose i.e page14 when ur sheet end e.i page no.20 then u go next sheet remove a

$$Excel-Macros$$ Re: I am new to Excel VBA Macros.

2008-09-29 Thread ASD
Wiley - Excel 2003 Power Programming With Vba - John Walkenbach On Sep 29, 7:26 am, HomeRun <[EMAIL PROTECTED]> wrote: > Could some good programmers mail books of Excel VBA Macros to me ? > I want to learn it to improve work efficiency. > My email as follows: [EMAIL PROTECTED] --~--~-~--

$$Excel-Macros$$ Re: Excel Macros Book?

2008-09-29 Thread selvavinaygam
you may visit http://socko.wordpress.com and let me know the feedback. If you have anything new in macro/vba please let me know. selva On Sep 16, 6:41 pm, "johnson dara" <[EMAIL PROTECTED]> wrote: > Hi All, > > I would like to learn and start using macros as my daily life involves lot > of routin

$$Excel-Macros$$ Re: VBA - How to be a VBA programmer

2008-09-29 Thread selvavinaygam
visit http://socko.wordpress.com On Sep 3, 7:03 pm, "Mayank Patel" <[EMAIL PROTECTED]> wrote: > Hi Friends > Even i m Interested in learning VBA. Please send me also in any one have > something. > > Rgds > > Mayank > > On Wed, Sep 3, 2008 at 2:38 PM, Pranav nadkarni <[EMAIL PROTECTED]>wrote: > >

$$Excel-Macros$$ I am new to Excel VBA Macros.

2008-09-29 Thread HomeRun
Could some good programmers mail books of Excel VBA Macros to me ? I want to learn it to improve work efficiency. My email as follows: [EMAIL PROTECTED] --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To p