R1C1 And looping

fneftin

New Member
Joined
Jun 25, 2014
Messages
1
Hello everyone! I am quite new at VBA and my boss assigned me a project that requires me to calculate the average, Ann ROR, and standard deviation of various funds using a For Next loop. The spreadsheet given to me has 331 rows and 180 columns. My boss wants me to use Finalrow and FinalColumn in my code. The biggest problem that I have executing a loop is that every column has a different range, meaning that there are blank in-between cells. How would I go about calculating the average using R1C1 type code with loops for starters?
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,099,082
Messages
5,466,531
Members
406,484
Latest member
kaksolver

This Week's Hot Topics

Top