dim array

  1. G

    Why does #VALUE error in VBA function occur when creating a ReDim Matrix of Stock prices from a Named Range?

    ' Spot = Spot Price of the underlying ' K = Strike Price ' T = Option Maturity in Years ' rf = Interest Rate in decimal (i.e, for 5%, use 0.05) ' vol = Yearly volatility of the underlying in decimal ' n = Number of time steps ' OpType = 'C' for Call and 'P' for Put ' ExType = 'A' for...
  2. D

    what does the follow Dim's mean

    I have some code provided here and trying to understand and learn from the examples which are great. Can someone explain the following Dim values Dim S$(), N&, A%, T$(3), b% for the above statement what do these do? S$() N& A% T$(3) b% W = [Sheet1!A1].CurrentRegion.Value2 at the conclusion...
  3. G

    Loop to fill array and then paste it slows down way too much

    Hi guys, I'm struggling to find my error in the code below. It was working a while back, but now I've changed something and it no longer works and just never really completes. It doesn't throw an error, but takes forever to write the array out to the worksheet when it used to be very fast...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top