Anthony's VBA Forum

Hi Tom,

You can use:

For i = 1 to n

Cells(i,1) = xxx

next i

"i" is the row and 1 is the column in this case.

To use the Range, you can do this

str = "A" &am ...

declare sht object first then transport your data

dim sht1 as worksheet
dim sht2 as worksheet

set sht1 = worksheets(1)
set sht2 = worksheets(2)

sht1.cells(1,1) = sht2.cells(1,1)

To call the textbox value:

Use a similar code as the following:

Worksheets("Sheet1").TextBox1.Value

Using VBA, you can change to Normal view
ActiveWindow.View = xlNormalView

and change back to Break view
ActiveWindow.View = xlPageBreakPreview

For Gamma and Beta distribution, please go to www.excel-modeling.com to find out the programs that can plot the charts.

Hi Shelly,

You have to use array to control the simulated data. Do not print each of the simulated output on the spreadsheets since it will take a lot of computer resource and slows down the syste ...

You should use the covariance. Usually you have to annualized the variance and the covariance (as well as the return).

Variance is the variance on the stock itself.

The convariance matrix shown the convariances beween the stocks. They are not expected return.

Sure Vinayan. I will see what I can do to help.

Try

ActiveCell.Formula = "=sum(" & rang1 & ":" & "rang2" & ")" Dancing Dog

Do not know what you mean. Are you using VBA to do this?

A simplest way to append formula to a cell is to follow to fashion below:

Cells(1, 1) = "=round(10.3876,1)"

You can use the for...next loop with step to access alternate rows.

Regarding your ...

You can put a boolean variable to act as a flag, when the user enter the password and granted the access, the flag will be true. This value is saved in the memory. As long as the flag value is true, ...

The easiest way is to cut each of the area on your map into pieces (image), then assign a click event to each of the images. Alternatively, you have to put the precised coordination of each of the ar ...

Hi Scott,

I replicated your program running against a cvs file (with 9 records/rows) that I just created and did not run into any problem. I even populated the values stored in the array and they ...