stevenmcheerful
New Member
- Joined
- Apr 16, 2002
- Messages
- 20
say I have columns of data that look something like this:
Date num cum avg weighted avg
1/18/02 3 3.732051 4.383049
1/19/02 1 2.414214 4.383049
1/20/02 2 3.146264 4.383049
1/21/02 1 2.414214 4.383049
1/22/02 3 3.732051 4.383049
1/23/02 3 3.732051 4.09845
1/24/02 2 3.146264 4.157029
1/25/02 4 4.236068 4.230234
and I have data from column A through col. M
and formulas in cols. C2,D2,E2 through M2.
The data will come from an ASP application, and the
LENGTH of the columns is variable. How would I
determine the number of rows in Column A (ex. 72) and then
copy the formulas in C2:M2 only down 72 times ?
How would I loop across the columns of
my worksheet to copy formulas down to
as far as my data will go ?
What event do I want to run my VBA macro ?
Would it be the Calculate event of the Worksheet ?
Date num cum avg weighted avg
1/18/02 3 3.732051 4.383049
1/19/02 1 2.414214 4.383049
1/20/02 2 3.146264 4.383049
1/21/02 1 2.414214 4.383049
1/22/02 3 3.732051 4.383049
1/23/02 3 3.732051 4.09845
1/24/02 2 3.146264 4.157029
1/25/02 4 4.236068 4.230234
and I have data from column A through col. M
and formulas in cols. C2,D2,E2 through M2.
The data will come from an ASP application, and the
LENGTH of the columns is variable. How would I
determine the number of rows in Column A (ex. 72) and then
copy the formulas in C2:M2 only down 72 times ?
How would I loop across the columns of
my worksheet to copy formulas down to
as far as my data will go ?
What event do I want to run my VBA macro ?
Would it be the Calculate event of the Worksheet ?