Jumping or Calculating
 

I am new to Excel. I'm trying to figure out if there's some way to lets say
go from A1 to A50 and keep jumping in incriments of 50 cells everytime.
Also, I am trying to figure out how to calculate the avg of each month till
the end of using all the days. How would I also go about that. Thanks for
the help.

wkoziol

Jumping or Calculating
 

Sub jump50()
For i = 1 To 200 Step 50
Cells(i, "a").Select
MsgBox ActiveCell.Address
Next i
End Sub

Now what?


More explanation of your second question.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"wkoziol" wrote in message
...
I am new to Excel. I'm trying to figure out if there's some way to lets
say
go from A1 to A50 and keep jumping in incriments of 50 cells everytime.
Also, I am trying to figure out how to calculate the avg of each month
till
the end of using all the days. How would I also go about that. Thanks
for
the help.

wkoziol

Jumping or Calculating
 

To retrieve at intervals of 50 cells, beginning with A1
In any starting cell, say in B2:
=OFFSET($A$1,ROWS($1:1)*50-50,)
Copy B2 down as far as required to return what's in A1, A51, A101, etc

To average intervals of 50 cells, beginning with A1
place this in any starting cell, say in C2:
=AVERAGE(OFFSET($A$1,ROWS($1:1)*50-50,,50))
Copy C2 down as far as required to return the average of
A1:A50, A51:A100, A101:A150, etc

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,000 Files:358 Subscribers:55
xdemechanik
---
"wkoziol" wrote:
I am new to Excel. I'm trying to figure out if there's some way to lets say
go from A1 to A50 and keep jumping in incriments of 50 cells everytime.
Also, I am trying to figure out how to calculate the avg of each month till
the end of using all the days. How would I also go about that. Thanks for
the help.

wkoziol