Anthony's VBA Forum Index Anthony's VBA Forum
Where the knowledge is shared
 Anthony's VBA Forum IndexHome Page
 Anthony's VBA Forum IndexForum Index
Log in to check your private messagesMessages
Log inLogin/Out

Quick Search

Advanced Search


Who's Online
[ Administrator ]
[ Moderator ]

Search found 33 matches
Anthony's VBA Forum Index
Author Message
  Topic: letter variables and column names

Replies: 1
Views: 11361

PostForum: General Excel VBA   Posted: Wed Oct 11, 2006 8:51 am   Subject: letter variables and column names
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 ...
  Topic: copy & paste data from workbooks to master workbook

Replies: 1
Views: 11604

PostForum: General Excel VBA   Posted: Wed Feb 01, 2006 12:32 pm   Subject: copy & paste data from workbooks to master workbook
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)
  Topic: How to access textbox values from excel function

Replies: 1
Views: 35822

PostForum: General Excel VBA   Posted: Wed Feb 01, 2006 12:29 pm   Subject: How to access textbox values from excel function
To call the textbox value:

Use a similar code as the following:

  Topic: removing the automatic page breaks created by MSExcel

Replies: 2
Views: 28180

PostForum: Option Pricing Models   Posted: Wed Feb 01, 2006 12:11 pm   Subject: removing the automatic page breaks created by MSExcel
Using VBA, you can change to Normal view
ActiveWindow.View = xlNormalView

and change back to Break view
ActiveWindow.View = xlPageBreakPreview
  Topic: Help needed for plotting charts/graphs

Replies: 1
Views: 11403

PostForum: General Excel VBA   Posted: Wed Feb 01, 2006 12:07 pm   Subject: Help needed for plotting charts/graphs
For Gamma and Beta distribution, please go to to find out the programs that can plot the charts.
  Topic: about simulation using VBA

Replies: 1
Views: 17448

PostForum: Monte Carlo Simulation   Posted: Wed Feb 01, 2006 12:01 pm   Subject: about simulation using VBA
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 ...
  Topic: Correlation or Covariance Matrix

Replies: 1
Views: 31332

PostForum: Portfoilio Optimization   Posted: Wed Feb 01, 2006 11:57 am   Subject: Correlation or Covariance Matrix
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.
  Topic: covariance

Replies: 1
Views: 19299

PostForum: Portfoilio Optimization   Posted: Thu Jul 21, 2005 10:45 am   Subject: covariance
The convariance matrix shown the convariances beween the stocks. They are not expected return.
  Topic: how to use functions in macros

Replies: 4
Views: 17509

PostForum: General Excel VBA   Posted: Tue Jun 21, 2005 10:33 am   Subject: how to use functions in macros
Sure Vinayan. I will see what I can do to help.
  Topic: how to use functions in macros

Replies: 4
Views: 17509

PostForum: General Excel VBA   Posted: Wed Jun 08, 2005 10:09 pm   Subject: how to use functions in macros

ActiveCell.Formula = "=sum(" & rang1 & ":" & "rang2" & ")" Dancing Dog
  Topic: Implied volatility (Newton - Raphson)

Replies: 1
Views: 23060

PostForum: Option Pricing Models   Posted: Wed Jun 08, 2005 10:04 pm   Subject: Implied volatility (Newton - Raphson)
Do not know what you mean. Are you using VBA to do this?
  Topic: Macros / Functions

Replies: 1
Views: 11560

PostForum: General Excel VBA   Posted: Wed Apr 27, 2005 1:32 pm   Subject: Macros / Functions
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 loop with step to access alternate rows.

Regarding your ...
  Topic: excel - record ID / Password

Replies: 1
Views: 17985

PostForum: Option Pricing Models   Posted: Tue Mar 15, 2005 5:23 pm   Subject: excel - record ID / Password
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, ...
  Topic: Drawing grid

Replies: 3
Views: 23545

PostForum: Probability Distributions   Posted: Fri Feb 18, 2005 1:05 pm   Subject: Drawing grid
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 ...
  Topic: Trying to Load Array from csv file

Replies: 1
Views: 14929

PostForum: General Excel VBA   Posted: Fri Jan 28, 2005 11:36 am   Subject: CVS to Array
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 ...
Page 1 of 3 Goto page 1, 2, 3  Next
All times are GMT - 4 Hours
Jump to:  

Powered by phpBB © 2001, 2002 phpBB Group