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

Quick Search

Advanced Search

Links
Consulting
Products

Who's Online
[ Administrator ]
[ Moderator ]


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

Replies: 1
Views: 11634

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
Data

Replies: 1
Views: 11902

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
Data

Replies: 1
Views: 36144

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:

Worksheets("Sheet1").TextBox1.Value
  Topic: removing the automatic page breaks created by MSExcel
Data

Replies: 2
Views: 28644

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
Data

Replies: 1
Views: 11713

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 www.excel-modeling.com to find out the programs that can plot the charts.
  Topic: about simulation using VBA
Data

Replies: 1
Views: 17765

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
Data

Replies: 1
Views: 31893

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
Data

Replies: 1
Views: 19711

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
Data

Replies: 4
Views: 17916

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
Data

Replies: 4
Views: 17916

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

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

Replies: 1
Views: 23447

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
Data

Replies: 1
Views: 11850

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 for...next loop with step to access alternate rows.

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

Replies: 1
Views: 18364

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
Data

Replies: 3
Views: 24013

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
Data

Replies: 1
Views: 15236

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