You are correct, C is my variable. Sorry I didn't post more of the code I had written. I have declared it in the code.
Sub try()
Dim c
'Dim avgCallFails
'Finding Best MobileReceivePower
'*********************************************************************************************
c=1
Sheets(“Series Formatted Data”).Select
Do While Cells(1,c) <>””
If Cells(1,c) =”MobileReceivePower” Then
Sheets("Sheet1").Cells(2, 11).Formula = "= Average(‘Series Formatted Data’!c:c)"
Elseif Cells(1,c) =” Best_EcIo_Active_Set_0” then
Sheets(“Sheet1”).Cell(2,12).Formula = “=Average(‘Series Formatted Data’!c:c)”
Elseif Cells(1,c) = “MobileTransmitPower” Then
Sheets(“Sheet1).Cell(3,12).Formula = “=Average(‘Series Formatted Data’!c:c)”
Bookmarks