Hi,
I am new here and was wondering what Average(R[-29466]C:R[-29185]C
means. I am averaging column but when I look at the columns I am
averaging it is Column E4 to E285. So I am trying to figure out what
the -29466 and -29185 pertains to. It looks like a range to me.
Also, I was wondering why when I open the file, it puts the
Average on Row 29470 and not Row 286. On the output, I don't even see
Row 286..it goes straight from 285 to 29470. The rows in between those
ranges are not hidden. I am so confused.

Thank you in advance for your help.

'Average Calculation
ActiveCell.FormulaR1C1 = "Average"
Range("E29470").Select
Selection.Font.Bold = True
ActiveCell.FormulaR1C1 = "=AVERAGE(R[-29466]C:R[-29185]C)"
Range("E29470").Select
Selection.Copy
Range("F29470:H29470").Select
ActiveSheet.Paste
Range("C29470").Select
Application.CutCopyMode = False


+-------------------------------------------------------------------+
|Filename: excel error.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4457 |
+-------------------------------------------------------------------+

--
txexcel
------------------------------------------------------------------------
txexcel's Profile: http://www.excelforum.com/member.php...o&userid=32443
View this thread: http://www.excelforum.com/showthread...hreadid=522258