Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Computer Engineering Expert

Problem:

Question- How to use MDETERM function in VBA

I would like to use the MDETERM sprreadsheet function in VBA without starting with a spreadsheet range.
I have set it up like this iinside a VBA function
Dim A()
ReDim A(2,2)
dim d as Variant
.
.
.
'Here I used some statemeents to explicitly define the contents of A
'Now, I call the MDETERM functtion
d = Application.WorksheetFunction.MDeterm(A()))
The function call fails, presumably because I am not sending it a spreadsheet range in the form A1:B2 or something like that.

Is there anny way to call the function using the array I have defined above?

PLease describe in detail.

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M91174526

Have any Question?


Related Questions in Computer Engineering

During a year of operation a firm collects 650000 in

During a year of operation, a firm collects $650000 in revenue and spends $250000 on labor expense, raw materials, rent, and utilities. The firm's owner has provided $350000 of her own money instead of investing the mone ...

Describe how to discover cookies on web browsers what is a

Describe how to discover cookies on web browsers. what is a reverse DNS lookup and can it be used when attacking the network.

We have seen how dynamic arrays enable arrays to grow while

We have seen how dynamic arrays enable arrays to grow while still achieving constant-time amortized performance. This problem concerns extending dynamic arrays to let them both grow and shrink on demand. a) Consider an u ...

You have an opportunity to buy a bond with a face value of

You have an opportunity to buy a bond with a face value of $10,000 and coupon rate of 14%, payable semi-annually. NOTE: Interest per 6-month period is 7% of Face Value (i.e. $10,000x0.07 = $700 per 6-month period).  (i) ...

Question suppose you arc a board game maker and you want to

Question : Suppose you arc a board game maker, and you want to give players a higher probability of rolling larger numbers. Originally you had them roll three six-sided dice and add their results. The new approach will h ...

Question discussion pointdefine and briefly discuss the

Question: Discussion point: Define and briefly discuss the following brainstorming techniques, the delphi technique, brainstorming, or nominal group technique. Please read the above discussion point and write the respons ...

A study investigated whether time perception an indication

A study investigated whether time perception, an indication of a person's ability to concentrate, is impaired during nicotine withdrawal. Smokers were randomly selected and asked to estimate how much time has passed duri ...

Explain how the company newmans own brand fulfills the

Explain how the company Newman's Own brand fulfills the definition of a business for profit and a non-profit business at the same time. Consider in the response the functions of business, entrepreneurship and production ...

The requirements analysis phase is an essential part of a

The requirements analysis phase is an essential part of a system development methodology. According to the FAST methodology, which stake-holders typically participate in this phase? What is the primary focus of requireme ...

Question a description of the tasks and mechanisms that

Question: A description of the tasks and mechanisms that allow you to examine the existing system (a minimum of 3 different tools should be described) A description of conceptual, logical and physical data modeling A des ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As